Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Êý¾Ý¿â°²×°²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿âµÈÎÊÌâ


³õ³õѧϰoracle 10g,×î»ù±¾µÄÎÊÌâ¾ÍÊǰ²×°Êý¾Ý¿â,³õ³õ°²×°Êý¾Ý¿âʱ,°²×°Óë±ðÈ˵ͼ²î²»¶à,¾ÍÊÇÔÚ×îºóʱ,²»ÄÜ×ÔÐÐÅä×°Êý¾Ý¿â,Òª×Ô¼ºÅäÖÃÊý¾Ý¿â,×îºó¾­¹ý×Ô¼ºµÄÅŲé:ÔÚ°²×°ÏµÍ³Ê±,ϵͳµÄ¼ÆËã»úÃû³Æ(×¢²á¼ÆËã»úʱÓõÄ)ΪӢÎÄ,Óû§Ãû³ÆÎªÖÐÎÄ,Òò´Ë²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿â,
¾­¹ý±¾È˵Ķà´ÎʵÑé,ÔÚ¼ÆËã»úÃû³Æ¡¢Óû§ÃûΪӢÎĵÄ×´Ì¬Ï ......

Oracleϵͳ¹ÜÀíºÍϵͳ×ÊÁÏ»ñÈ¡µÄһЩ»ù±¾ÃüÁî

×ÊÁÏ»ñÈ¡×ÔѧϰºÎÃ÷Öø×÷<<Oracle DBA Åàѵ½Ì³Ì>>µÚ¶þ°æÖ®Ê±.ÆäÖÐdba_¿ªÍ·µÄ±íÐèÒªÓÐsysdbaȨÏÞ²ÅÄÜ·ÃÎÊ.
1. »ñÈ¡Êý¾Ý¿âÃû×Ö,´´½¨ÈÕÆÚ,µ±Ç°Ä£Ê½,ÈÕ־ģʽµÈµÈ:
SELECT name,created,log_mode,open_mode from v$database;
2. »ñÈ¡ÔËÐÐʵÀýµÄÖ÷»úÃû,ʵÀýÃû,°æ±¾:
SELECT host_name,instance_name,ve ......

ORACLE NULLÏê½â

ÎÊ£ºÊ²Ã´ÊÇNULL£¿
´ð£ºÔÚÎÒÃDz»ÖªµÀ¾ßÌåÓÐʲôÊý¾ÝµÄʱºò£¬Ò²¼´Î´Öª£¬¿ÉÒÔÓÃNULL£¬ÎÒÃdzÆËüΪ¿Õ£¬ORACLEÖУ¬º¬ÓпÕÖµµÄ±íÁ㤶ÈΪÁã¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ÝÀàÐ͵Ä×Ö¶ÎΪ¿Õ£¬³ýÁËÒÔÏÂÁ½ÖÖÇé¿ö£º
1¡¢Ö÷¼ü×ֶΣ¨primary key£©£¬
2¡¢¶¨ÒåʱÒѾ­¼ÓÁËNOT NULLÏÞÖÆÌõ¼þµÄ×Ö¶Î
˵Ã÷£º
1¡¢µÈ¼ÛÓÚûÓÐÈκÎÖµ¡¢ÊÇδ֪Êý¡£
2 ......

Oracle 10g´´½¨·ÖÇø±í¼°Ë÷Òý»¯±í

http://blog.sina.com.cn/s/blog_3fed8ad60100bydo.html
 1¡¢Ê×ÏÈÀûÓÃsystemÕÊ»§´´½¨ÐµķÖÇø£º
my_space1, my_space2(ÀûÓÃÍøÒ³¿ØÖÆÌ¨´´½¨±í¿Õ¼äÒÔ¼°ÓôúÂë´´½¨)¡£
ÔÚʵ¼Ê¹¤×÷ÖУ¬²»Í¬µÄÇø¿ÉÒÔλÓÚ²»Í¬µÄÎïÀí´ÅÅÌÖУ¬²ÅÓÐÕæÕý·ÖÇøµÄЧ¹û¡£
È»ºó£ºÓÃscottÕÊ»§´´½¨·¶Î§·ÖÇø±í£º
create table t1(
id number(5) pri ......

ÉîÈëѧϰOracle·ÖÇø±í¼°·ÖÇøË÷Òý

http://www.csip.com.cn/88/n-52488.html
 ¹ØÓÚ·ÖÇø±íºÍ·ÖÇøË÷Òý(About Partitioned Tables and Indexes)¶ÔÓÚ10gR2¶øÑÔ£¬»ù±¾ÉÏ¿ÉÒԷֳɼ¸Àࣺ
Range(·¶Î§)·ÖÇø
Hash(¹þÏ£)·ÖÇø
List(Áбí)·ÖÇø
ÒÔ¼°×éºÏ·ÖÇø£ºRange-Hash,Range-List¡£
¶ÔÓÚ±í¶øÑÔ(³£¹æÒâÒåÉϵĶÑ×éÖ¯±í)£¬ÉÏÊö·ÖÇøÐÎʽ¶¼¿ÉÒÔÓ¦ÓÃ(ÉõÖÁ¿ÉÒÔ¶Ôij¸ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ