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

ORACLEÐÔÄÜÕï¶ÏʵÀý ÐÐǨÒƺÍÐÐÁ´½Ó

ÃÀ¹úPVH DB´æÔÚÐÐÁ´½Ó.ͨ¹ýÎҵļì²é,·¢ÏÖ,ÎÒÃǵÄDBͬÑù´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.ORACLEµÄdbms_stats.gather_schema_statsÖ»»áÊÕ¼¯ÓÅ»¯Æ÷ͳ¼ÆÐÅÏ¢,²»»á¼ì²â±íµÄ¼Ç¼ÊÇ·ñ´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.(ÎÒÔ­Ïȱ»Õâ¸ö°ü¸øÆ­ÁË,ËùÒÔÖ´ÐÐÍêdbms_stats.gather_schema_statsºóÒ»²éÊý¾Ý×Öµä:USER_TABLES,ÆäÖеÄ×Ö¶Îchain_cntֵȫΪ0).Òª¼ì²â±íµÄ¼Ç¼ÊÇ·ñ´æÔÚrow chain,ÐèÒªÓõ½ORACLEÔçÏÈÒ»µãµÄÃüÁî:ANALYZE TABLE.ËùÒÔÎÒдÁËÒ»¸ö´æ´¢¹ý³Ì(P_analyze_schema)ÒÔ¼ì²âDB:PVH91USRDÖÐËùÓбí´æÔÚÐÐÁ´½ÓµÄÇé¿ö.
         ÖµµÃ×¢ÒâµÄÊÇ:Êý¾Ý×Öµä USER_TABLES.CHAIN_CNTµÄÖµÊÇ°üº¬ÁËÐÐǨÒƺÍÐÐÁ´½ÓµÄÊýÄ¿.Çë¿´ORACLEµÄ½âÊÍ:
CHAIN_CNT*  Number of rows in the table that are chained from one data block to another, or which have migrated to a new block, requiring a link to preserve the old ROWID
Ò²¾ÍÊÇ˵Õâ¸ö×ֶεÄÖµÊÇÐÐǨÒƺÍÐÐÁ´½ÓµÄ×ÜÊýÁ¿,ÖÁÓÚÒªÖªµÀ¾ßÌåÐÐǨÒÆÓжàÉÙ,ÐÐÁ´½ÓÓÖÊǶàÉÙ,ANALYZE TABLEÕâ¸öÃüÁîû°ì·¨µÃµ½,Ö»ÓÐͨ¹ýDUMP BLOCKÀ´Çø·Ö(·½·¨¸´ÔÓ,¹ÊûÓÐÈ¥×ö).µ«Ê×ÏÈÎÒÃÇÒªÖªµÀÐÐǨÒƺÍÐÐÁ´½ÓÊÇÁ½¸ö²»Í¬µÄ¸ÅÄî:
(1)ÐÐǨÒÆ: ORACLEÒ»¸öBLOCKµÄDEFAULT SIZEÊÇ8K,ÊÂʵÉÏ,Ò»¸öBLOCK²»¿ÉÒÔ´æ´¢8KµÄÊý¾Ý.Ò»¸öBLOCK¿ÉÒÔ´æ´¢¶àÉÙÊý¾Ý,ÓÉPCTFREE,PCTUSED²ÎÊý¿ØÖÆ(¶ÔÓÚÒÔÇ°µÄÊÖ¹¤¹ÜÀíµÄ±í¿Õ¼ä¶øÑÔ).
PCTFREE:ÊÇÖ¸BLOCK±£Áô¿ÕÏпռäµÄ°Ù·Ö±È,ÓÃÓÚUPDATE¡£¶ÔÓÚÒѾ­²åÈëµ½BLOCKµÄÐжøÑÔ£¬ºóÃæµÄUPDATE²Ù×÷ÓпÉÄÜʹÐеij¤¶ÈÔö¼Ó£¬PCTFREE¾ÍÊÇÓÃÓÚÈÝÄÉÔö¼ÓµÄÄDz¿·Ö³¤¶È¶ø±£ÁôµÄ¿ÕÏпռ䡣Èç¹ûUPDATEʱPCTFREEÔÙÒ²²»Äܹ»ÈÝÄÉÐÐÔö¼ÓµÄ³¤¶È£¬ÔòORACLE»á½«Õû¸öÐÐǨÒƵ½Ò»¸öеÄBLOCK£¬ÐеÄROWID±£Áô(²»ÊÇÌ«Ã÷°×ΪʲôORACLE²»¸Ä±äROWID)£¬Ô­À´µÄBLOCKÓÐÒ»¸öÖ¸ÕëÖ¸ÏòROW´æ·ÅµÄÐÂBLOCK¡£Õâ¾ÍÊÇÐÐǨÒÆ¡£¿É¼û£¬ÐÐǨÒÆÊÇÓÉÓÚUPDATE²Ù×÷Ëùµ¼Ö¡£´Ó×ÖÃæÉÏÀí½â£¬ËùνǨÒÆ£¬¿Ï¶¨ÏÈÓдæÔÚÕâÒ»ÐУ¬²ÅÄܽÐ×ÅǨÒÆ.
 
PCTUSED£ºÊÇÖ¸BLOCKÓÃÓÚINSERTµÄ°Ù·Ö±È¡£¶ÔÓÚINSERT²Ù×÷£¬BLOCK¿ÉÓÃÓÚÈÝÄÉÐÂÐеÄ×î´ó¿Õ¼äΪBlocksize-pctfree-overhead.µ±BLOCKÊý¾Ý´æ´¢ÒѸßÓÚPCTUSED£¬ORACLE»á½«¸Ã¿é´Ó×ÔÓÉÁ´±íÖÐÒƳý£¬Ö±µ½¸Ã¿éÒÑʹÓÿռ併µ½PCTUSEDÒÔÏ£¬²Å»áÔٴν«´Ë¿éÖØмÓÈëµ½Freelist(ÕâÊÇORACLEÒÔÇ°ÊÖ¹¤¹ÜÀíµÄ±í¿Õ¼ä¹ÜÀí¿ÕÏпéµÄÔ­Àí,ÏÖÔÚORACLEÍƼöʹÓÃASSM).
ÐÐǨÒƺÍÐÐÁ´½ÓµÄ¼ì²â£º
³ýÁËÎÒдµÄ´æ´¢¹ý³Ì¿ÉÒÔ¼ì²âÒÔÍ⣬һ¸ö¼òµ¥µÄ¼ì²â·


Ïà¹ØÎĵµ£º

Oracle 10G DataGuard

http://hi.baidu.com/firefly5002/blog/item/5b5719fcb5bd3e1d08244d11.html
Oracle 10G DataGuard
server A: 10.85.10.44 SID=mesdb
target server B: 10.85.10.43
oracle version:10.2.0.1
OS platform : windows 2003
Data GuardĬÈÏÊÇmaximize performance£¬ ¿ÉÒÔÓÃÒÔÏÂÓï¾äÀ´½øÐÐģʽ¼äµÄÇл»¡£
ALTER DATABASE ......

oracle³£ÓÃÊý¾ÝÀàÐÍ

oracle³£ÓÃÊý¾ÝÀàÐÍ
½ñÌìͬÊÂÎÊЩÊý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓеĻ¹ÕæÓеã¼Ç²»ÇåÁË£¬ÓÚÊǾͼòµ¥×ܽáϳ£ÓõÄÊý¾ÝÀàÐÍÒÔ±¸ÈÕºó²éÓÃ
1¡¢Char
¶¨³¤¸ñʽ×Ö·û´®£¬ÔÚÊý¾Ý¿âÖд洢ʱ²»×ãλÊýÌî²¹¿Õ¸ñ£¬ËüµÄÉùÃ÷·½Ê½ÈçÏÂCHAR(L)£¬LΪ×Ö·û´®³¤¶È£¬
ȱʡΪ1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ2000¡£²»½¨ÒéʹÓ㬻ᴠ......

ORACLE´ø²ÎÈ«Á¬½Ó

    
  select * from (
  select cw2.NO WHOLENO,sp1.ARGUMENTNAME TYPENAME,sp2.ARGUMENTNAME BRANDNAME,sp3.ARGUMENTNAME STYLENAME,sp4.ARGUMENTNAME DEPART,so.OPERATORNAME USERNAME
  from COM_WHOLE_INFO cw2,SYS_OPERATOR so, SYS_PUBLICARGUMENT sp1, SYS_PUBLICARGUMEN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ