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 ......
³õ³õѧϰoracle 10g,×î»ù±¾µÄÎÊÌâ¾ÍÊÇ°²×°Êý¾Ý¿â,³õ³õ°²×°Êý¾Ý¿âʱ,°²×°Óë±ðÈ˵Ķ¼²î²»¶à,¾ÍÊÇÔÚ×îºóʱ,²»ÄÜ×ÔÐÐÅä×°Êý¾Ý¿â,Òª×Ô¼ºÅäÖÃÊý¾Ý¿â,×îºó¾¹ý×Ô¼ºµÄÅŲé:ÔÚ°²×°ÏµÍ³Ê±,ϵͳµÄ¼ÆËã»úÃû³Æ(×¢²á¼ÆËã»úʱÓõÄ)ΪӢÎÄ,Óû§Ãû³ÆΪÖÐÎÄ,Òò´Ë²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿â,
¾¹ý±¾È˵Ķà´ÎʵÑé,ÔÚ¼ÆËã»úÃû³Æ¡¢Óû§ÃûΪӢÎĵÄ×´Ì¬Ï ......
1. ÒýÑÔ
2. ´¥·¢Æ÷µÄ¸ÅÄîºÍÀàÐÍ
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ËüÔÚ²åÈ룬ɾ³ý»òÐÞ¸ÄÌض¨±íÖеÄÊý¾Ýʱ´¥·¢Ö´ÐУ¬Ëü±ÈÊý¾Ý¿â±¾Éí±ê×¼µÄ¹¦ÄÜÓиü¾«Ï¸ºÍ¸ü¸´ÔÓµÄÊý¾Ý¿ØÖÆÄÜÁ¦¡£Êý¾Ý¿â´¥·¢Æ÷ÓÐÒÔϵÄ×÷Óãº
* °²È«ÐÔ¡£¿ÉÒÔ»ùÓÚÊý¾Ý¿âµÄÖµ ......
ͨ¹ýoracle 11g Á¬½Ómssql 2005 ±¨ÏÂÃæµÄ´íÎó
select * from maintanance@mssql
*
µÚ 1 ÐгöÏÖ´íÎó:
ORA-28545: Á¬½Ó´úÀíʱ Net8 Õï¶Ïµ½´íÎó
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: ½ô½Ó×Å 2 lines (Æð×Ô MSSQL)
oracle 11g listener.oraÅäÖÃÈçÏ£º
# listener.ora Network Configurati ......
Ò»¡¢Ê×ÏÈÏÂÔØ
1¡£µ½OracleµÄOTNÕ¾µãÉÏÏÂÔØOracle10g for Solaris x86µÄ°²×°ÅÌ http://www.oracle.com/technology ... ocs/solx86soft.html 2¡£ÏÂÔØÍê±ÏÒԺ󣬵õ½solarisx86_DB_10_1_0_3_Disk1.cpio.gzÎļþ ½âѹ£¬Éú³ÉDisk1Ŀ¼ $ gunzip -c solarisx86_DB_10_1_0_3_Disk1.cpio.gz | cpio -idmv È»ºó¿´oracle 10g fo ......