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
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    ±¾ÎÄÀ´×Ôhttp://www.cnblogs.com/rootq/articles/1177562.html
Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ
¹Ø¼ü´Ê: 
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ ......
	
    
        
    
           ÈçºÎÔ¶³ÌÅжÏ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)
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 ......
	
    
        
    
    Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚÇ ......
	
    
        
    
    
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ÒÔ×Ö·ûΪµ¥Î»¡£´Ó× ......