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

oracle ºǫ́½ø³Ì

Ò»¸öʵÀý¿ÉÒÔÓжà¸öºǫ́½ø³Ì,µ«ÊÇ£¬²¢²»ÊÇÿһ¸öºǫ́½ø³Ì¶¼»á³ö³ö£¬Í¨¹ýÊÓͼv$bgprocess¿ÉÒԲ鿴ºǫ́½ø³ÌÐÅÏ¢¡£
Ò»°ãÎÒÃÇÊÇͨ¹ýÒÔÏÂsql²é¿´ºǫ́±ØÐëµÄºǫ́½ø³Ì.
1.²é¿´ºǫ́½ø³Ì
select paddr,name,description
from v$bgprocess
order by paddr desc
£»
2.Õâ¸öÊÓͼÖÐpaddr<>'00'µÄÐж¼ÊÇϵͳÉÏÅäÖúÍÔËÐеĽø³Ì(Ïß³Ì)
select *
from v$bgprocess t
where t.pADDR <>'00'
;
3.ÔÚlinuxϵͳÉÏ£¬Æô¶¯ÊµÀýºó£¬ÓÐÒÔϽø³Ì
ÎÒÊÇÔÚsuse enterprise linux 10°²×°µÄoracle10g£¬£¨²é¿´ÏàÓ¦µÄ°æ±¾ÃüÁîΪlsb_release –a£©
²é¿´ÊµÀýÆô¶¯µÄºǫ́½ø³ÌµÄÃüÁî
ps –aef|grep ‘ora_’
(
×¢Ã÷£ºÕâЩ½ø³ÌµÄÃüÃûÊÇÓйæÂɵÄ.
a.ËùÓеĽø³ÌÃû¶¼ÊÇÒÔora_¿ªÍ·
    b.Öм䲿·ÝΪ½ø³ÌµÄ¾ßÌåÃû×Ö
c.×îºóÒ»²¿·ÝΪORACLE_IDÃû³Æ£¬ÒòΪÎҵݲװʱʹÓÃĬÈϵݲװ
£©
4£®½éÉÜÏàÓ¦µÄ¼¸¸öºǫ́½ø³Ì¼°Ïà¹ØµÄ×÷ÓÃ.
a.PMON   ½ø³Ì¼àÊÓÆ÷(process monitor)
Õâ¸ö½ø³Ì¸ºÔðÔÚ³öÏÖÒì³£ÖÐÖ¹µÄÁ¬½ÓÖ®ºóµÄÍê³ÉÇåÀí£¬Èç¹ûÄãµÄרÓ÷þÎñÆ÷“ʧ°Ü”,”»òÕß³öÏÖijÖÖÔ­ÒòµÄ³·Ïû”,¾ÍÒªÓÉPMON¸ºÔðÐÞÕý(»Ö¸´»ò³·Ïú¹¤×÷)¡£³ýÁËÉÏÊö¹¦ÄÜÍ⣬PMON»¹¸ºÔð¼àÊÓÆäËûµÄoracle½ø³Ì£¬²¢ÔÚ±ØÒªÊ±ÖØÆôÕâЩºǫ́½ø³Ì.
b.SMON ϵͳ¼àÊÓÆ÷(system monitor)
Çå¿Õ±í¿Õ¼ä£¬ºÏ²¢¿ÕÏпռ䣬Õë¶ÔÔ­À´²»¿ÉÓõÄÎļþ»Ö¸´»î¶¯µÄÊÂÎñ£¬Ö´ÐÐRACÖÐʧ°Ü½ÚµãµÄʵÀý»Ö¸´£¬ÊÕËõ»Ø¹ö¶Î.
c.CKPT ¼ì²éµã½ø³Ì(Checkpoint Process)
¼ì²éµã½ø³Ì²¢²»ÏñËüµÄÃû×ÖËù°µÊ¾µÄÄÇÑùÕæµÄ½¨Á¢¼ì²éµã£¬½¨Á¢¼ì²éµãÖ÷ÒªÊÇDBWnµÄÈÎÎñ£¬CKPTÖ÷ÒªÊǸüÐÂÊý¾ÝÎļþµÄÊײ¿.
d.DBWn Êý¾Ý¿â¿éдÈëÆ÷ (database block writer)
Êý¾Ý¿â¿éдÈë³ÌÐò½«ÔàÊý¾ÝдÈë´ÅÅ̵ĺǫ́½ø³Ì.DBWn»áд³ö»º³åÇø»º´æÖеÄÔà¿é£¬Í¨³£ÊÇΪÁËÔÚ»º´æÖÐÌÚ³ö¸ü¶àµÄ¿Õ¼ä£¬»òÕßÊÇΪÁËÍÆ½ø¼ì²éµã¡£
e.LGWR ÈÕ־дÈëÆ÷(log writer)
LGWR½ø³Ì¸ºÔð½«SGAÖеÄÖØ×öÈÕÖ¾»º³åÇøµÄÄÚÈÝˢгöµ½´ÅÅÌ£¬Èç¹ûÂú×ãÒÔÏÂij¸öÌõ£¬¾Í»á×öÕâ¸ö¹¤×÷¡£
ÿ3Ãë»áË¢ÐÂÊä³öÒ»´Î
ÈκÎÊÂÎñ·¢³öÒ»¸öÌύʱ
ÖØ×öÈÕÖ¾»º³åÇø1/3Âú£¬»òÕß¼º¾­º¬1MBµÄ»º³åÊý¾Ý
f.ARCn ¹éµµ½ø³Ì(archive process)
ARCn½ø³ÌµÄÈÎÎñÊÇ£¬µ±LGWR½«ÔÚÏßÖØ×öÈÕÖ¾ÎļþÌîÂúʱ£¬¾Í½«Æä¸´ÖƵ½ÁíÒ»¸öλÖã¬ÕâЩ¹éµµÖØ×öÈÕÖ¾Îļþ¿ÉÒÔÓÃÓÚÍê³É½éÖʻָ´¡£ÔÚÏßÖØ×öÈÕÖ¾ÓÃÓÚ³öµçÔ´¹ÊÕÏ£¨ÊµÀý£©Ê±£¬“ÐÞÕý“Êý¾ÝÎļþ£¬¶ø¹éµµÖØ×öÈÕÖ¾ÎļþËüÊÇÔÚ³öÏÖ


Ïà¹ØÎĵµ£º

oracle ÎﻯÊÓͼ

ÎﻯÊÓͼÊÇÒ»ÖÖÌØÊâµÄÎïÀí±í£¬“Îﻯ”(Materialized)ÊÓͼÊÇÏà¶ÔÆÕͨÊÓͼ¶øÑԵġ£ÆÕͨÊÓͼÊÇÐéÄâ±í£¬Ó¦ÓõľÖÏÞÐÔ´ó£¬ÈκζÔÊÓͼµÄ²éѯ£¬Oracle¶¼Êµ¼ÊÉÏת»»ÎªÊÓͼSQLÓï
¾äµÄ²éѯ¡£ÕâÑù¶ÔÕûÌå²éѯÐÔÄܵÄÌá¸ß£¬²¢Ã»ÓÐʵÖÊÉϵĺô¦¡£
¡¡¡¡Oracle×îÔçÔÚOLAPϵͳÖÐÒýÈëÁËÎﻯÊÓͼµÄ¸ÅÄî¡£µ«ºóÀ´ºÜ¶à´óÐÍOLTPϵͳÖÐ ......

¡¾×ª¡¿³õʶ oracle ÖеÄË÷Òý×éÖ¯±í

http://fangrn.javaeye.com/blog/514448
³õʶ oracle ÖеÄË÷Òý×éÖ¯±í
    Ë÷Òý×éÖ¯±í£¨ IOT £©ÓÐÒ»ÖÖÀà B Ê÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶ø IOT ÖеÄÊý¾ÝÊǰ´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚ B Ê÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ã B Ê÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚ IOT ÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ· ......

Oracle Ë÷Òý×éÖ¯±í£¨IOT£©

     Ë÷Òý×éÖ¯±í£¨IOT£©ÓÐÒ»ÖÖÀàBÊ÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶øIOTÖеÄÊý¾ÝÊǰ´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚBÊ÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ãBÊ÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚIOTÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ·ÇÖ÷¼üÁÐÖµ¡£
     ÔÚIOTËù¶ÔÓ¦µÄBÊ÷½á¹¹ÖУ¬Ã¿¸öË÷ÒýÏî°ü ......

oracle ×Ö¶Î×¢ÊÍ Êý¾Ý×ÖµäÏÔʾ

select  lower( column_name) ||','||'--'||comments
from user_col_comments    c
where c.table_name  = upper('acc_fundcap')
SELECT * from USER_TAB_COMMENTS WHERE TABLE_NAME='T_META';
INSERT INTO ±íÃû(×Ö¶ÎÃû1, ×Ö¶ÎÃû2) SELECT ×Ö¶ÎÃû1, ×Ö¶ÎÃû2 from ÁíÍâµÄ±íÃû; ......

Oracle 開發筆記

Oracle Îï¼þµÄÃüÃûÏÞÖÆ
ÈκÎÎï¼þµÄÃû稱²»µÃ³¬過 30 λԪ(Bytes)
Oracle µÄ dummy query 寫·¨
SELECT SYSDATE from dual
Oracle 選È¡²¿·Ö資Áϵķ½·¨
SELECT * from table WHERE ROWNUM<10; /* È¡³öǰ 10 筆 */
實現 Oracle ÉϵķÖ頁顯ʾ [¾«華] ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ