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 ......
http://cheneyph.javaeye.com/blog/453492
ÓÃoracle sql¶ÔÊý×Ö½øÐвÙ×÷: È¡ÉÏÈ¡Õû¡¢ÏòÏÂÈ¡Õû¡¢±£ÁôNλСÊý¡¢ËÄÉáÎåÈë¡¢Êý×Ö¸ñʽ»¯
È¡Õû£¨ÏòÏÂÈ¡Õû£©£º
select floor(5.534) from dual;
select trunc(5.534) from dual;
ÉÏÃæÁ½ÖÖÓ÷¨¶¼¿ÉÒÔ¶ÔÊý×Ö5.534ÏòÏÂÈ¡Õû£¬½á¹ûΪ5.
Èç¹ûÒªÏòÉÏÈ¡Õû £¬µÃµ½½á¹ûÎ ......
1£®Êýѧº¯Êý
¢Ù¾ø¶ÔÖµ
l S£ºselect abs(-1) value
l O£ºselect abs(-1) value from dual
¢ÚÈ¡Õû(´ó)
l S£ºselect ceiling(-001) value
l O£ºselect ceil(-001) value from dual
¢ÛÈ¡Õû£¨Ð¡£©
l S£ºselect floor(-001) value  ......
×ÊÁÏ»ñÈ¡×ÔѧϰºÎÃ÷Öø×÷<<Oracle DBA Åàѵ½Ì³Ì>>µÚ¶þ°æ֮ʱ.ÆäÖÐdba_¿ªÍ·µÄ±íÐèÒªÓÐsysdbaȨÏÞ²ÅÄÜ·ÃÎÊ.
1. »ñÈ¡Êý¾Ý¿âÃû×Ö,´´½¨ÈÕÆÚ,µ±Ç°Ä£Ê½,ÈÕ־ģʽµÈµÈ:
SELECT name,created,log_mode,open_mode from v$database;
2. »ñÈ¡ÔËÐÐʵÀýµÄÖ÷»úÃû,ʵÀýÃû,°æ±¾:
SELECT host_name,instance_name,ve ......