ORACLEµÈ´ýʼþÀàÐÍ(Ò»)
author:skate
tiime:2009-11-18
ORACLEµÈ´ýʼþÀàÐÍ¡¾Classes of Wait Events¡¿
ÿһ¸öµÈ´ýʼþ¶¼ÊôÓÚijһÀ࣬ÏÂÃæ¸ø³öÁËÿһÀàµÈ´ýʼþµÄÃèÊö¡£¡¾Every wait event belongs to a class of wait event.
The following list describes each of the wait classes.¡¿
1. ¹ÜÀíÀࣺAdministrative
´ËÀàµÈ´ýʼþÊÇÓÉÓÚDBAµÄ¹ÜÀíÃüÁîÒýÆðµÄ£¬ÕâЩÃüÁîÒªÇóÓû§´¦Óڵȴý״̬£¬±ÈÈç£¬ÖØ½¨Ë÷Òý¡£¡¾Waits resulting from DBA
commands that cause users to wait (for example, an index rebuild)¡¿
2. Ó¦ÓóÌÐòÀࣺApplication
´ËÀàµÈ´ýʼþÊÇÓÉÓÚÓû§Ó¦ÓóÌÐòµÄ´úÂëÒýÆðµÄ£¨±ÈÈç£ºËøµÈ´ý£©¡¾Waits resulting from user application code (for example,
lock waits caused by row level locking or explicit lock commands)¡¿
3. Ⱥ¼¯ÀࣺCluster
´ËÀàµÈ´ýʼþºÍÕæÕýÓ¦ÓÃȺ¼¯RACµÄ×ÊÔ´Óйء££¨±ÈÈ磺gc cr block busyµÈ´ýʼþ£©¡¾Waits related to Real Application Cluster
resources (for example, global cache resources such as 'gc cr block busy'¡¿
4. ÌύȷÈÏÀࣺCommit
´ËÀàµÈ´ýʼþÖ»°üº¬Ò»Öֵȴýʼþ££ÔÚÖ´ÐÐÁËÒ»¸öcommitÃüÁîºó£¬µÈ´ýÒ»¸öÖØ×öÈÕ־дȷÈÏ£¨Ò²¾ÍÊÇlog file sync£©¡¾This wait class
only comprises one wait event - wait for redo log write confirmation after a commit (that is, 'log file sync')¡¿
5. ²¢·¢ÀࣺConcurrency
´ËÀàµÈ´ýʼþÊÇÓÉÄÚ²¿Êý¾Ý¿â×ÊÔ´ÒýÆðµÄ£¬±ÈÈçãÅËø¡£¡¾Waits for internal database resources (for example, latches)¡¿
6. ÅäÖÃÀࣺConfiguration
´ËÀàµÈ´ýʼþÊÇÓÉÊý¾Ý¿â»òʵÀýµÄ²»µ±ÅäÖÃÔì³ÉµÄ£¬±ÈÈç£¬ÖØ×öÈÕÖ¾Îļþ³ß´ç̫С£¬¹²Ïí³ØµÄ´óСµÈ¡£¡¾Waits caused by inadequate
configuration of database or instance resources (for example, undersized log file sizes, shared pool size)¡¿
7. ¿ÕÏÐÀࣺIdle
´ËÀàµÈ´ýʼþÒâζׯỰ²»»îÔ¾£¬µÈ´ý¹¤×÷¡£±ÈÈç,sql * net messages from client¡£¡¾Waits that signify the session is inactive,waiting for work (for example, 'SQL*Net message from client')¡¿
8. ÍøÂçÀࣺNetwork
ºÍÍøÂç»·¾³Ïà¹ØµÄһЩµÈ´ýʼþ£¬±ÈÈçsql* net more data to dblink¡£¡¾Waits related to network messaging (for example,
'SQL*Net more data to dblink')¡¿
9. Other
´ËÀàµÈ´ýʼþͨ³£±È½ÏÉÙ¼û¡£¡¾Waits which should not typically occur
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäÈ»±¾ÈËûÓÐÑéÖ¤¹ý,²»¹ý¾Ý˵ͨ¹ýADODB·ÃÎÊOracle¶ÔÐÔÄÜÓ°ÏìºÜС.¶øÇÒADODB±ÈOCI8Ò²Òª·½±ãºÜ¶à,±Ï¾¹Ðí¶à¶«Î÷¶¼Ôٴηâ×°¹ý.²»¹ý²»¹ÜÔõô˵Õâ¶¼ÔÚÖмäÓÖ¼ÓÉÏÁËÒ»²ã,ÀíÂÛÉÏÀ´Ëµ³öÏÖÎÊÌâµÄ¼¸Âʺͽâ¾öÎÊÌâµÄÄѶȶ¼±ä´óÁË.¶øOracleÓÖ¾³£ÓÃÔÚ²»ÄÜËæ±ã³öÎÊÌâµÄ»·¾³,ËùÒÔÏë±ØÏëÒªÖ±½ÓʹÓÃOCIµÄÇé¿öÒ²²»ÉÙ.ÒÔϾÍÊÇÎÒµÄÀý×Ó:
<?p ......
¡¡¡¡OracleµÄ·ÖÇø¼¼ÊõÔÚijЩÌõ¼þÏ¿ÉÒÔ¼«´óµÄÌá¸ß²éѯµÄÐÔÄÜ£¬ËùÒÔ±»¹ã·º²ÉÓᣴӲúÆ·ÉÏ˵£¬·ÖÇø¼¼ÊõÊÇOracleÆóÒµ°æÖжÀÁ¢ÊշѵÄÒ»¸ö×é¼þ¡£ÒÔÏÂÊǶÔÓÚ·ÖÇø¼°±¾µØË÷ÒýµÄÒ»¸öʾÀý¡£
¡¡¡¡OracleµÄ·ÖÇø¼¼ÊõÔÚijЩÌõ¼þÏ¿ÉÒÔ¼«´óµÄÌá¸ß²éѯµÄÐÔÄÜ£¬ËùÒÔ±»¹ã·º²ÉÓᣴӲúÆ·ÉÏ˵£¬·ÖÇø¼¼ÊõÊÇOracleÆóÒµ°æÖжÀÁ¢ÊշѵÄÒ»¸ö ......
http://www.csip.com.cn/88/n-52488.html
¹ØÓÚ·ÖÇø±íºÍ·ÖÇøË÷Òý(About Partitioned Tables and Indexes)¶ÔÓÚ10gR2¶øÑÔ£¬»ù±¾ÉÏ¿ÉÒԷֳɼ¸Àࣺ
Range(·¶Î§)·ÖÇø
Hash(¹þÏ£)·ÖÇø
List(Áбí)·ÖÇø
ÒÔ¼°×éºÏ·ÖÇø£ºRange-Hash,Range-List¡£
¶ÔÓÚ±í¶øÑÔ(³£¹æÒâÒåÉϵĶÑ×éÖ¯±í)£¬ÉÏÊö·ÖÇøÐÎʽ¶¼¿ÉÒÔÓ¦ÓÃ(ÉõÖÁ¿ÉÒÔ¶Ôij¸ö ......
Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
¼òҪ˵£º
9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......