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 Áдú±í¸Ã±íÖÐÔø¾Ê¹Óù
Ïà¹ØÎĵµ£º
Ó¦¸¶Ä£¿éµÄ¶àÊýÒµÎñ»ùÓڲɹººÍ¿â´æµÄ²Ù×÷£¬Òò´ËÓ¦¸¶Ä£¿éµÄÔ½áÓ¦¸ÃÔڲɹºÄ£¿éºÍ¿â´æÄ£¿éÔ½áºó²ÅÄܹرջá¼ÆÆÚ¡£
Ô½ᲽÖè
ÔÚÿ¸ö»á¼ÆÆÚÄ©£¬Ó¦¸¶Ä£¿éµÄÔ½áÓ¦×ñÑÒÔÏÂÁ÷³Ì£º
1.¼ì²éÒµÎñÊÇ·ñÈ«²¿Â¼Èë;
2.¼ì²éÊÇ·ñÓÐδÑéÖ¤¡¢Ôݹҷ¢Æ±;
3.¸üе½ÆÚµÄÔ¶ÆÚ¸¶¿î״̬;
4.¼ì²éÓ¦¸¶ÒµÎñÊÇ·ñÉú³É·Ö¼;
5.Ó¦¸¶ÒµÎñ´«Ë͵½×ÜÕÊ;
6 ......
Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯ ¡¡¡¡
Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÈݹØϵ¡£ORACLE
Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£ËüʹÊý¾Ý¿â¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ
»¯ÓïÑÔºÍƽ̨¡£ ¡¡¡¡
Ó°ÏìoracleÊý¾Ý¿â×Ö·û¼¯ ......
ÒÔÏ»شðÊôÓÚתÔØ£º
¾³£¿´µ½Ò»Ð©ÅóÓÑÎÊORACLE×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî¡£
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆѧ¼ÆËãµÄ£¨Ë ......
analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use ......
Close a Database
When you close a database, Oracle writes all database data and recovery data in the SGA to the datafiles and redo log files, respectively. Next, Oracle closes all online datafiles and redo log files. (Any offline datafiles of any offline tablespaces have been closed already. If you ......