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

Oracle ʵÏÖÐÐÁÐת»»

SQL> DESC TEST  ²âÊÔ±í:        Name    Type            Nullable    Default Comments
       ----     ------------         --------      -------     --------
       A        NUMBER           Y                        
       B        VARCHAR2(20) Y          SQL> select * from test;                  A B
       ---------- --------------------
                 1 a
                 1 b
                 1 c
                 1 d
                 1 e
                 2 a
                 2 b
                 3 a
         


Ïà¹ØÎĵµ£º

Using Oracle Trace Analyzer (trcanlzr.sql)


Using Oracle Trace Analyzer (trcanlzr.sql)
Dave Moore:  Author of Oracle Utilities
Oracle has provided another utility initially designed for performance tuning Oracle Applications.  Trace Analyzer is provided in the form of a PL/SQL package (TRCA$ ).  The Trace Analyzer utility i ......

Oracle TNSLSNR Full Client

Most of admins neglect setting password on TNSlsnr Clients for Oracle databases. Oracle ensures that you can either connect to TNSlsnr on a localhost or through mapping to a remote Oracle database using .ora files.
This is not the case anymore Based on Jwa perl client.
This client is a FULL clie ......

oracle 10.2.0.4ÏÂÔØµØÖ·


ÏÂÔØ·½·¨£ºÔÚÏÂÃæµÄÁ¬½ÓÉϵã»÷ÓÒ¼ü£¬Ñ¡ÔñʹÓÃѸÀ×ÏÂÔØ¡£Ê¹ÓñðµÄÏÂÔØ¹¤¾ßÎÞ·¨ÏÂÔØ¡£
oracle 10.2.0.4 ²¹¶¡ÏÂÔØ£¨ÊÊÓÃÓÚËùÓвÙ×÷ϵͳ£©:
ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204 ......

Oracle¶¯Ì¬ÐÔÄÜÊÓͼѧϰ֮ V$ROLLSTAT

À´Ô´ÓÚhttp://hi.baidu.com/edeed/blog/item/33576327d1b73d00918f9dd4.html
±¾ÊÓͼ×ÔÆô¶¯¼´±£³Ö²¢¼Ç¼¸÷»Ø¹ö¶Îͳ¼ÆÏî¡£ÔÚѧϰ±¾ÊÓͼ֮ǰ£¬ÎÒÃÇÏÈÀ´Á˽âһϻعö¶Î(rollback segment)µÄÏà¹Ø¸ÅÄ
»Ø¹ö¶Î¸ÅÊö
»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ