Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ¼¯ºÏÔËËã·û

±í1£ºtemp1
AA    BB    CC
1      1      1
1      1      2
1      1      3
±í2£ºtemp2
AA    BB  ......

oracle º¯ÊýÕûÀí(Ò»)

1. ASCII: ·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii(0) zero,ascii('') space from dual; 
   A A ZERO SPACE
   --------- --------- --------- ---------
   65 97 48 
2. CHR:¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQ ......

¹ØÓÚoracleÊý¾Ý¿â°²×°²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿âµÈÎÊÌâ


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

¹ØÓÚOracleµÄÐòÁУ¨Sequence£©Ê¹ÓÃ

OracleûÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬ÎÒÃÇÐèÒª½¨Á¢Ò»¸ö×Ô¶¯Ôö³¤µÄÐòÁкţ¬²åÈë¼Ç¼ʱҪ°ÑÐòÁкŵÄÏÂÒ»¸öÖµ¸³ÓÚ´Ë×ֶΣ¡
create sequence type_id increment by 1 start with 1;
Õâ¾äÖУ¬type_idΪÐòÁкŵÄÃû³Æ£¬Ã¿´ÎÔö³¤Îª1£¬ÆðʼÐòºÅΪ1¡£
Èç¹ûҪɾ³ýÐòÁУ¬ÓÃdrop sequence ÐòÁÐÃû¾Í¿ÉÒÔÁË£¡£¡
ÐòÁпÉÒÔ±£Ö¤¶à¸öÓû§¶ÔÍ¬Ò»Õ ......

oracle 8i,9iºÍ10g µÄÇø±ð

Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
 ¼òҪ˵£º
    9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
    ²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
    9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ