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)
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 ......
À´Ô´ÓÚhttp://hi.baidu.com/edeed/blog/item/33576327d1b73d00918f9dd4.html
±¾ÊÓͼ×ÔÆô¶¯¼´±£³Ö²¢¼Ç¼¸÷»Ø¹ö¶Îͳ¼ÆÏî¡£ÔÚѧϰ±¾ÊÓͼ֮ǰ£¬ÎÒÃÇÏÈÀ´Á˽âһϻعö¶Î(rollback segment)µÄÏà¹Ø¸ÅÄ
»Ø¹ö¶Î¸ÅÊö
»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐ ......
ÔÚNet Manager¹¤¾ßÖУ¬
½«¼àÌý³ÌÐòµÄ¼àÌýλÖõÄÖ÷»úÃû¸ÄΪ Ð»úÃû
½«·þÎñÃûÖжÔÓ¦Êý¾Ý¿âµÄÖ÷»úÃû¸ÄΪ Ð»úÃû
¸ÄÁ˼àÌý³ÌÐòºó£¬ÔÚMS-DOSÖÐÔËÐÐ
lsnrctl stop
lsnr ......
oracle´æ´¢¹ý³ÌÒì³£ÐÅÏ¢µÄÏÔʾ
֮ǰд´æ´¢¹ý³Ìʱ£¬Òì³£´¦Àíд·¨ÊÇ£º
...
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END ...
ÕâÖÖд·¨µ±´æ´¢¹ý³ÌÅ׳öÒ쳣ʱ£¬ÎÒÃDz»ÖªµÀÆäµ½µ×Å׳öÁËÄÄÖÖÒì³££¨±ÈÈçÁпí¶È²»¹»´ó¶øÔÚ²åÈëÊý¾ÝʱÅ×Òì³££©£¬¿ÉÒÔ°´ÈçÏ·½Ê½ÏÔʾÒì³£ÐÅÏ¢
EXCEPTION
  ......
½ñÌì×ܽáÏÂoracleµÄÈÎÎñ¶ÓÁйÜÀíÆ÷(job queue ),ÒÔºóÒ²·½±ã²éѯ.
ÎÒÃÇÒª×ö¶¨Ê±ÈÎÎñʱ,ÓÐÁ½ÖÖ°ì·¨
Ò»ÖÖÊÇ: ²Ù×÷ϵͳµÄ¶¨Ê±,winµÄ¶¨Ê±ÈÎÎñ,unixµÄcrontab
Ò»ÖÖÊÇ: Êý¾Ý¿â¼¶µÄ¶¨Ê±,ËýµÄЧÂʸü¸ß,
ÔÙÓдóÁ¿µÄ±í¼¶²Ù×÷ʱ,½¨ÒéÓÃÊý¾Ý¿â±¾ÉíµÄjob queue,ÕâÑù·½±ã,ЧÂʸß;Èç¹ûÓÃϵͳ¼¶¶¨Ê±,
»áÔö¼ÓºÜ¶à±à³Ì¹¤×÷,³É±¾Ôö¼Ó ......