Êý¾Ý¿â»ù±¾¸ÅÄîÀà
1:pctused and pctfree ±íʾʲôº¬ÒåÓÐʲô×÷ÓÃ
pctusedÓëpctfree¿ØÖÆÊý¾Ý¿éÊÇ·ñ³öÏÖÔÚfreelistÖÐ,
pctfree¿ØÖÆÊý¾Ý¿éÖб£ÁôÓÃÓÚupdateµÄ¿Õ¼ä,µ±Êý¾Ý¿éÖеÄfree spaceСÓÚpctfreeÉèÖõĿռäʱ,
¸ÃÊý¾Ý¿é´ÓfreelistÖÐÈ¥µô,µ±¿éÓÉÓÚdml²Ù×÷free space´óÓÚpct_usedÉèÖõĿռäʱ,¸ÃÊý¾Ý¿â¿é½«
±»Ìí¼ÓÔÚfreelistÁ´±íÖС£
2:¼òµ¥ÃèÊötable / segment / extent / blockÖ®¼äµÄ¹Øϵ
table´´½¨Ê±,ĬÈÏ´´½¨ÁËÒ»¸ödata segment,
ÿ¸ödata segmentº¬ÓÐmin extentsÖ¸¶¨µÄextentsÊý,
ÿ¸öextent¾Ý¾Ý±í¿Õ¼äµÄ´æ´¢²ÎÊý·ÖÅäÒ»¶¨ÊýÁ¿µÄblocks
3:ÃèÊötablespaceºÍdatafileÖ®¼äµÄ¹Øϵ
Ò»¸ötablespace¿ÉÒÔÓÐÒ»¸ö»ò¶à¸ödatafile,ÿ¸ödatafileÖ»ÄÜÔÚÒ»¸ötablespaceÄÚ,
tableÖеÄÊý¾Ý,ͨ¹ýhashËã·¨·Ö²¼ÔÚtablespaceÖеĸ÷¸ödatafileÖÐ,
tablespaceÊÇÂß¼ÉϵĸÅÄî,datafileÔòÔÚÎïÀíÉÏ´¢´æÁËÊý¾Ý¿âµÄÖÖÖÖ¶ÔÏó¡£
4:±¾µØ¹ÜÀí±í¿Õ¼äºÍ×Öµä¹ÜÀí±í¿Õ¼äµÄÌص㣬ASSMÓÐʲôÌصã
±¾µØ¹ÜÀí±í¿Õ¼ä(Locally Managed Tablespace¼ò³ÆLMT)
8iÒÔºó³öÏÖµÄÒ»ÖÖеıí¿Õ¼äµÄ¹ÜÀíģʽ£¬Í¨¹ýλͼÀ´¹ÜÀí±í¿Õ¼äµÄ¿Õ¼äʹÓá£
×Öµä¹ÜÀí±í¿Õ¼ä(Dictionary-Managed Tablespace¼ò³ÆDMT)
8iÒÔÇ°°üÀ¨ÒԺ󶼻¹¿ÉÒÔʹÓõÄÒ»ÖÖ±í¿Õ¼ä¹ÜÀíģʽ£¬Í¨¹ýÊý¾Ý×Öµä¹ÜÀí±í¿Õ¼äµÄ¿Õ¼äʹÓá£
¶¯¶Î¿Õ¼ä¹ÜÀí(ASSM)£¬
ËüÊ״γöÏÖÔÚOracle920ÀïÓÐÁËASSM£¬Á´½ÓÁбífreelist±»Î»Í¼ËùÈ¡´ú£¬ËüÊÇÒ»¸ö¶þ½øÖƵÄÊý×飬
Äܹ»Ñ¸ËÙÓÐЧµØ¹ÜÀí´æ´¢À©Õ¹ºÍÊ£ÓàÇø¿é(free block)£¬Òò´ËÄܹ»¸ÄÉƷֶδ洢±¾ÖÊ£¬
ASSM±í¿Õ¼äÉÏ´´½¨µÄ¶Î»¹ÓÐÁíÍâÒ»¸ö³Æºô½ÐBitmap Managed Segments(BMB ¶Î)¡£
5:»Ø¹ö¶ÎµÄ×÷ÓÃÊÇʲô
ÊÂÎñ»Ø¹ö£ºµ±ÊÂÎñÐ޸ıíÖÐÊý¾ÝµÄʱºò£¬¸ÃÊý¾ÝÐÞ¸ÄÇ°µÄÖµ(¼´Ç°Ó°Ïñ)»á´æ·ÅÔڻعö¶ÎÖУ¬
µ±Óû§»Ø¹öÊÂÎñ(ROLLBACK)ʱ£¬ORACLE½«»áÀûÓûعö¶ÎÖеÄÊý¾ÝÇ°Ó°ÏñÀ´½«Ð޸ĵÄÊý¾Ý»Ö¸´µ½ÔÀ´µÄÖµ¡£
ÊÂÎñ»Ö¸´£ºµ±ÊÂÎñÕýÔÚ´¦ÀíµÄʱºò£¬Àý³Ìʧ°Ü£¬»Ø¹ö¶ÎµÄÐÅÏ¢±£´æÔÚundo±í¿Õ¼äÖУ¬
ORACLE½«ÔÚÏ´δò¿ªÊý¾Ý¿âʱÀûÓûعöÀ´»Ö¸´Î´Ìá½»µÄÊý¾Ý¡£
¶ÁÒ»ÖÂÐÔ£ºµ±Ò»¸ö»á»°ÕýÔÚÐÞ¸ÄÊý¾Ýʱ£¬ÆäËûµÄ»á»°½«¿´²»µ½¸Ã»á»°Î´Ìá½»µÄÐ޸ġ£
µ±Ò»¸öÓï¾äÕýÔÚÖ´ÐÐʱ£¬¸ÃÓï¾ä½«¿´²»µ½´Ó¸ÃÓï¾ä¿ªÊ¼Ö´ÐкóµÄδÌá½»µÄÐÞ¸Ä(Óï¾ä¼¶¶ÁÒ»ÖÂÐÔ)
µ±ORACLEÖ´ÐÐSelectÓï¾äʱ£¬ORACLEÒÀÕÕµ±Ç°µÄϵͳ¸Ä±äºÅ(SYSTEM CHANGE NUMBER-SCN)
À´±£Ö¤ÈκÎÇ°ÓÚµ±Ç°SCNµÄδÌá½»µÄ¸Ä±ä²»±»¸ÃÓï¾ä´¦Àí¡£¿ÉÒÔÏëÏ󣺵±Ò»¸ö³¤Ê±¼äµÄ²éѯÕýÔÚÖ´ÐÐʱ£¬
ÈôÆäËû»á»°¸Ä±äÁ˸òéѯҪ²éѯµÄij¸öÊý¾Ý¿é£¬ORACLE½«ÀûÓûعö¶ÎµÄÊý¾ÝÇ°Ó°ÏñÀ´¹¹ÔìÒ»¸ö¶ÁÒ»ÖÂÐÔÊÓͼ¡£
6:ÈÕÖ¾µÄ×÷ÓÃÊÇʲô
¼Ç¼Êý¾Ý¿âÊÂÎñ,×î´óÏ޶ȵر£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔÓ밲ȫÐÔ
ÖØ×öÈÕÖ¾Îļþ£ºº¬¶ÔÊý¾Ý¿âËù×öµÄ¸ü¸Ä¼Ç¼£¬ÕâÑùÍòÒ»³öÏÖ¹ÊÕÏ¿ÉÒÔÆôÓÃÊý¾Ý»Ö¸´,Ò»¸öÊý¾Ý¿âÖÁÉÙÐèÒªÁ½¸öÖØ×öÈÕÖ¾Îļþ
¹éµµÈÕÖ¾Îļþ£ºÊÇÖØ×öÈÕÖ¾ÎļþµÄÍÑ»ú¸±±¾£¬ÕâЩ¸±±¾¿ÉÄܶÔÓÚ´Ó½éÖÊʧ°ÜÖнøÐлָ´ºÜ±ØÒª¡£
7:SGAÖ÷ÒªÓÐÄÇЩ²¿·Ö£¬Ö÷Òª×÷ÓÃÊÇʲô
SGA£ºdb_cache/shared_pool/large_pool/java_pool
db_cache:
Êý¾Ý¿â»º´æ(Block Buffer)¶ÔÓÚOracleÊý¾Ý¿âµÄÔËתºÍÐÔÄÜÆð×ŷdz£¹Ø¼üµÄ×÷Óã¬
ËüÕ¼¾ÝOracleÊý¾Ý¿âSGA(ϵͳ¹²ÏíÄÚ´æÇø)µÄÖ÷Òª²¿·Ö¡£OracleÊý¾Ý¿âͨ¹ýʹÓÃLRU
Ëã·¨£¬½«×î½ü·ÃÎʵÄÊý¾Ý¿é´æ·Åµ½»º´æÖУ¬´Ó¶øÓÅ»¯¶Ô´ÅÅÌÊý¾ÝµÄ·ÃÎÊ.
shared_pool:
¹²Ïí³ØµÄ´óС¶ÔÓÚOracle ÐÔÄÜÀ´Ëµ¶¼ÊǺÜÖØÒªµÄ¡£
¹²Ïí³ØÖб£´æÊý¾Ý×Öµä¸ßËÙ»º³åºÍÍêÈ«½âÎö»ò±àÒëµÄµÄPL/SQL ¿éºÍSQL Óï¾ä¼°¿ØÖƽṹ
large_pool:
ʹÓÃMTSÅäÖÃʱ£¬ÒòΪҪÔÚSGAÖзÖÅäUGAÀ´±£³ÖÓû§µÄ»á»°£¬¾ÍÊÇÓÃLarge_poolÀ´±£³ÖÕâ¸ö»á»°ÄÚ´æ
ʹÓÃRMAN×ö±¸·ÝµÄʱºò£¬ÒªÊ¹ÓÃLarge_poolÕâ¸öÄÚ´æ½á¹¹À´×ö´ÅÅÌI/O»º´æÆ÷
java_pool:
Ϊjava procedureÔ¤±¸µÄÄÚ´æÇøÓò,Èç¹ûûÓÐʹÓÃjava proc,java_pool²»ÊDZØÐëµÄ
8 oracleϵͳ½ø³ÌÖ÷ÒªÓÐÄÄЩ£¬×÷ÓÃÊÇʲô
Êý¾Ýд½ø³Ì(dbwr)£º¸ºÔ𽫸ü¸ÄµÄÊý¾Ý´ÓÊý¾Ý¿â»º³åÇø¸ßËÙ»º´æдÈëÊý¾ÝÎļþ
ÈÕ־д½ø³Ì(lgwr)£º½«ÖØ×öÈÕÖ¾»º³åÇøÖеĸü¸ÄдÈëÔÚÏßÖØ×öÈÕÖ¾Îļþ
ϵͳ¼à¿Ø(smon) £º¼ì²éÊý¾Ý¿âµÄÒ»ÖÂÐÔÈçÓбØÒª»¹»áÔÚÊý¾Ý¿â´ò¿ªÊ±Æô¶¯Êý¾Ý¿âµÄ»Ö¸´
½ø³Ì¼à¿Ø(pmon) £º¸ºÔðÔÚÒ»¸öOracle ½ø³Ìʧ°ÜʱÇåÀí×ÊÔ´
¼ì²éµã½ø³Ì(chpt)£º¸ºÔðÔÚÿµ±»º³åÇø¸ßËÙ»º´æÖеĸü¸ÄÓÀ¾ÃµØ¼Ç¼ÔÚÊý¾Ý¿âÖÐʱ,¸üпØÖÆÎļþºÍÊý¾ÝÎļþÖеÄÊý¾Ý¿â״̬ÐÅÏ¢¡£
¹éµµ½ø³Ì(arcn) £ºÔÚÿ´ÎÈÕÖ¾Çл»Ê±°ÑÒÑÂúµÄÈÕÖ¾×é½øÐб¸·Ý»ò¹éµµ
×÷Òµµ÷¶ÈÆ÷(cjq) :¸ºÔ𽫵÷¶ÈÓëÖ´ÐÐϵͳÖÐÒѶ¨ÒåºÃµÄjob,Íê³ÉһЩԤ¶¨ÒåµÄ¹¤×÷.
»Ö¸´½ø³Ì(reco) :±£Ö¤·Ö²¼Ê½ÊÂÎñµÄÒ»ÖÂÐÔ,ÔÚ·Ö²¼Ê½ÊÂÎñÖÐ,Ҫôͬʱcommit,Ҫôͬʱrollback;