Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle·þÎñ¾­³£×Ô¶¯¹Ø±Õ£¬Çë´ó¼Ò°ï棬ºÜ¼±£¡

oracle·þÎñ¾­³£×Ô¶¯¹Ø±Õ£¬Çë´ó¼Ò°ï棬ºÜ¼±£¡

·þÎñÆ÷ÊÇIBM X3650 ¡¢2C £¨Ö÷Ƶ2.0£© ¡¢4GÄÚ´æ ¡£
²Ù×÷ϵͳÊÇ windows 2003

oracle°æ±¾ÐÅÏ¢£º
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

oracle·þÎñ¾­³£×Ô¶¯¹Ø±Õ£¬²»ÖªµÀÊDz»ÊÇ×ÊÔ´²»×ãÒýÆðµÄ¡£
²é¿´ÊµÀý¾¯¸æÈÕÖ¾¡£


ʵÀý¹Ø±Õ£¬ÀïÃæÒ»°ã¶¼ÓмǼ¡£

ÏÈ¿´¿´ ALERT.LOG

àÅ£¬windowsÉÏ×ÜÊǹÖʶà¶à¡£

Ò»Ö±ÔÚÆÚ´ý,°ïÄã¶¥¡£

¿´ÈÕÖ¾

googleÏÂ

¿´¾¯±¨ÈÕÖ¾£¬alter_sid.log

¿´¿´ÈÕÖ¾ºÍWindowµÄÈÕÖ¾¹ÜÀíÆ÷ÀïµÄ´íÎóÈÕ־ϰÐÅÏ¢¡£

°Ñ¸æ¾¯ÈÕÖ¾Ìù³öÀ´  ²»È»Ë­ÖªµÀÔõô»ØÊÂ

ÒýÓÃ
ÏÈ¿´¿´ ALERT.LOG


...

²»ºÃÒâ˼£¬Õ⼸Ììһֱ棬ûÓлظ´£¬ÎÒµÄÎÊÌâ½â¾öÁË£¬Ð»Ð»´ó¼Ò¹ØÐÄ¡£

ÔΣ¬½â¾öÍê²»½áÌù¡£¡£¡£¡£¡£


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ