Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Áдú±í¸Ã±íÖÐÔø¾­Ê¹Óù


Ïà¹ØÎĵµ£º

Oracle EBS ÈçºÎÔ½áÖ®Ó¦¸¶(AP)¶ÔÕËÏê½â

Ó¦¸¶Ä£¿éµÄ¶àÊýÒµÎñ»ùÓڲɹººÍ¿â´æµÄ²Ù×÷£¬Òò´ËÓ¦¸¶Ä£¿éµÄÔ½áÓ¦¸ÃÔڲɹºÄ£¿éºÍ¿â´æÄ£¿éÔ½áºó²ÅÄܹرջá¼ÆÆÚ¡£
Ô½ᲽÖè
ÔÚÿ¸ö»á¼ÆÆÚÄ©£¬Ó¦¸¶Ä£¿éµÄÔ½áÓ¦×ñÑ­ÒÔÏÂÁ÷³Ì£º
1.¼ì²éÒµÎñÊÇ·ñÈ«²¿Â¼Èë;
2.¼ì²éÊÇ·ñÓÐδÑéÖ¤¡¢Ôݹҷ¢Æ±;
3.¸üе½ÆÚµÄÔ¶ÆÚ¸¶¿î״̬;
4.¼ì²éÓ¦¸¶ÒµÎñÊÇ·ñÉú³É·Ö¼;
5.Ó¦¸¶ÒµÎñ´«Ë͵½×ÜÕÊ;
6 ......

²é¿´Oracle×Ö·û¼¯¼°ÔõÑùÐÞ¸Ä×Ö·û¼¯£¨zt£©


Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯ ¡¡¡¡
Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÈݹØϵ¡£ORACLE
Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£ËüʹÊý¾Ý¿â¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ
»¯ÓïÑÔºÍƽ̨¡£ ¡¡¡¡
Ó°ÏìoracleÊý¾Ý¿â×Ö·û¼¯ ......

Oracle×Ö·û¼¯²âÊÔ

ÒÔÏ»شðÊôÓÚתÔØ£º
¾­³£¿´µ½Ò»Ð©ÅóÓÑÎÊORACLE×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî¡£
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆѧ¼ÆËãµÄ£¨Ë ......

Oracle·ÖÎö±íºÍË÷Òý(analyze)

analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use ......

¹Ø±ÕÊý¾Ý¿â(Ô®ÒýOracleÁª»úÎĵµ)

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ