oracleÌåϵ½á¹¹ÎÊÌ⣡
oracle Ìåϵ½á¹¹ÎÊÌâ»¹Õæ²»ºÃ¶®£¬±ÈÈçʲôÊÇSID£¬Àý³Ì£¬service_name£¬Êý¾Ý¿â£¬Ê²Ã´ÎïÀíÉÏ£¬Âß¼ÉÏ£¬ÕæÊǸããÂÁË¡£
Â¥Ö÷Ó¦¸Ã´Ó»ù´¡Ñ§Æð ÍøÉÏÓкܶà×ÊÔ´
°²×°¸ö×ֵ䣬Ȼºó¿´ oracle concept £¬×Ðϸ¿´Ò»Ï¾ÍÃ÷°×ÁË¡£
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî)
È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éoracleµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ¼¸Ò³£©
ÎïÀí½á¹¹£ºÊý¾Ý£¬ÈÕÖ¾£¬¿ØÖÆ£¬ÅäÖÃÎļþ¡£
1.Êý¾Ý¿â:
Âß¼½á¹¹£º±í¿Õ¼ä£¬¶Î£¬Çø£¬¿é¡£
oracleÌåϵ½á¹¹£º SGA£ºÊý¾Ý¿é»º³åÇø£¬×ֵ仺³åÇø£¬ÖØ×öÈÕÖ¾»º³åÇø£¬¹²ÏíSQL³Ø¡£
ÄÚ´æ½á¹¹£º
PGA
2.ʵÀý:
&nbs
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......