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

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 ר¼Ò¸ß¼¶±à³Ì



Ïà¹ØÎĵµ£º

oracleÀ䱸·Ý »Ö¸´

·½·¨Ò»£º×î¼òµ¥µÄ·½·¨£¨Ð轨¿â£©
±¸·Ý£º
  Ö±½Ó¿½±´oracleĿ¼ÏµÄadmin¡¢oradataÁ½¸öÎļþ¼Ð£¬ora92Ŀ¼ÏÂdatabase£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´£º
1.´´½¨Ò»¸öºÍÔ­À´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý¾Ý¿âÃû±ØÐëºÍÔ­À´Ò»ÖÂ)
2.ÓùÜÀíÔ±Á¬ÈëÊý¾Ý¿âºóÍ£Ö¹Êý¾Ý¿â¡£
3.°Ñ°²×°Ä¿Â¼ÏµÄadminºÍoradata¸´ÖƹýÈ¥¸²¸Ç£¨Èç¹û´æÔÚ ......

ORACLEµ÷ÓÅÖ® ÄÚ´æ½á¹¹µ÷ÓÅ£¨Õª×ÔÎÄÆ½Ê飩

´ÓAIX ½Ç¶È£¬ÎÒÃÇ¿ÉÒÔÔÚÏÂÃæÈý¸ö½Ç¶ÈºâÁ¿ÄÚ´æÊ¹ÓõĺÏÀíÐÔ
1>¼õÉÙÒ³Ãæ½»»»²Ù×÷
µ±²Ù×÷ϵͳÐèÒª¸ü¶àÄÚ´æÒ³ÒÔÖ§³ÖÆäËûÓ¦ÓÃÔËÐÐʱ£¬²Ù×÷ϵͳ½«ÒÀ¾ÝijÖÖËã·¨£¨LRUËã·¨£©°Ñµ±Ç°×¤ÁôÔÚÄÚ´æÖеÄijЩ
Êý¾ÝÒ³"Page Out"£¬Ò²¾ÍÊǰÑÄÚ´æÖеÄÊý¾ÝÒ³´ÓÄÚ´æ¶Î×ªÒÆµ½ÎïÀí´ÅÅÌ¡£ÏÔÈ»£¬ÕâÖÖÀàÐ͵IJÙ×÷»áÓ°ÏìÕû¸öϵͳµÄÔËÐÐÐÔÄÜ¡£
¶ÔÓÚ ......

È«ÃæÑ§Ï°ORACLE SchedulerÌØÐÔ(1)´´½¨jobs

Ëùν³öÓÚjob¶øÊ¤ÓÚjob£¬ËµµÄ¾ÍÊÇOracle 10gºóµÄÐÂÌØÐÔSchedulerÀ²¡£ÔÚ10g»·¾³ÖУ¬ORACLE½¨ÒéʹÓÃSchedulerÌæ»»ÆÕͨµÄjob£¬À´¹ÜÀíÈÎÎñµÄÖ´ÐС£Æäʵ£¬½«SchedulerÃèÊö³É¹ÜÀíjobµÄ¹¤¾ßÒѾ­Ì«¹ýÆ¬ÃæÁË£¬10G°æ±¾ÖÐÐÂÔöµÄScheduler¾ø²»½ö½öÊÇ´´½¨ÈÎÎñÕâô¼òµ¥¡£¡£¡£¡£
Ìáʾ£ºORACLEÖйÜÀíSchedulerÊÇͨ¹ýDBMS_SCHEDULER°ü£¬±¾ÕÂÒ ......

È«ÃæÑ§Ï°ORACLE SchedulerÌØÐÔ(2)¹ÜÀíjobs

1.2 ¹ÜÀíJobs
1.2.1 ÆôÓÃJobs
¡¡¡¡Ç°Ãæ´´½¨JOBʱ£¬ÓÉÓÚδÏÔʽµÄÖ¸¶¨ENABLED²ÎÊý£¬Òò´Ë¼´Ê¹Ö¸¶¨ÁËSTART_DATE£¬²»¹ýĬÈÏÇé¿öÏÂJOB²»»á×Ô¶¯Ö´ÐС£¶ÔÓÚÕâÖÖÇé¿ö£¬DBMS_SCHEDULER°üÖÐÌṩÁËÒ»¸ö¹ý³ÌENABLE£¬¿ÉÒÔÓÃÀ´ÐÞ¸ÄJOBµÄÆôÓÃ״̬£¬µ÷Ó÷½Ê½·Ç³£¼òµ¥£¬ÀýÈ磺
SQL> exec dbms_scheduler.enable(¨INSERT_TEST_TBL& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ