Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

Oracle·ÖÒ³²éѯÓï¾ä


·ÖÒ³²éѯ¸ñʽ£º
SELECT * from 
(
SELECT A.*, ROWNUM RN 
from (SELECT * from TABLE_NAME) A 
WHERE ROWNUM <= 40
)
WHERE RN >= 21
ÆäÖÐ×îÄÚ²ãµÄ²éѯSELECT * from TABLE_NAME±íʾ²»½øÐз­Ò³µÄԭʼ²éѯÓï¾ä¡£ROWNUM <= 40ºÍRN >= 21¿ØÖÆ·ÖÒ³²éѯµÄÿҳµÄ·¶Î§¡£
ÉÏÃæ¸ø³öµÄÕâ¸ö·ÖÒ ......

oracle ÎﻯÊÓͼ

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

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

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