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

oracleµÇ½ÎÊÌâ

ÎҵǽOEMC£¨ÆóÒµ¹ÜÀí¿ØÖÆÌ¨£©ºó¶Ï¿ªÁ¬½Ó£¬Ôٴεǽʱ³öÏÖÓû§Ãû¼ìË÷ʧ°ÜµÄ´íÎó£¬ÖØÐÂÆô¶¯OEMCºó¿ÉÒÔÁ¬ÉÏ£¬ÕâÊÇʲôԭÒò£¿
\oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.oraÀïµÄÕâ¸ö²ÎÊý
SQLNET.AUTHENTICATION_SERVICESÉèÖÃΪNOÊÔÏÂ


±È½ÏÉÙʹÓÃOEMC¡£¡£¡£¹Ø×¢Ï£¬Ñ§Ï°

¹Ø×¢Ò»Ï£¡

¾ßÌåʲô´íÎó£¬ÌùÉÏÀ´¿´¿´

½¨ÒéÉÙÓÃͼÐι¤¾ß£¬»Ø¹éʯÆ÷ʱ´ú£¬Ò»¸öÒ»¸ö×ÖÇá£

ÒýÓÃ
±È½ÏÉÙʹÓÃOEMC¡£¡£¡£¹Ø×¢Ï£¬Ñ§Ï°


DAY DAY UP!


Ò»¸öÒ»¸öµÄÇòÅÏÔµÃרҵ¡£¡£¹þ¹þ

ÏÖÔÚ»¹ÔÚ¿ØÖÆÌ¨Âë×Ö


Ïà¹ØÎÊ´ð£º

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

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

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

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

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ºÅ