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

Oracle ASM´æ´¢·½Ê½Ç³Îö


AU
ASMµÄ×îС·ÖÅäµ¥Ôª£¬Ä¬ÈÏÊÇ1M£¬¿ÉÒÔÔÚ´´½¨diskgroupʱָ¶¨¡£ÔÚdiskgroupÖеÄÿ¸öÅ̶¼±»ÇзÖΪºÜ¶à¸öAU£¬¿ÉÒÔÊÇ1, 2, 4, 8, 16, 32, or 64MB¡£
File Extent
ÓÉÒ»¸ö»ò¶à¸öAU×é³É£¬Ò»¸öfile extent×ÜÊÇÔÚÒ»¿é´ÅÅÌÉÏ£¨²»¿ç´ÅÅÌ·ÖÅäAU£©£¬ÕâÀïµÄfile extentºÍÊý¾Ý¿âÖеÄextentÊDz»Í¬µÄ£¬ÎÒÃÇ¿ÉÒÔÕâÑùÀí½â£¬ÕâÀïµÄfile extentÊÇÎïÀíÈÝÆ÷£¬¶øÊý¾Ý¿âÖеÄextentÊÇÂß¼­¸ÅÄî¡£
ÏÂͼÊÇAUºÍfile extentµÄʾÒâͼ£¬¿ÉÒÔ¿´µ½¸Õ¿ªÊ¼Ê±Ò»¸öfile extent¶ÔÓ¦Ò»¸öAU£¬µ½´ïij¸öÊýÁ¿¼¶ºó£¬Ò»¸öfile extent¶ÔÓ¦8¸öAU£¬Oracle³ÆÖ®ÎªVariable size file extent.
MirrorºÍStripe
ASMÈçºÎ×ömirrorºÍstripe£¬ÆäʵÎÒÃÇ¿ÉÒÔ°ÑASMÏëÏóΪһ¸ö´æ´¢É豸£¬ASMµÄ·½Ê½²»Êdz£¼ûµÄ´ÅÅ̶ԴÅÅÌ×÷RAIDµÄ·½Ê½£¬ÎҲ²âÊÇÀàËÆÓÚ3PARÕâÖÖ´æ´¢Ëù²ÉÓõÄÐéÄ⻯·½Ê½£¬ÎÒÃÇ¿´¿´3PARÊÇÈçºÎ´¦ÀíµÄ¡£3PAR½«Ã¿¿é´ÅÅ̶¼ÇзÖΪ256MµÄµ¥Ôª£¨³ÆÎªchunklet£©£¬´´½¨logical disk£¨¶¨ÒåRAIDÀàÐÍ£©£¬ÎÒÃǼÙÉèΪRAID 10£¬ÏµÍ³×Ô¶¯Ñ¡È¡²»Í¬´ÅÅÌÉϵÄchunkletÏÈ×÷mirror£¬È»ºóÔÙÔÚÕâЩmirrorºóµÄchunklet pairÉÏ×östripe£¬Ìõ´ø¿çÔÚlogical diskÉϵÄËùÓÐÎïÀí´ÅÅÌ£¬ÕâÑù×öµÄºÃ´¦ÊÇÒòΪ´ÅÅ̱»ÇзÖΪºÜСµÄµ¥Ôª£¬¿ÉÒÔʵÏÖ¶¯Ì¬¸ºÔØÇ¨ÒÆ¡£¶øÎÒÃÇͨ³£µÄ´æ´¢£¬ÊÇÒªÏȹ̶¨µÄѡȡһЩ´ÅÅÌ£¬±ÈÈç8¿é´ÅÅÌ£¬È»ºó´´½¨RAID group£¬È»ºóÔÚRAID groupÉÏ´´½¨Âß¼­ÅÌ£¬ÕâÖÖ·½Ê½RAID groupÊǹ̶¨µÄ£¬³ý·ÇÖØ½¨·ñÔòûÓа취¶¯Ì¬µ÷Õû¡£
Oracle ASMÒ²Óж¯Ì¬¸ºÔØÇ¨ÒƵŦÄÜ£¬ÎÒÏëOracleÓ¦¸ÃÊDzÉÓò¶àµÄ·½Ê½£¬ËùÒÔOracleÒ²¶Ô´ÅÅÌÊ×ÏÈ»®·ÖΪAU£¬AU×é³ÉÁËfile extent£¬È»ºóÓÃfile extentÀ´×ömirror£¬µ«²¢²»ÊÇ´ÅÅÌÏàͬλÖõÄextentÀ´×÷mirror£¬Oracleֻȷ±£mirrorµÄextentÔÚ²»Í¬µÄ´ÅÅÌ»òÕßfailure groupÉÏ¡£ÓÐÈËÎÊÎÒÒ»¸öÎÊÌ⣬Oracle ASMÊÇRAID10»¹ÊÇRAID 01£¬ÎҵĻشðÊÇ´ÓAUµÄ½Ç¶ÈÈ¥¿´£¬ASMÊÇRAID 10£¬ÒòΪÊÇÏÈ×öÁËmirror£¬ÔÙ×östripe¡£µ«ÊÇÈç¹û´Ó´ÅÅ̵ĽǶÈÈ¥¿´£¬ÒòΪ²»´æÔÚÁ½¸ö¾µÏñÅ̵ĸÅÄËùÒÔËü²»ÊÇRAID 10£¬¶øÊǽéÓÚÁ½ÕßÖ®¼äµÄÒ»¸ö¶«Î÷¡£¼ÙÉèÒ»¸ödisk groupÖлµÁËÒ»¿é´ÅÅÌ£¬ÕâʱÈç¹ûÁíÒ»¸ödisk groupÖаüº¬ÁËË𻵵Ädisk groupÉϵÄmirror AUµÄ´ÅÅÌҲͬʱË𻵣¬Õâ¸öASM¾Í²»¿ÉÒÔ»Ö¸´ÁË¡£µ«ASM²»ÊÇRAID 01£¬ÒòΪһ¸ödisk groupÖлµµôÒ»¿é´ÅÅÌ£¬²¢²»Òâζ×ÅÕû¸ödisk group»µµô£¬ÒòΪRAID 01µÄ¸ÅÄîÒ²ÊÇÕë¶ÔÓÚ´ÅÅ̵ġ£
ASMµÄstripeÓÐÁ½ÖÖ£¬·Ö±ðÊÇfineºÍCoarse£¬fineµÄstripe depthÊÇ128K£¬coarseµÄstripe depthµÈÓÚAUµÄ´óС£¬Ä¬ÈÏÊÇ1M¡£Ora


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle֪ʶ£¨Ò»£©


sql½Å±¾£¬Ò²¾ÍÊÇÔÚÎļþÖÐдÓÐsqlÓï¾äµÄÎļþ£¬¿ÉÒÔÔÚsqlplusÖÐÔËÐС£
ÒýÈësql½Å±¾
sqlplus Óû§Ãû/ÃÜÂë @sql½Å±¾.sql
£¨×¢Ò⣺ÔÚÓû§ÃûÃÜÂëÊäÈë½áÊøºóÒ»¶¨Òª¼Ó¿Õ¸ñÈ»ºóÔÙд@sql½Å±¾£©
OracleÖеĿÕÖµ»áµ±×÷ÎÞÇî´ó´¦Àí£¬Æäʵ¿ÕÖµ¸ù±¾¾Í²»»á´æ´¢£¬Ö»ÊÇ¿´×÷ÊÇÎÞÇî´ó¡£
OracleÖпØÖÆ´¦Àíº¯Êý NVL(×Ö¶ÎÃû£¬ ......

OracleÊý¾Ý¿âΪʲô±äÂýÁË£¿

±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌØ±ðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ ......

oracle¸ü¸ÄÊý¾Ý¿âÃû

author:skate
time:2009/10/23
ÕâÁ½ÌìÒ»ÅóÓÑÎÊÈçºÎ¸ü¸ÄÊý¾Ý¿âÃû£¬ÓÚÊÇ×ö¸ö²âÊÔ£¬¼òµ¥¼Ç¼Ï£¬ÒÔ±ã˵Ã÷ÎÊÌâ
ÈçºÎÐÞ¸ÄÊý¾Ý¿âÃû£¨db_name)¼°ÊµÀýÃû(Instance_name or Service_name)
NidÊÇOracle´Ó9iR2¿ªÊ¼ÌṩµÄ¹¤¾ß£¬¿ÉÒÔÓÃÀ´¸ü¸ÄÊý¾Ý¿âÃû³Æ£¬¶øÎÞÐèͨ¹ýÖ®Ç°ÖØ½¨¿ØÖÆÎļþµÈ·±Ëö·½Ê½¡£
nidÊÇ×Ô´øµÄ¹¤¾ß£¬ÔÚoracle_home/b ......

oracle³£Óñí

 dba_users Êý¾Ý¿âÓû§ÐÅÏ¢
dba_segments ±í¶ÎÐÅÏ¢
dba_extents Êý¾ÝÇøÐÅÏ¢
dba_objects Êý¾Ý¿â¶ÔÏóÐÅÏ¢
dba_tablespaces Êý¾Ý¿â±í¿Õ¼äÐÅÏ¢
dba_data_files Êý¾ÝÎļþÉèÖÃÐÅÏ¢
dba_temp_files ÁÙʱÊý¾ÝÎļþÐÅÏ¢
dba_rollback_segs »Ø¹ö¶ÎÐÅÏ¢
dba_ts_quotas Óû§±í¿Õ¼äÅä¶îÐÅÏ¢
dba_free_space Êý¾Ý¿â¿ÕÏпռä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ