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

oracle¶¨Ê±ÈÎÎñ£¨dbms_job£©

½ñÌì×ܽáÏÂoracleµÄÈÎÎñ¶ÓÁйÜÀíÆ÷(job queue ),ÒÔºóÒ²·½±ã²éѯ.
 ÎÒÃÇÒª×ö¶¨Ê±ÈÎÎñʱ,ÓÐÁ½ÖÖ°ì·¨
Ò»ÖÖÊÇ: ²Ù×÷ϵͳµÄ¶¨Ê±,winµÄ¶¨Ê±ÈÎÎñ,unixµÄcrontab
Ò»ÖÖÊÇ: Êý¾Ý¿â¼¶µÄ¶¨Ê±,ËýµÄЧÂʸü¸ß,
ÔÙÓдóÁ¿µÄ±í¼¶²Ù×÷ʱ,½¨ÒéÓÃÊý¾Ý¿â±¾ÉíµÄjob queue,ÕâÑù·½±ã,ЧÂʸß;Èç¹ûÓÃϵͳ¼¶¶¨Ê±,
»áÔö¼ÓºÜ¶à±à³Ì¹¤×÷,³É±¾Ôö¼ÓÁË,»¹ºÜÈÝÒ׳ö´í,ÊÂÇéÔ½¼òµ¥³ö´íµÄ¼¸ÂÊԽС.
ÔÙʹÓÃjob queue֮ǰ,ÎÒÃÇ»¹Òª¼òµ¥ÅäÖÃÏÂ,oracle¶¨Ê±Ö´ÐÐjob queue µÄºǫ́½ø³ÌÊÇSNP,ÒªÆô¶¯
snp,Ê×ÏÈ¿´ÏµÍ³Ä£Ê½ÊÇ·ñÖ§³Ö
sql> alter system enable restricted session;
»ò
sql> alter system disenable restricted session;
ÀûÓÃÉÏÃæµÄÃüÁî¸ü¸ÄϵͳµÄ»á»°·½Ê½Îªdisenable restricted,ΪsnpµÄÆô¶¯´´½¨Ìõ¼þ.
ÔÙÓоÍÊÇÅäÖÃjob queueµÄÆô¶¯²ÎÊý,snpµÄÆô¶¯²ÎÊýλÓÚoracleµÄ³õʼ»¯ÎļþÖÐ,
job_queue_processes=10   (oracle10gde ĬÈÏÖµ)
job_queue_interval=N
µÚÒ»Ðж¨Òåsnp½ø³ÌµÄÆô¶¯¸öÊýΪ10,Õý³£µÃÅ®¹ÚÒ»·¶Î§ÊÇ0-36,¸ù¾ÝÈÎÎñµÄ¶àÉÙ,¿ÉÒÔÅäÖÃ
²»Í¬µÄÊýÖµ.
µÚ¶þÐж¨Òåϵͳÿ¸ô¼¸Ã뻽ÐѸýø³ÌÒ»´Î.ȱʡÊÇ60,Õý³£·¶Î§ÊÇ1-3600Ãë.ÊÂʵÉÏ£¬¸Ã½ø³ÌÖ´ÐÐÍê
µ±Ç°ÈÎÎñºó£¬¾Í½øÈë˯Ãß״̬£¬Ë¯ÃßÒ»¶Îʱ¼äºó£¬ÓÉϵͳµÄ×ܿظºÔð½«Æä»½ÐÑ¡£ 
Èç¹û¸ÃÎļþÖÐûÓÐÉÏÃæÁ½ÐУ¬Çë°´ÕÕÈçÉÏÅäÖÃÌí¼Ó¡£ÅäÖÃÍê³Éºó£¬ÐèÒªÖØÐÂÆô¶¯Êý¾Ý¿â£¬Ê¹ÆäÉúЧ
¡£×¢Ò⣺Èç¹ûÈÎÎñÒªÇóÖ´Ðеļä¸ôºÜ¶ÌµÄ»°£¬NµÄÅäÖÃÒ²ÒªÏàÓ¦µØÐ¡Ò»µã¡£
²é¿´job queueµÄÏêϸÐÅÏ¢,²éѯÊý¾Ý¿â×Öµä user_jobs
eg:
 sql> select job,next_date,next_sec,broken from user_jobs;
°üº¬ÒÔÏÂ×Ó¹ý³Ì£º 
Broken()¹ý³Ì¡£
change()¹ý³Ì¡£
Interval()¹ý³Ì¡£
Isubmit()¹ý³Ì¡£
Next_Date()¹ý³Ì¡£
Remove()¹ý³Ì¡£
Run()¹ý³Ì¡£
Submit()¹ý³Ì¡£
User_Export()¹ý³Ì¡£
What()¹ý³Ì¡£
1¡¢
Broken()¹ý³Ì¸üÐÂÒ»¸öÒÑÌá½»µÄ¹¤×÷µÄ״̬£¬µäÐ͵ØÊÇÓÃÀ´°ÑÒ»¸öÒÑÆÆ¹¤×÷±ê¼ÇÎªÎ´ÆÆ¹¤×÷¡£
Õâ¸ö¹ý³ÌÓÐÈý¸ö²ÎÊý£ºjob ¡¢brokenÓënext_date¡£
PROCEDURE Broken (job       IN binary_integer,
                  Broken    IN boolean,
                  next_dat


Ïà¹ØÎĵµ£º

ORACLE°ó¶¨±äÁ¿µÄʹÓà ժ³­×ÔһƬÌû×Ó

±¾ÎÄÀ´×Ôhttp://www.cnblogs.com/rootq/articles/1177562.html
Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐË­¶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ ......

ά»¤Oracle³£ÓÃSQLÓï¾ä

       ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
¡¡¡¡select * from v$version;
¡¡¡¡²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
¡¡¡¡select sum(bytes)/(1024*1024) as free_space,tablespace_name
¡¡¡¡from dba_free_space
¡¡¡¡group by tablespace_name;
¡¡¡¡SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES ......

Using Oracle Trace Analyzer (trcanlzr.sql)


Using Oracle Trace Analyzer (trcanlzr.sql)
Dave Moore:  Author of Oracle Utilities
Oracle has provided another utility initially designed for performance tuning Oracle Applications.  Trace Analyzer is provided in the form of a PL/SQL package (TRCA$ ).  The Trace Analyzer utility i ......

ORACLE Êý¾Ý¿âÃû¡¢ÊµÀýÃû¡¢ORACLE_SIDµÄÇø±ð

Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚÇ ......

ORACLE ³£ÓÃ×Ö·ûº¯Êý


1.LOWER(str) Ç¿ÖÆÐ¡Ð´
2.UPPER(str) Ç¿ÖÆ´óд
3.INITCAP(str) ÿ¸öµ¥´ÊÊ××Öĸ´óд
ʾÀý£º
SQL> select initcap('my_boy') from dual; --·µ»Ø"My_Boy"
×¢Ò⣺µ¥´ÊÖ®¼äÓÃÏ»®Ïߣ¨"_"£©·Ö¸î
4.CONCAT(str1,str2£©Á¬½Óº¯Êý,Á¬½Óstr1ºÍstr2×Ö·û´®
5.SUBSTR(string,a[,b])·µ»ØstringµÄÒ»²¿·Ö£¬aºÍbÒÔ×Ö·ûΪµ¥Î»¡£´Ó× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ