ÄÄλÓùýoracle apex£¬ÖªµÀ±¨±íµÄ¸ßÁÁÏÔʾ
ÄÄλÐǪ̈Óùýoracle apex.ÎÒÓÐÒ»¸ö±¨±í£¬ÆäÖÐһЩÐÅÏ¢ÐÐÐèÒª¸ßÁÁÍ»³öÏÔʾ£¬²»Öª
ÈçºÎ²Ù×÷£¬ÖªµÀµÄÖ¸µãϹþ
ûÈËÓùýapexô£¬ÄÇôÓÐûÓÐʲô·½·¨¿ÉÒÔ´Óselect²éѯ³öµÄ½á¹ûÖУ¬½«ÎÒÏ£ÍûÍ»³öÏÔʾµÄÐÅÏ¢¸ßÁÁÏÔʾ
¹ýÍêÄêÀ¡£À´¸ö¸ßÈ˰É
HELP
Í·Í´
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......