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

Oracle¸ßˮλÏß

1. ×¼±¸ÖªÊ¶£ºORACLEµÄÂß¼­´æ´¢¹ÜÀí.
ORACLEÔÚÂß¼­´æ´¢ÉÏ·Ö4¸öÁ£¶È:±í¿Õ¼ä,¶Î,ÇøºÍ¿é.
1.1 ¿é:ÊÇÁ£¶È×îСµÄ´æ´¢µ¥Î»,ÏÖÔÚ±ê×¼µÄ¿é´óСÊÇ8K,ORACLEÿһ´ÎI/O²Ù×÷Ò²ÊÇ°´¿éÀ´²Ù×÷µÄ,Ò²¾ÍÊÇ˵µ±ORACLE´ÓÊý¾ÝÎļþ¶ÁÊý¾Ýʱ,ÊǶÁÈ¡¶àÉÙ¸ö¿é,¶ø²»ÊǶàÉÙÐÐ.
1.2 Çø:ÓÉһϵÁÐÏàÁڵĿé¶ø×é³É,ÕâÒ²ÊÇORACLE¿Õ¼ä·ÖÅäµÄ»ù±¾µ¥Î»,¾Ù¸öÀý×ÓÀ´Ëµ,µ±ÎÒÃÇ´´½¨Ò»¸ö±íPM_USERʱ,Ê×ÏÈORACLE»á·ÖÅäÒ»ÇøµÄ¿Õ¼ä¸øÕâ¸ö±í,Ëæ×Ų»¶ÏµÄINSERTÊý¾Ýµ½PM_USER,Ô­À´µÄÕâ¸öÇøÈݲ»Ï²åÈëµÄÊý¾Ýʱ,ORACLEÊÇÒÔÇøΪµ¥Î»½øÐÐÀ©Õ¹µÄ,Ò²¾ÍÊÇ˵ÔÙ·ÖÅä¶àÉÙ¸öÇø¸øPM_USER,¶ø²»ÊǶàÉÙ¸ö¿é.
1.3 ¶Î:ÊÇÓÉһϵÁеÄÇøËù×é³É,Ò»°ãÀ´Ëµ,µ±´´½¨Ò»¸ö¶ÔÏóʱ(±í,Ë÷Òý),¾Í»á·ÖÅäÒ»¸ö¶Î¸øÕâ¸ö¶ÔÏó.ËùÒÔ´ÓijÖÖÒâÒåÉÏÀ´Ëµ,¶Î¾ÍÊÇijÖÖÌض¨µÄÊý¾Ý.ÈçCREATE TABLE PM_USER,Õâ¸ö¶Î¾ÍÊÇÊý¾Ý¶Î,¶øCREATE INDEX ON PM_USER(NAME),ORACLEͬÑù»á·ÖÅäÒ»¸ö¶Î¸øÕâ¸öË÷Òý,µ«ÕâÊÇÒ»¸öË÷Òý¶ÎÁË.²éѯ¶ÎµÄÐÅÏ¢¿ÉÒÔͨ¹ýÊý¾Ý×Öµä: SELECT * from USER_SEGMENTSÀ´»ñµÃ,
1.4 ±í¿Õ¼ä:°üº¬¶Î,Çø¼°¿é.±í¿Õ¼äµÄÊý¾ÝÎïÀíÉÏ´¢´æÔÚÆäËùÔÚµÄÊý¾ÝÎļþÖÐ.Ò»¸öÊý¾Ý¿âÖÁÉÙÒªÓÐÒ»¸ö±í¿Õ¼ä.
µ±ÎÒÃÇ´´½¨ÁËÒ»¸ö±í£¬¼´Ê¹ÎÒûÓвåÈëÈκÎÒ»ÐмǼ,ORACLE»¹ÊǸøËü·ÖÅäÁË8¸ö¿é.µ±È»Õâ¸ö¸ú½¨±íÓï¾äµÄINITIAL ²ÎÊý¼°MINEXTENTS²ÎÊýÓйØ:Çë¿´TEST_TABµÄ´æ´¢²ÎÊý:
STORAGE
(
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
);
Ò²¾ÍÊÇ˵,ÔÚÕâ¸ö¶ÔÏó´´½¨ÒÔºó,ORACLEÖÁÉÙ¸øËü·ÖÅäÒ»¸öÇø,³õʼ´óСÊÇ64K,Ò»¸ö±ê×¼¿éµÄ´óСÊÇ8K,¸ÕºÃÊÇ8¸öBLOCK.
2. ʲôÊǸßË®Ïß(High Water Mark)
ËùÓеÄoracle¶Î¶¼ÓÐÒ»¸öÔÚ¶ÎÄÚÈÝÄÉÊý¾ÝµÄÉÏÏÞ£¬ÎÒÃÇ°ÑÕâ¸öÉÏÏÞ³ÆΪ"high water mark"»òHWM¡£Õâ¸öHWMÊÇÒ»¸ö±ê¼Ç£¬ÓÃÀ´ËµÃ÷ÒѾ­ÓжàÉÙûÓÐʹÓõÄÊý¾Ý¿é·ÖÅä¸øÕâ¸ösegment¡£HWMͨ³£Ôö³¤µÄ·ù¶ÈΪһ´Î5¸öÊý¾Ý¿é£¬Ô­ÔòÉÏHWMÖ»»áÔö´ó£¬²»»áËõС£¬¼´Ê¹½«±íÖеÄÊý¾ÝÈ«²¿É¾³ý£¬HWM»¹ÊÇΪԭֵ£¬ÓÉÓÚÕâ¸öÌص㣬ʹHWMºÜÏóÒ»¸öË®¿âµÄÀúÊ·×î¸ßˮ룬ÕâÒ²¾ÍÊÇHWMµÄԭʼº¬Ò壬µ±È»²»ÄÜ˵һ¸öË®¿âûˮÁË£¬¾Í˵¸ÃË®¿âµÄÀúÊ·×î¸ßˮλΪ0¡£µ«ÊÇÈç¹ûÎÒÃÇÔÚ±íÉÏʹÓÃÁËtruncateÃüÁÔò¸Ã±íµÄHWM»á±»ÖØÐÂÖÃΪ0¡£
ÈçºÎÖªµÀÒ»¸ö±íµÄHWM£¿
a) Ê×ÏȶԱí½øÐзÖÎö:
ANALYZE TABLE <tablename> ESTIMATE/COMPUTE STATISTICS;
b) ²é¿´Ïà¹ØÐÅÏ¢£º
SELECT  blocks, empty_blocks, num_rows  from user_tables
WHERE table_name = <tablename>;
BLOCKS Áдú±í¸Ã±íÖÐÔø¾­Ê¹Óù


Ïà¹ØÎĵµ£º

ÈçºÎÔÚÁ½Ì¨²»Í¬µÄ»úÆ÷ÉÏ°²×°ÅäÖÃArcSDE £¨oracle£©

ʹÓÃsdeupgradeora9iÓ¦ÓóÌÐòÉý¼¶ºó£¬ÔÙ°´ÕÕÒ»°ãµÄpost·½·¨post,ÔÚÌîдnet service nameʱ£¬Ê¹ÓÃoracle¿Í»§¶ËµÄ net manager ÅäÖÃÒ»¸öÁíһ̨oracleÊý¾Ý¿âµÄservice name;ÆäÓà°´ÕÕ Ò»°ã·½·¨½øÐУ¬PostÍê³Éºó£¬ÐÞ¸Ä$sdehome/dbinit.sde
 set ORACLE_SID = ORCL;Ϊ
set LOCLA=service name;
Æô¶¯·þÎñ¼´¿É¡£ ......

oracle µÄÍêȫжÔØ

1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\\ORACLE
ʵÏÖ·½·¨£º
1¡¢        ¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ
        Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢        ¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£ ......

ɱËÀOracleÊý¾Ý¿âÖпͻ§¶ËÓû§Á¬½Ó½ø³Ì

<Ò»>ʵÏÖɱËÀij¸öÓû§µÄ¿Í»§¶ËÁ¬½Ó½ø³Ì
1.ÒÔ¹ÜÀíÔ±Éí·ÝµÇ¼ºó²é¿´V$SESSIONµÄÊÓͼ½á¹¹
SQL> desc v$session;
 Ãû³Æ                             &n ......

OracleÌṩÁË·ÖÇø¼¼Êõ(»ã×ÜÌû)

OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£ 
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔͨ¹ýÔÚ²éѯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ