21±¾Oracle µç×ÓÊé
Oracle Database 11g A Beginner's Guide
Oracle Database 11g SQL
Oracle Database 11g SQL: Tuning Work Shop
Oracle Database 11g SQL: Tuning Work Shop Practices and Solutions
Oracle Essentials: Oracle Database 11g 4th Edition
Oracle Database 11g SQL Fundamentals I Exam Guide(Exam1Z0-051)
Oracle Database 11g A dministration I Exam Guide(Exam 1Z0-052)
Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)
Oracle Database 11g: ÃæÏò¹ÜÀíÔ±µÄÐÂÔö¹¦ÄÜ
Oracle Collaboration Suite Handbook
Oracle PL/SQL for DBAs
Oracle 10g Administration I Study Guide
Oracle 10g ÈëÃÅʵ¼ù
Oracle Database Foundations
Oracle Sql ±Ø±¸²Î¿¼
Oracle ±¸·ÝÓë»Ö¸´Åàѵ½Ì³Ì
Oracle 9i PL/SQL ³ÌÐòÉè¼Æ
Oracle ¾«Ëè(9i,8i,8)
Oracle 9i Êý¾Ý¿â¹ÜÀíÔ±Ö¸ÄÏ
Oracle 9i Êý¾Ý¿âϵͳÅàѵ½Ì³Ì
Oracle ר¼Ò¸ß¼¶±à³Ì
Ïà¹ØÎĵµ£º
select * from test where rownum <=10 ÏÂÃæÊǹØÓÚrownumµÄ½éÉÜ ================================ RownumºÍrow_number() over()µÄʹÓà ROWNUMÊÇOracle´Ó8¿ªÊ¼ÌṩµÄÒ»¸öαÁУ¬ÊǰÑSQL³öÀ´µÄ½á¹û½øÐбàºÅ£¬Ê¼ÖÕ´Ó1¿ªÊ¼£¬³£¼ûµÄÓÃ;¾ÍÊÇÓÃÀ´·ÖÒ³Êä³ö. ±ÈÈç SELECT * from torderdetail a WHERE ROWNUM <= 10 ÕâÌõÓï¾ä¾ ......
´ÓAIX ½Ç¶È£¬ÎÒÃÇ¿ÉÒÔÔÚÏÂÃæÈý¸ö½Ç¶ÈºâÁ¿ÄÚ´æÊ¹ÓõĺÏÀíÐÔ
1>¼õÉÙÒ³Ãæ½»»»²Ù×÷
µ±²Ù×÷ϵͳÐèÒª¸ü¶àÄÚ´æÒ³ÒÔÖ§³ÖÆäËûÓ¦ÓÃÔËÐÐʱ£¬²Ù×÷ϵͳ½«ÒÀ¾ÝijÖÖËã·¨£¨LRUËã·¨£©°Ñµ±Ç°×¤ÁôÔÚÄÚ´æÖеÄijЩ
Êý¾ÝÒ³"Page Out"£¬Ò²¾ÍÊǰÑÄÚ´æÖеÄÊý¾ÝÒ³´ÓÄÚ´æ¶Î×ªÒÆµ½ÎïÀí´ÅÅÌ¡£ÏÔÈ»£¬ÕâÖÖÀàÐ͵IJÙ×÷»áÓ°ÏìÕû¸öϵͳµÄÔËÐÐÐÔÄÜ¡£
¶ÔÓÚ ......
Èý¡¢Ê¹ÓÃSchedules
¡¡¡¡10g ÖÐÐÂÍÆ³öµÄSCHEDULER¿ÉÄÜȷʵ»áÈúܶà³õ½Ó´¥µÄÅóÓѸоõÔÎÍ·ÔÎÄÔ£¬Ïà±È֮ǰµÄjobs£¬SCHEDULERÖÐÐÂÔöµÄ¸ÅÄîÌ«¶à¡£±ÈÈç˵jobs£¬ÈÔÈ»¿ÉÒÔÀí½â³É֮ǰ°æ±¾ÖеÄjobs£¬²»¹ý¹¦Äܸü¼ÓÇ¿´ó(×¢Òâ10gÖÐÒ²ÈÔÈ»¿ÉÒÔʹÓÃÆÕͨjobs£¬ÕâÊÇ·Ï»°£¬ÏàÐÅ¿´±¾ÆªÎÄÕµÄÅóÓÑĿǰӦ¸Ã»¹ÊÇÕâÑùÔÚÓÃ)£¬±ÈÈç˵program£¬Ö¸µÄÊÇÔ ......
´´½¨job
jobÊÇÊ²Ã´ÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶¨ ......
select s.username,
decode(l.type,'TM','TABLE LOCK',
'TX','ROW LOCK',
& ......