СµÄI/O´æ´¢µ¥Î»£¬Ò»¸ödata block¶ÔÓ¦Ò»¸ö»ò¶à¸ö·ÖÅä¸ødata fileµÄ²Ù×÷ϵͳ¿é¡£
table´´½¨Ê±,ĬÈÏ´´½¨ÁËÒ»¸ödata segment,ÿ¸ödata segmentº¬ÓÐmin extentsÖ¸¶¨µÄextentsÊý,ÿ¸öextent¾Ý¾Ý±í¿Õ¼äµÄ´æ´¢²ÎÊý·ÖÅäÒ»¶¨ÊýÁ¿µÄblocks
3 ÃèÊötablespaceºÍdatafileÖ®¼äµÄ¹Øϵ
Ò»¸ö±í¿Õ¼ä¿É°üº¬Ò»¸ö»ò¶à¸öÊý¾ÝÎļþ¡£±í¿Õ¼äÀûÓÃÔö¼Ó»òÀ©Õ¹Êý¾ÝÎļþÀ©´ó±í¿Õ¼ä£¬±í¿Õ¼äµÄ´óСΪ×é³É¸Ã±í¿Õ¼äµÄÊý¾ÝÎļþ´óСµÄºÍ¡£Ò»¸ödatafileÖ»ÄÜÊôÓÚÒ»¸ö±í¿Õ¼ä;
Ò»¸ötablespace¿ÉÒÔÓÐÒ»¸ö»ò¶à¸ödatafile,ÿ¸ödatafileÖ»ÄÜÔÚÒ»¸ötablespaceÄÚ, tableÖеÄÊý¾Ý,ͨ¹ýhashËã·¨·Ö²¼ÔÚtablespaceÖеĸ÷¸ödatafileÖÐ,tablespaceÊÇÂß¼ÉϵĸÅÄî,datafileÔòÔÚÎïÀíÉÏ´¢´æÁËÊý¾Ý¿âµÄÖÖÖÖ¶ÔÏó¡£
4 ±¾µØ¹ÜÀí±í¿Õ¼äºÍ×Öµä¹ÜÀí±í¿Õ¼äµÄÌص㣬ASSMÓÐʲôÌصã
±¾µØ¹ÜÀí±í¿Õ¼ä£º£¨9iĬÈÏ£©¿ÕÏпéÁбí´æ´¢ÔÚ±í¿Õ¼äµÄÊý¾ÝÎļþÍ·¡£
Ìص㣺¼õÉÙÊý¾Ý×Öµä±íµÄ¾ºÕù£¬µ±·ÖÅäºÍÊÕËõ¿Õ¼äʱ»á²úÉú»Ø¹ö£¬²»ÐèÒªºÏ²¢¡£
×Öµä¹ÜÀí±í¿Õ¼ä£º£¨8iĬÈÏ£©¿ÕÏпéÁбí´æ´¢ÔÚÊý¾Ý¿âÖеÄ×Öµä±íÀï.
Ìص㣺ƬÓÉÊý¾Ý×Öµä¹ÜÀí£¬¿ÉÄÜÔì³É×Öµä±íµÄÕùÓᣴ洢ÔÚ±í¿Õ¼äµÄÿһ¸ö¶Î¶¼»áÓв»Í¬µÄ´æ´¢×־䣬ÐèÒªºÏ²¢ÏàÁڵĿé;
±¾µØ¹ÜÀí±í¿Õ¼ä£¨Locally Managed Tablespace¼ò³ÆLMT£©
8iÒÔºó³öÏÖµÄÒ»ÖÖеıí¿Õ¼äµÄ¹ÜÀíģʽ£¬Í¨¹ýλͼÀ´¹ÜÀí±í¿Õ¼äµÄ¿Õ¼äʹÓá£×Öµä¹ÜÀí±í¿Õ¼ä£¨Dictionary-Managed Tablespace¼ò³ÆDMT£©
8iÒÔÇ°°üÀ¨ÒԺ󶼻¹¿ÉÒÔʹÓõÄÒ»ÖÖ±í¿Õ¼ä¹ÜÀíģʽ£¬Í¨¹ýÊý¾Ý×Öµä¹ÜÀí±í¿Õ¼äµÄ¿Õ¼äʹÓ᣶¯¶Î¿Õ¼ä¹ÜÀí£¨ASSM£©£¬ËüÊ״γöÏÖÔÚOracle920ÀïÓÐÁËASSM£¬Á´½ÓÁбífreelist±»Î»Í¼ËùÈ¡´ú£¬ËüÊÇÒ»¸ö¶þ½øÖƵÄÊý×飬
Äܹ»Ñ¸ËÙÓÐЧµØ¹ÜÀí´æ´¢À©Õ¹ºÍÊ£ÓàÇø¿é£¨free block£©£¬Òò´ËÄܹ»¸ÄÉƷֶδ洢±¾ÖÊ£¬ASSM±í¿Õ¼äÉÏ´´½¨µÄ¶Î»¹ÓÐÁíÍâÒ»¸ö³Æºô½ÐBitmap Managed Segments£¨BMB ¶Î£©¡£
5 »Ø¹ö¶ÎµÄ×÷ÓÃÊÇʲô
»Ø¹ö¶ÎÓÃÓÚ±£´æÊý¾ÝÐÞ¸ÄÇ°µÄÓ³Ïó£¬ÕâЩÐÅÏ¢ÓÃÓÚÉú³É¶ÁÒ»ÖÂÐÔÊý¾Ý¿âÐÅÏ¢¡¢ÔÚÊý¾Ý¿â»Ö¸´ºÍRollbackʱʹÓá£Ò»¸öÊÂÎñÖ»ÄÜʹÓÃÒ»¸ö»Ø¹ö¶Î¡£
ÊÂÎñ»Ø¹ö£ºµ±ÊÂÎñÐ޸ıíÖÐÊý¾ÝµÄʱºò£¬¸ÃÊý¾ÝÐÞ¸ÄÇ°µÄÖµ£¨¼´Ç°Ó°Ïñ£©»á´æ·ÅÔڻعö¶ÎÖУ¬µ±Óû§»Ø¹öÊÂÎñ£¨ROLLBACK£©Ê±£¬ORACLE½«»áÀûÓûعö¶ÎÖеÄÊý¾ÝÇ°Ó°ÏñÀ´½«Ð޸ĵÄÊý¾Ý»Ö¸´µ½ÔÀ´µÄÖµ¡£
ÊÂÎñ»Ö¸´£ºµ±ÊÂÎñÕýÔÚ´¦ÀíµÄʱºò£¬Àý³Ìʧ°Ü£¬»Ø¹ö¶ÎµÄÐÅÏ¢±£´æÔÚundo±í¿Õ¼äÖУ¬ORACLE½«ÔÚÏ´δò¿ªÊý¾Ý¿âʱÀûÓûعöÀ´»Ö¸´Î´Ìá½»µÄÊý¾Ý¡£
¶ÁÒ»ÖÂÐÔ£ºµ±Ò»¸ö»á»°ÕýÔÚÐÞ¸ÄÊý¾Ýʱ£¬ÆäËûµÄ»á»°½«¿´²»µ½¸Ã»á»°Î´Ìá½»µÄÐ޸ġ£ µ±Ò»¸öÓï¾äÕýÔÚÖ´ÐÐʱ£¬¸ÃÓï¾ä½«¿´²»µ½´Ó¸ÃÓï¾ä¿ªÊ¼Ö´ÐкóµÄδÌá½»µÄÐ޸ģ¨Óï¾ä¼¶¶ÁÒ»ÖÂÐÔ£©
µ±ORACLEÖ´ÐÐSELECTÓï¾äʱ£¬ORACLEÒÀÕÕµ±Ç°µÄϵͳ¸Ä±äºÅ£¨SYSTEM CHANGE NUMBER-SCN£© À´±£Ö¤ÈκÎÇ°ÓÚµ±Ç°SCNµÄδÌá½»µÄ¸Ä±ä²»±»¸ÃÓï¾ä´¦Àí¡£¿ÉÒÔÏëÏ󣺵±Ò»¸ö³¤Ê±¼äµÄ²éѯÕýÔÚÖ´ÐÐʱ£¬ ÈôÆäËû»á»°¸Ä±äÁ˸òéѯҪ²éѯµÄij¸öÊý¾Ý¿é£¬ORACLE½«ÀûÓûعö¶ÎµÄÊý¾ÝÇ°Ó°ÏñÀ´¹¹ÔìÒ»¸ö¶ÁÒ»ÖÂÐÔÊÓͼ
6 ÈÕÖ¾µÄ×÷ÓÃÊÇʲô
ÈÕÖ¾Îļþ£¨Log File£©¼Ç¼ËùÓжÔÊý¾Ý¿âÊý¾ÝµÄÐ޸ģ¬Ö÷ÒªÊDZ£»¤Êý¾Ý¿âÒÔ·ÀÖ¹¹ÊÕÏ,ÒÔ¼°»Ö¸´Êý¾ÝʱʹÓá£ÆäÌصãÈçÏ£º
a)ÿһ¸öÊý¾Ý¿âÖÁÉÙ°üº¬Á½¸öÈÕÖ¾Îļþ×顣ÿ¸öÈÕÖ¾Îļþ×éÖÁÉÙ°üº¬Á½¸öÈÕÖ¾Îļþ³ÉÔ±¡£
b)ÈÕÖ¾Îļþ×éÒÔÑ»··½Ê½½øÐÐд²Ù×÷¡£
c)ÿһ¸öÈÕÖ¾Îļþ³ÉÔ±¶ÔÓ¦Ò»¸öÎïÀíÎļþ¡£
¼Ç¼Êý¾Ý¿âÊÂÎñ,×î´óÏ޶ȵر£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔÓ밲ȫÐÔ
ÖØ×öÈÕÖ¾Îļþ£ºº¬¶ÔÊý¾Ý¿âËù×öµÄ¸ü¸Ä¼Ç¼£¬ÕâÑùÍòÒ»³öÏÖ¹ÊÕÏ¿ÉÒÔÆôÓÃÊý¾Ý»Ö¸´,Ò»¸öÊý¾Ý¿âÖÁÉÙÐèÒªÁ½¸öÖØ×öÈÕÖ¾Îļþ
¹éµµÈÕÖ¾Îļþ£ºÊÇÖØ×öÈÕÖ¾ÎļþµÄÍÑ»ú¸±±¾£¬ÕâЩ¸±±¾¿ÉÄܶÔÓÚ´Ó½éÖÊʧ°ÜÖнøÐлָ´ºÜ±ØÒª¡£
7 SGAÖ÷ÒªÓÐÄÇЩ²¿·Ö£¬Ö÷Òª×÷ÓÃÊÇʲô
ϵͳȫ¾ÖÇø£¨SGA£©:ÊÇORACLEΪʵÀý·ÖÅäµÄÒ»×é¹²Ïí»º³å´æ´¢Çø£¬ÓÃÓÚ´æ·ÅÊý¾Ý¿âÊý¾ÝºÍ¿ØÖÆÐÅÏ¢£¬ÒÔʵÏÖ¶ÔÊý¾Ý¿âÊý¾ÝµÄ¹ÜÀíºÍ²Ù×÷¡£
SGAÖ÷Òª°üÀ¨:
a)¹²Ïí³Ø(shared pool) £ºÓÃÀ´´æ´¢×î½üÖ´ÐеÄSQLÓï¾äºÍ×î½üʹÓõÄÊý¾Ý×ÖµäµÄÊý¾Ý¡£
b)Êý¾Ý»º³åÇø (database buffer cache)£ºÓÃÀ´´æ´¢×î½ü´ÓÊý¾ÝÎļþÖжÁд¹ýµÄÊý¾Ý¡£
c)ÖØ×÷ÈÕÖ¾»º³åÇø£¨redo log buffer£©£ºÓÃÀ´¼Ç¼·þÎñ»òºǫ́½ø³Ì¶ÔÊý¾Ý¿âµÄ²Ù×÷¡£
ÁíÍâÔÚSGAÖл¹ÓÐÁ½¸ö¿ÉÑ¡µÄÄÚ´æ½á¹¹£º
d)Java pool: ÓÃÀ´´æ´¢Java´úÂë¡£
e)Large pool: ÓÃÀ´´æ´¢²»ÓëSQLÖ±½ÓÏà¹ØµÄ´óÐÍÄÚ´æ½á¹¹¡£±¸·Ý¡¢»Ö¸´Ê¹Óá£
GA£º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 ½ø³Ìʧ°ÜʱÇåÀí×ÊÔ´
¼ì²éµã½ø³Ì(CKPT)£º¸ºÔðÔÚÿµ±»º³åÇø¸ßËÙ»º´æÖеĸü¸ÄÓÀ¾ÃµØ¼Ç¼ÔÚÊý¾Ý¿âÖÐʱ,¸üпØÖÆÎļþºÍÊý¾ÝÎļþÖеÄÊý¾Ý¿â״̬ÐÅÏ¢¡£
¹éµµ½ø³Ì (ARCH)£ºÔÚÿ´ÎÈÕÖ¾Çл»Ê±°ÑÒÑÂúµÄÈÕÖ¾×é½øÐб¸·Ý»ò¹éµµ
»Ö¸´½ø³Ì (RECO): ±£Ö¤·Ö²¼Ê½ÊÂÎñµÄÒ»ÖÂÐÔ,ÔÚ·Ö²¼Ê½ÊÂÎñÖÐ,Ҫôͬʱcommit,Ҫôͬʱrollback;
×÷Òµµ÷¶ÈÆ÷(CJQ ): ¸ºÔ𽫵÷¶ÈÓëÖ´ÐÐϵͳÖÐÒѶ¨ÒåºÃµÄjob,Íê³ÉһЩԤ¶¨ÒåµÄ¹¤×÷.
Èý£º±¸·Ý»Ö¸´Àà
1 ±¸·ÝÈçºÎ·ÖÀà
Âß¼±¸·Ý£ºexp/imp Ö¸¶¨±íµÄÂß¼±¸·Ý
ÎïÀí±¸·Ý£º
Èȱ¸·Ý:alter tablespace begin/end backup;
À䱸·Ý:ÍÑ»ú±¸·Ý(database shutdown)
RMAN±¸·Ý
full backup/incremental backup(ÀÛ»ý/²îÒì)
ÎïÀí±¸·Ý
ÎïÀí±¸·ÝÊÇ×îÖ÷ÒªµÄ±¸·Ý·½Ê½¡£ÓÃÓÚ±£Ö¤Êý¾Ý¿âÔÚ×îСµÄÊý¾Ý¿â¶ªÊ§»òûÓÐÊý¾Ý¶ªÊ§µÄÇé¿öϵõ½»Ö¸´¡£
ÀäÎïÀí
ÀäÎïÀí±¸·ÝÌṩÁË×î¼òµ¥ºÍ×îÖ±½ÓµÄ·½·¨±£»¤Êý¾Ý¿âÒòÎïÀíË𻵶ªÊ§¡£½¨ÒéÔÚÒÔϼ¸ÖÖÇé¿öÖÐʹÓá£
¶ÔÒ»¸öÒѾ´æÔÚ´ó×îÊý¾ÝÁ¿µÄÊý¾Ý¿â£¬ÔÚÍí¼äÊý¾Ý¿â¿ÉÒԹرգ¬´ËʱӦÓÃÀäÎïÀí±¸·Ý¡£