ÍÆ¼ö¼¸±¾oracleºÃÊ飬²»Å¹ó
ÖÐÎİæµÄ£¬Ð»Ð»
ÆðÂëҪ˵ÊÇ¿ª·¢»¹ÊǹÜÀíµÄ°É£¿
ÏÈÂò¿ª·¢°É£¬¸ßÊÖ¸øÍƼö¼¸±¾£¬·Ç³£¸Ðл
Ê×ÍÆÕâ±¾ÁË£º¡¶Oracle9i&10g±à³ÌÒÕÊõ£ºÉîÈëÊý¾Ý¿âÌåϵ½á¹¹¡·
ÍøÉÏÓÐÖÐÎİæµÄpdf£¬²»¹ýÓÐһЩoracleµÄ¿ª·¢ºÍµ×²ãÔÀí»ù´¡£¬¿´ÆðÀ´Ð§¹û»áºÃЩ¡£
ÕâÊé²»»á¸æËßÄãÄÇЩ»ù´¡Óï·¨Ôõôд£¬Èç¹ûÊÇÐèÒªÓï·¨Ê飬ÄÇôҲ²»ÓÃÍÆ¼öÁË£¬Ëæ±ãÂò±¾»ò¿´oracle¹Ù·½Îĵµ¼´¿É¡£
лл3Â¥£¬ÄÜÔÙ¶àÍÆ¼ö¼¸±¾Â𣿿ª·¢»òÕß¹ÜÀíµÄÊé¶¼¿ÉÒÔ
Oracle9i&10g±à³ÌÒÕÊõ£ºÉîÈëÊý¾Ý¿âÌåϵ½á¹¹ ´óʦµÄ
²»ÖªµÀÄãÐèÒªÄÄÖ̶ֳȵÄÊé¡£
ÎÒÕýÔÚ¿´¡¶Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯¡·Óë¡¶Oracle Wait InterfaceÐÔÄÜÕï¶ÏÓëµ÷Õûʵ¼ùÖ¸ÄÏ¡·£¬Í¦²»´í¡£
Èç¹ûÊÇÈëÃÅ£¬¡¶OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏÈ«²áOracle Database 10g¡·Õâ±¾ÊéÒ²²»ÄÜ´í¹ý¡£
лл2λ »Ø¸´ÄÚÈÝÌ«¶ÌÁË
¡¶Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯¡· Õâ±¾¿´¹ýÁË£¬ ²»´í¡£
¡¶Oracle Wait InterfaceÐÔÄÜÕï¶ÏÓëµ÷Õûʵ¼ùÖ¸ÄÏ¡· »¹Ã»Óп´¡£ ÍøÉÏËÑËÑ¿´....
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......