Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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).
ÐÐǨÒƺÍÐÐÁ´½ÓµÄ¼ì²â£º
³ýÁËÎÒдµÄ´æ´¢¹ý³Ì¿ÉÒÔ¼ì²âÒÔÍ⣬һ¸ö¼òµ¥µÄ¼ì²â·


Ïà¹ØÎĵµ£º

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

1.¾ø¶ÔÖµ 
S:select abs(-1) value
O:select abs(-1)  value from dual
2.È¡Õû(´ó) 
S:select ceiling(-1.001) value  
O:select ceil(-1.001)  value from dual
3.È¡Õû£¨Ð¡£© 
S:select floor(-1.001) value  
O:select floor(-1.001)  value from dual
4.È ......

¶ÔoracleÊý¾Ý¿âÖÐCLOB×ֶεÄÏà¹Ø²Ù×÷


import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * ´Ë´¦²åÈëÀàÐÍ˵Ã÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:55 ......

BLOBת»»ÎªCLOBµÄº¯Êý£¨oracleÖÐÖ´ÐУ©

BLOBת»»ÎªCLOBµÄº¯Êý£¨oracleÖÐÖ´ÐУ©
CREATE OR REPLACE FUNCTION BlobToClob(blob_in IN BLOB) RETURN CLOB AS
  v_clob    CLOB;
  v_varchar VARCHAR2(32767);
  v_start  PLS_INTEGER := 1;
  v_buffer  PLS_INTEGER := 32767;
BEGIN
  DBMS_LOB.CRE ......

oracle 9iÉý¼¶µ½oracle9208Êý¾Ý¿â

±³¾°£ºÔÚwindows2003serverÉÏ°²×°ÁËOracle9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×îÐµİ²È«²¹¶¡April2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©
  (1)µ½metalinkÏÂÔØÉý¼¶Ñ¹Ëõ°ü£¬patchºÅΪ4547809£¬Ñ¹Ëõ°üÃû³ÆΪ p4547809_92080_WINNT.zip£¬for windows 32bit¡£
  (2)½âѹËõzip£¬Ï±߰üº¬Ò»¸ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ