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

oracle wait event:reliable message

½ñÌì¿Í»§µÄÒ»Ì×RAC»·¾³³öÏÖÎÊÌâ
Ë«½ÚµãRAC»·¾³ÖУ¬Ò»¸ö½ÚµãÒòΪËø¾ºÕù¶ø¹ÒÆð£¬shutdownÖ®ºóÎÞ·¨Æô¶¯¡£
¹ÊÕϳöÏÖʱÎÒÕýÔÚ·ÉÏ£¬´Ò´Ò»Øµ½¼ÒÖУ¬´¦Àí¹ÊÕÏ¡£
½â¾öÖ®ºó²éÕÒ¹ÊÕÏÔ­Òò¡£
¼ì²éµ±Ê±µÄAWRÐÅÏ¢·¢ÏÖTop 5 Timed EventsÏÔʾÈçÏÂÐÅÏ¢£º
Top 5 Timed Events                                        Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait  Call
Event                                Waits    Time (s)  (ms)  Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
reliable message                        354          89    251  219.4      Other
CPU time                                            32          78.3
db file sequential read              2,223          12      6  30.3  User I/O
control file sequential read     


Ïà¹ØÎĵµ£º

Oracle PL/SQL¹ÜÀíLDAP·þÎñÆ÷(DBMS_LDAP°üµÄʹÓÃ)

Á˽âLDAP

LDAPÊÇLight Directory Access ProtocolÇáÁ¿¼¶Ä¿Â¼·ÃÎÊЭÒéµÄ¼ò³Æ£¬LDAPÓëÊý¾Ý¿âÓкܴóµÄÇø±ð£¬ËüµÄÊý¾ÝÊÇÊ÷×´µÄ£¬¶øÇÒÿ¸ö½ÚµãµÄÊôÐÔÒ²±È½Ï¹Ì¶¨¡£
LDAPЭÒéÖÐÓÃdn±íʾһÌõ¼Ç¼µÄλÖã¬dc±íʾһÌõ¼Ç¼ËùÊôÇøÓò£¬ou±íʾһÌõ¼Ç¼ËùÊô×éÖ¯£¬cn±íʾһÌõ¼Ç¼µÄÃû³Æ£¬uid±íʾһÌõ¼Ç¼µÄID£¬ÆäÖÐdnÊǸù¾ ......

SQL ServerºÍOracleµÄ³£Óú¯Êý±È½Ï

---------Êýѧº¯Êý ---------------
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:select floor(-1.001) value
¡¡¡¡O:select floor(-1.001) value from ......

Java»ñÈ¡Oracle´æ´¢¹ý³ÌÖÐÖ´Ðвéѯ·µ»ØµÄ½á¹û¼¯

ͨ¹ýJAVAµ÷ÓÃORACLEµÄ´æ´¢¹ý³Ì£¬ÔÚORACLEµÄ´æ´¢¹ý³ÌÄÚ²¿×öÁËÒ»¸ö²éѯÔÚJAVAÖлñÈ¡¸Ã²éѯ½á¹û£¬Õâ¸öºÍSYBASE¡¢SQLSERVERµÄ»ñÈ¡²»Ò»Ñù£¬µÈÎÒµÄÏÂһƪÎÄÕÂÎÒ»á½éÉÜÈçºÎ»ñÈ¡SYBASE¡¢SQLSERVERÔÚ´æ´¢¹ý³ÌÖÐÖ´ÐÐÁ˲éѯºóÈçºÎ»ñÈ¡Æä½á¹û¼°´æ´¢¹ý³ÌµÄ±àд¡£
ÔÚOracleÖÐÐèÒª·µ»Ø²éѯ½á¹û¼¯£¬±ØÐ뽫ÆäÒÔÓαêµÄÐÎʽ·µ»Ø£¬µ«ÓαêÓÖ²»ÊÇ ......

ORACLE NLS_LANG²ÎÊýÏê½â

NLS_LANG²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG= <Language>_ <Territory>. <Clients Characterset>
ÆäÖУº
LANGUAGEÖ¸¶¨:
-OracleÏûϢʹÓõÄÓïÑÔ
-ÈÕÆÚÖÐÔ·ݺÍÈÕÏÔʾ
TERRITORYÖ¸¶¨
-»õ±ÒºÍÊý×Ö¸ñʽ
-µØÇøºÍ¼ÆËãÐÇÆÚ¼°ÈÕÆÚµÄÏ°¹ß
CHARACTERSET:
-¿ØÖÆ¿Í»§¶ËÓ¦ÓóÌÐòʹÓõÄ×Ö·û¼¯ ......

oracleʵÏÖºº×Ö°´ÕÕÆ´Òô¡¢±Ê»­ºÍ²¿Ê×ÅÅÐò

oracleʵÏÖºº×Ö°´ÕÕÆ´Òô¡¢±Ê»­ºÍ²¿Ê×ÅÅÐò
ÕÒÁËÏà¹ØµÄһЩ×ÊÁÏ£¬¶¼ËµµÄ²»ÊǺÜÇå³þ£¬×Ô¼ºÒ²Ñо¿ÁËÏ£¬ÖÕÓÚ¸ãÃ÷°×ÁË£¬Ï£Íû¶Ô´ó¼ÒÓаïÖú¡£
ÐèҪ˵Ã÷µÄÊÇÏÂÃæµÄ·½·¨ÐèÒªORACLE9iºÍÒÔÉϵİ汾²ÅÖ§³Ö¡£
Oracle9i֮ǰ£¬ÖÐÎÄÊÇ°´ÕÕ¶þ½øÖƱàÂë½øÐÐÅÅÐòµÄ¡£
ÔÚoracle9iÖÐÐÂÔöÁË°´ÕÕÆ´Òô¡¢²¿Êס¢±Ê»­ÅÅÐò¹¦ÄÜ¡£ÉèÖÃNLS_SORTÖµ
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ