Ïê½âOracleÊý¾Ý¿âÓÅ»¯·½°¸Óëʵ¼ù
ÔÚÕâÀïÎÒÃǽ«½éÉÜOracleÊý¾Ý¿âÓÅ»¯·½°¸Óëʵ¼ù£¬²»Í¬µÄ»·¾³»áÓв»Í¬µÄµ÷ÊÔ£¬µ«ÊÇÒ²»áÓвî±ð£¬Ï£Íû´ó¼ÒÄܺÏÀíµÄÎüÊÕ¡£ Ò»¡¢Ç°ÑÔ ¶þ¡¢ORACLEÊý¾Ý¿âÓÅ»¯¸ÅÊö 1¡¢ÄÚ´æµÈ²ÎÊýÅäÖõÄÓÅ»¯ 2¡¢¼õÉÙÎïÀí¶ÁдµÄÓÅ»¯ 3¡¢ÅúÁ¿Öظ´²Ù×÷µÄSQLÓï¾ä¼°´ó±í²Ù×÷µÄÓÅ»¯ ¶þ¡¢ORACLEÊý¾Ý¿âÓÅ»¯·½°¸ 1¡¢ÄÚ´æµÈOracleϵͳ²ÎÊýÅäÖà 2¡¢Ê¹ÓÃË÷Òý 3¡¢±í·ÖÇø 4¡¢ProcedureÓÅ»¯ 5¡¢ÆäËû¸ÄÔì 6¡¢Î¬»¤×÷Òµ¼Æ»® Èý¡¢ORACLEÊý¾Ý¿âÓÅ»¯Ç°ºó±È½Ï 1¡¢ÅúÁ¿Öظ´µÄSQLÓï¾äÖ´ÐÐÐÔÄÜ 2¡¢Ò»Ð©µ¥´Î¡¢²»³£ÓõIJÙ×÷µÄÓï¾äÖ´ÐÐÐÔÄÜ ËÄ¡¢²Î¿¼ 1¡¢³£ÓõÄÓÅ»¯¹¤¾ß 2¡¢²Î¿¼ÎÄÏ× Ò»¡¢Ç°ÑÔ Ëæ×Åʵ¼ÊÏîÄ¿µÄÆô¶¯£¬Êµ¼ÊÏîÄ¿ÖÐʹÓÃµÄ OracleÊý¾Ý¿â¾¹ýÒ»¶Îʱ¼äµÄÔËÐУ¬ÔÚÏß±£´æµÄÊý¾ÝÁ¿ºÍÒµÎñ´¦ÀíµÄÊý¾ÝÁ¿ÔÚÖð½¥Ôö´ó£¬×î³õµÄOracleÉèÖã¬ÓëÏÖÔÚʵ¼ÊÐèÒªµÄÔËÐÐÐÔÄÜÓÐÒ»¶¨²î¾à£¬ÐèÒª½øÐÐһЩÓÅ»¯µ÷Õû¡£ ±¾ÎĽ«½áºÏ±¾ÈËʵ¼Êά»¤¾Ñ飬ÏàÓ¦µØÌá³öʵ¼ÊÏîÄ¿Êý¾Ý´¦ÀíµÄһЩÓÅ»¯·½·¨£¬ÒÔ¹©²Î¿¼¡£ ÊÊÓÃÓÚOracle 9i¡£ ¶þ¡¢OracleÊý¾Ý¿âÓÅ»¯¸ÅÊö OracleÊý¾Ý¿âµÄÓÅ»¯£¬Õë¶Ô²»Í¬µÄÓ¦Ó㬻áÓвàÖص㲻ͬµÄÓÅ»¯·½·¨£¬¸ù¾ÝÎÒÃÇʵ¼ÊÏîÄ¿µÄÓ¦ÓÃÌص㣬ÎÒÃÇÖ÷Òª¹ØÐĵÄÊÇÿ´ÎÊÂÎñÖ´ÐÐÍê³ÉµÄʱ¼ä³¤¶Ì¡£ ´ÓOracleÊý¾Ý¿â±¾ÉíµÄÌص㣬ÎÒÃÇ¿ÉÒÔ°ÑÓÅ»¯¹¤×÷»®·ÖΪ³õʼÓÅ»¯ÉèÖã¬Î¢ÓÅ»¯¡£ ÔÚ³õʼÓÅ»¯ÉèÖÃʱ£¬ÎÒÃÇÖ»Äܸù¾ÝÓ²¼þÇé¿ö£¬¹À¼ÆÒµÎñÔËÐеÄÇé¿ö£¬×ۺϾÑ飬¸ø³öÒ»ÖÖ¾ÑéÉèÖ㬴óÌåÉÏÀ´Ëµ£¬ÕâÖÖ¾ÑéÉèÖÃÀëÂú×ãÓÅ»¯ÐèÇóµÄÄ¿±ê²»ÊǺÜÔ¶¡£ÔÚÍê³ÉÁ˳õʼÓÅ»¯ÉèÖú󣬾¹ýÒ»¶Îʱ¼äµÄÒµÎñÔËÐУ¬ÒÑ¿É¿ªÊ¼ÊÕ¼¯Êµ¼ÊÔËÐл·¾³µÄÐÔÄÜÊý¾Ý£¬´Ëʱ£¬¾Í¿ÉÒÔ¶Ô¸÷ÖÖOracleÐÔÄÜÖ¸±ê¡¢¸÷ÖÖ¹ØÐĵÄÊÂÎñ²Ù×÷½øÐÐÐÔÄÜÆÀ¹À£¬È»ºó½øÐÐ΢ÓÅ»¯ÁË¡£ OracleÓÅ»¯£¬²»ÊÇÒ»¸öÒ»õí¶ø¾ÍµÄ¹¤×÷£¬Ò²²»ÊÇÒ»¸öÒ»ÀÍÓÀÒݵŤ×÷£¬ÐèÒª¶¨ÆÚά»¤£¬¶¨Æڹ۲죬ÔÚ·¢ÏÖÐÔÄÜÆ¿¾±Ê±¼°Ê±½øÐе÷Õû¡£Oracle×ÜÊÇ´æÔÚÐÔÄÜÆ¿¾±µÄ£¬²»Ê¹Óᢲ»²Ù×÷µÄÊý¾Ý¿â×ÜÊÇ×î¿ìµÄ£¬ÔÚ½â¾öµ±Ç°Æ¿¾±ºó£¬×ÜÊÇ»áÓÐÁíÒ»¸öÆ¿¾±³öÏÖ£¬ËùÒÔÔÚÓÅ»¯Ç°£¬ÎÒÃÇÐèҪȷ¶¨Ò»¸öÓÅ»¯Ä¿±ê£¬ÎÒÃǵÄÄ¿±êÊÇÂú×ãÎÒÃǵÄÓ¦ÓÃÐÔÄÜÒªÇó¾Í¿ÉÒÔÁË¡£ OracleÓÅ»¯£¬Éæ¼°µÄ·¶Î§Ì«¹ã·º£¬°üº¬µÄÓÐÖ÷»úÐÔÄÜ£¬ÄÚ´æʹÓÃÐÔÄÜ£¬ÍøÂç´«ÊäÐÔÄÜ£¬SQLÓï¾äÖ´ÐÐÐÔÄܵȵȣ¬´ÓÎÒÃÇÃæÏòÍø¹ÜÀ´Ëµ£¬Âú×ãÊÂÎñÖ´ÐÐËÙ¶ÈÐÔÄÜÖ÷Òª±íÏÖÔÚ£º 1£©ÅúÁ¿Öظ´µÄSQLÓï¾äÖ´ÐÐÐÔÄÜ£¨Ö÷ÒªÊÇͨ¹ýProcedure¼ÆËãÍê³ÉÊý¾ÝºÏ²¢ºÍÊý¾Ý»ã×ܵÄÐÔÄܺÍÅúÁ¿Êý¾Ý²É¼¯Èë¿âµÄÐÔÄÜ£©£» 2£©Ò»Ð©µ¥´Î¡¢²»³£ÓõIJÙ×÷µÄÓï¾äÖ´ÐÐÐÔÄÜ£¨Ö÷ÒªÊÇGUIµÄ·Ç¹æÂɲÙ×÷
Ïà¹ØÎĵµ£º
1.¼à¿ØÊÂÀýµÄµÈ´ý£º
select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) curr,count(*)
from v$session_wait
group by event order by 4;
2.»Ø¹ö¶ÎµÄÕùÓÃÇé¿ö£º
select name,waits,gets,waits/gets ratio from v$rollstat a,v$rollnam ......
δʵÑé
ORACLEÊý¾Ý¿â×Ô´øµÄDBMS_JOB¹¦ÄÜ¿ÉÒÔʵÏÖ¶¨Ê±Ö´ÐÐPL/SQLµÄ´æ´¢¹ý³Ì£¬µ«ÊÇÈç¹ûSQLÓï¾äºÜ¸´ÔÓ£¬
SQLÓï¾äºÜ¶à£¬ÒÔ¼°¾³£Òª¸Ä±äSQLÓï¾äµÄд·¨£¬ÓÃдPL/SQL´æ´¢¹ý³ÌµÄ·½·¨ÔÙ¶¨Ê±Ö´Ðлá±È½Ï·±Ëö¡£ºÎ
¿ö»¹ÓÐһЩUNIXϵͳ¹ÜÀíÔ±²»»áдPL/SQL´æ´¢¹ý³Ì£¬ËùÒÔÎÒ½éÉ ......
create or replace procedure prc_statistic_declare(table_name varchar2 ,table_name_pass varchar2 ,not_exist varchar2,not_exist_record varchar2)
--eg:'t_statistic_bianyuanhu_month',t_statistic_bianyuanhu_month,('YEAR','STATISTIC_ID')','YESR'
is
v_sql_column varchar2(1000);
  ......
¿ªÊ¼ÔÚmyeclipse6.5ÖÐDB BROWERн¨ÁËÒ»¸öÊý¾Ý¿âÁ¬½Ó£¬Èçͼ£º
Ò»Á¬½Ó£¬±¨³öÁËÁ½¸ö´íÎó£º
1. ORA-00604 error occurred at recursive SQL level string.
2.ORA-12705: invalid or unknown NLS parameter value.
²é×ÊÁϺó½â¾ö£¨ÆÚ¼äÎÒ»¹¸Ä¹ýtestÓû§µÄÁ¬½ÓȨÏÞ£©£º
½«MyEclipseÖÐeclipseĿ¼ÏµÄeclipse.iniÎļþ£¬° ......
DBWn½ø³Ì¸ºÔð½«ÔàÊý¾Ý¿éдÈë´ÅÅÌ¡£ËüÊÇÒ»¸ö·Ç³£ÖØÒªµÄ½ø³Ì£¬Ëæ×ÅÄÚ´æµÄÔö¼Ó£¬Ò»¸öDBWn½ø³Ì¿ÉÄܲ»¹»ÓÃÁË¡£´Óoracle8iÆð£¬ÎÒÃÇ¿ÉÒÔΪϵͳÅäÖöà¸öDBWn½ø³Ì¡£³õʼ»¯²ÎÊýdb_writer_process¾ö¶¨ÁËÆô¶¯¶àÉÙ¸öDBWn½ø³Ì¡£Ã¿¸öDBWn½ø³Ì¶¼»á·ÖÅäÒ»¸öcache lru chain latch¡£
DBWn×÷Ϊһ¸öºǫ́½ø³Ì£¬ ......