oracle¼ÈëµÂÎÄÊý¾ÝµÄ´¦Àí - Oracle / ¸ß¼¶¼¼Êõ
ÎÒÔÚ°²×°oracleʱĿǰÓõÄÊÇALU32UTF8×Ö·û¼¯£¬ÏÖÔÚÎÊÌâʱÔÚÓÃÃüÁîÌáʾ·û½øÐÐÊý¾ÝÌí¼Óʱ³öÏÖÂÒÂ𣬱ÈÈçGießen
Êý¾Ý¿âÖÐGie?enÕâÑùÏÔʾÁË£¬ÓÐʲô°ì·¨½â¾öÂð£¿
Ôö¼ÓµÂÎÄ×Ö·û¼¯°¡
Ôö¼ÓµÂÎÄ×Ö·û¼¯°¡ ?¾ßÌåЩºÃÂð£¿
ÔÚÏߵȣ¬²»Òª²»»á°¡£¡
Ò»Ö±¶¥
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
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 / ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB
Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí
ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......