oracleµÄ·ÖÒ³¼¼Êõ
֮ǰÔÚÏîÄ¿ÖÐÓõ½µÄ·ÖÒ³¶¼ÊǼٷÖÒ³£¬Ò²¾ÍÊÇÏÈ´ÓÊý¾Ý¿âÖаÑËùÓеÄÊý¾Ý¶¼²éѯ³öÀ´È»ºóÔÚ°ó¶¨Ê±½øÐзÖÒ³¡£ÕâÊÇÒ»ÖÖ¼Ù·ÖÒ³£¬Ð§Âʽϵͣ¬Ç°¼¸ÌìÌýÆäËûÏîÄ¿×é˵ËûÃÇҪʹÓÃÊý¾Ý¿âµÄ´æ´¢¹ý³ÌÀ´ÊµÏÖ·ÖÒ³£¬¸Ð¾õºÜÒÉ»ó£¬ÄѵÀʹÓÃÊý¾Ý¿â»¹¿ÉÒÔʵÏÖ·ÖÒ³¹¦ÄÜ£¿ÏÐÀ´ÎÞÊ£¬¾Í´ÓÍøÉÏËÑÁËËÑ×ÊÁÏ£¬¹ûÈ»£¬ÔÚoracleÖÐÊÇÓзÖÒ³¼¼ÊõµÄ£¬Ê¹ÓÃrownum¾Í¿ÉÒÔʵÏÖ¡£°¦£¬¿ÉÕæÊǹª¹ÑÎŰ¡¡£Á¬Õâ¸ö¶¼²»ÖªµÀ¡£¿´À´×Ô¼ºÒªÑ§Ï°µÄ»¹Óкܶడ¡£
ÔÚÍøÉÏ¿´µ½Ò»Æª²©¿Í£¬½²oracleµÄrownum¡£¾õµÃͦ²»´í£¬ÏȰÑÍøÖ·¼ÇÏÂÀ´ÒÔ±¸²é¡£
http://blog.csdn.net/mitedu/archive/2008/12/23/3584399.aspx
Ïà¹ØÎĵµ£º
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨£¨Ð轨¿â£©
±¸·Ý£º
Ö±½Ó¿½±´oracleĿ¼ÏµÄadmin¡¢oradataÁ½¸öÎļþ¼Ð£¬ora92Ŀ¼ÏÂdatabase£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´£º
1.´´½¨Ò»¸öºÍÔÀ´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý¾Ý¿âÃû±ØÐëºÍÔÀ´Ò»ÖÂ)
2.ÓùÜÀíÔ±Á¬ÈëÊý¾Ý¿âºóÍ£Ö¹Êý¾Ý¿â¡£
3.°Ñ°²×°Ä¿Â¼ÏµÄadminºÍoradata¸´ÖƹýÈ¥¸²¸Ç£¨Èç¹û´æÔÚ ......
´ÓAIX ½Ç¶È£¬ÎÒÃÇ¿ÉÒÔÔÚÏÂÃæÈý¸ö½Ç¶ÈºâÁ¿ÄÚ´æÊ¹ÓõĺÏÀíÐÔ
1>¼õÉÙÒ³Ãæ½»»»²Ù×÷
µ±²Ù×÷ϵͳÐèÒª¸ü¶àÄÚ´æÒ³ÒÔÖ§³ÖÆäËûÓ¦ÓÃÔËÐÐʱ£¬²Ù×÷ϵͳ½«ÒÀ¾ÝijÖÖËã·¨£¨LRUËã·¨£©°Ñµ±Ç°×¤ÁôÔÚÄÚ´æÖеÄijЩ
Êý¾ÝÒ³"Page Out"£¬Ò²¾ÍÊǰÑÄÚ´æÖеÄÊý¾ÝÒ³´ÓÄÚ´æ¶Î×ªÒÆµ½ÎïÀí´ÅÅÌ¡£ÏÔÈ»£¬ÕâÖÖÀàÐ͵IJÙ×÷»áÓ°ÏìÕû¸öϵͳµÄÔËÐÐÐÔÄÜ¡£
¶ÔÓÚ ......
ÕâÆªÂÛ̳ÎÄÕ£¨ÈüµÏÍø¼¼ÊõÉçÇø£©Õë¶ÔDBMS_SCHEDULERµÄʹÓ÷½·¨½øÐÐÁËÏ꾡µÄ½éÉÜ£¬¸ü¶àÄÚÈÝÇë²Î¿¼ÏÂÎÄ£º
DBMS_SCHEDULERÊÇOracle 10GÖÐÐÂÔöµÄÒ»¸ö°ü£¬ÓëÀϰ汾µÄdbms_job°üÏà±È£¬dbms_schedulerÓкܶàÐÂÌØÐÔ£¬ÎÒ½«Í¨¹ýһϵÁеÄÎÄÕÂÀ´½éÉÜÒ»ÏÂÈçºÎʹÓÃÕâ¸ö°ü.
1. ´´½¨job
job ......
´øUNION ALLÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂ
1. ¶¨ÒåµÄ²éѯµÄunion all²Ù×÷±ØÐëÔÚ×î¶¥µÈ¼¶£¨²éÑ¯ÖØÐ´ºó£©
2. ÎﻯÊÓͼÈÕÖ¾Ö¸¶¨rowidºÍincluding new values
3. Èç¹û±íÉèÉæ¼°µ½Ò»¸ö´óÁ¿µÄinsert»òÕßÖ±½Ó·¾¶¼ÓÔØ£¬deletes,update£¬Ö¸¶¨sequencea
4. fromÁбí ......
½ñÌìͬÊÂÓöµ½ÁËÒ»¸öÎÊÌ⣬ÔÒòÊÇrownumµÄÎÊÌâ¡£
ÏÂÃæ×ªÒ»ÆªÎÄÕ£º
¶ÔÓÚOracleµÄrownumÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>£¬>=£¬=£¬between……and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ£¨<¡¢& lt;=¡¢£¡=£©£¬²¢·Ç˵ÓÃ>£¬>=£¬=£¬between……and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖË ......