oracleÓÐÄÄЩ·½±ãÒ×ÓõĿͻ§¶Ë?
oracleÓÐÄÄЩ·½±ãÒ×ÓõĿͻ§¶Ë?
²Î¿¼£º
http://school.itzcn.com/special-spid-48.html
ÔÎ...
ÎÒ˵µÄÊÇoracle
ÎÒÃÇÓõÄtoad »¹ÓÐ pl/sql ¶¼ÊǺÃÓõġ£
¸öÈ˸оõtoad²»Õ¦µØ¡£ »¹ÊÇplsql °É£¡
¸òó¡ Ì«¸´ÔÓÁ˵ã..
Ö÷ÒªÊÇ
pl/sql developer
Æä´Î
sql plus
pl/sql »¹ÊDZȽϺÃÓõÄ
sql plus
Hi,
1)Sql plus
2)PL/SQL
3)Toad
4)sql developer
5)Golden32
toad
sql navigator
ÎÒÃÇͬʶ¼ÓÃPL/sql
ËüÊÇÊý¾Ýºǫ́,»ù±¾ÉÏËùÓеÄÃæÏó¶ÔÏóÓï¾ä¶¼Ö§³ÖËü...
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......