ÇóÖú£¬ oracleÎÊÌâ
ÎÒÔÚlinuxÖÕ¶ËÏ ִÐÐoracleÃüÁî ´´½¨Ò»¸ö±í »òÕß±ðµÄʲôÃüÁÐèÒª´òºÜ¶àÐУ¬ÓÐʱºò´òµ½µÚÊ®ÐеÄʱºò·¢ÏÖµÚ¾ÅÐÐÓеط½³ö´íÁË£¬ÐèÒªÐÞ¸Ä µ«Êǻز»µ½ÉÏÃæÒ»ÐУ¬Ö»ÄܰÑËùÓÐÃüÁîÖØÐÂÔÙ´òÒ»±é£¬ºÜ¿àÄÕ£¬Çë½Ì¸÷λ´óϺ£¬ÔõôÑùÔÚ´ò´íÃüÁîµÄʱºò»Øµ½ÉÏÒ»ÐУ¬½øÐÐÐÞ¸Ä
ÓõÚÈý·½¹¤¾ß£¬»òÕßд½Å±¾£¬Ö´ÐеÄʱºòÖ±½ÓÖ´ÐÐÏà¹ØµÄ½Å±¾
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
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 / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
ÔÚOracle Êý¾Ý¿âÖÐÔõô²éǰÈýÌõ¼Ç¼½µÐò£»
select * from
(select * from table order by col_name desc)
where rownum<=3;
select * from
(
select s.*,rownum rn
from t3 s
)
where ......