Oracle±Ê¼Ç——תÌù
ÉùÃ÷£ºÒÔÏÂÄÚÈÝת×Ô http://www.weixiuwang.com/Article/server/tech/200610/22126.html
1. ²éѯÕýÔÚÖ´ÐÐÓï¾äµÄÖ´Ðмƻ®(Ò²¾ÍÊÇʵ¼ÊÓï¾äÖ´Ðмƻ®)
select * from v$sql_plan where hash_value = (select sql_hash_value from v$session where sid = 1111);
ÆäÖÐidºÍparent_id±íʾÁËÖ´ÐÐÊýµÄ½á¹¹,ÊýÖµ×î´óµÄΪ×îÏÈÖ´ÐÐ
±ÈÈç
ID PARENT_ID
-------------
0
1 0
2 1
3 2
4 3
5 4
6 3
ÔòÖ´Ðмƻ®Ê÷Ϊ
0
1
2
3
6 4
5
2.ÈçºÎÉèÖÃ×Ô¶¯¸ú×Ù
¡¡¡¡ÓÃsystemµÇ¼
¡¡¡¡Ö´ÐÐ$ORACLE_HOME/rdbms/admin/utlxplan.sql´´½¨¼Æ»®±í
¡¡¡¡Ö´ÐÐ$ORACLE_HOME/sqlplus/admin/plustrce.sql´´½¨plustrace½ÇÉ«
¡¡¡¡Èç¹ûÏë¼Æ»®±íÈÃÿ¸öÓû§¶¼ÄÜʹÓã¬Ôò
¡¡¡¡SQL>create public synonym plan_table for plan_table;
¡¡¡¡SQL> grant all on plan_table to public;
¡¡¡¡Èç¹ûÏëÈÃ×Ô¶¯¸ú×ٵĽÇÉ«ÈÃÿ¸öÓû§¶¼ÄÜʹÓã¬Ôò
¡¡¡¡SQL> grant plustrace to public;
¡¡¡¡Í¨¹ýÈçÏÂÓï¾ä¿ªÆô/Í£Ö¹¸ú×Ù
¡¡¡¡SET AUTOTRACE ON |OFF | ON EXPLAIN | ON STATISTICS | TRACEONLY | TRACEONLY EXPLAIN
3.ÈçºÎ¸ú×Ù×Ô¼ºµÄ»á»°»òÕßÊDZðÈ˵ĻỰ
¡¡¡¡¸ú×Ù×Ô¼ºµÄ»á»°ºÜ¼òµ¥
¡¡¡¡Alter session set sql_trace true|false
¡¡¡¡Or
¡¡¡¡Exec dbms_session.set_sql_trace(TRUE);
¡¡¡¡Èç¹û¸ú×Ù±ðÈ˵ĻỰ£¬ÐèÒªµ÷ÓÃÒ»¸ö°ü
¡¡¡¡exec dbms_system.set_sql_trace_in_session(sid,serial#,true|false)
¡¡¡¡¸ú×ÙµÄÐÅÏ¢ÔÚuser_dump_dest Ŀ¼Ï¿ÉÒÔÕÒµ½»òͨ¹ýÈçϽű¾»ñµÃÎļþÃû³Æ£¨ÊÊÓÃÓÚWin»·¾³£¬Èç¹ûÊÇunixÐèÒª×öÒ»¶¨Ð޸ģ©
¡¡¡¡SELECT p1.value||'\'
Ïà¹ØÎĵµ£º
ÔĶÁoracleÎĵµµÄb10743£¬¡¶conceps¡·¡£Õâ±¾±»oracle¹«Ë¾µÄ´óʦ¼¶µÄÈËÎïMichele CyranµÈÅ£ÈËËùд£¬ÕæÊÇÒ»±¾²»´íµÄÊé¼®¡£¿É̾ӢÎIJ»Ì«ºÃ£¬µ«Å¬Á¦£¬×Ü»áÓÐÊÕ»ñµÄ¡£»¹ÊÇ´ÓËûµÄÊý¾Ý¼Ü¹¹À´Ëµ°É£¡
£¨Ò»£©Data blocks £¬Extents£¬Segment
Õâ¾ÍÊÇËûÃÇÖ®¼äµÄÂß¼½á¹¹¡£
ÏÈ¿´Data blo ......
1.ʹÓòúÆ·£ºarcsde 9.3+oracle 10.2.0.1
2.ÎÊÌâÃèÊö£ºÓÃarcmap·ÃÎÊ¿Õ¼äÊý¾Ý£¬²Ù×÷¼¸·ÖÖÓ£¬arcmapÎÞ·´Ó¦£¬Êý¾Ý¿â·þÎñÆ÷¶ËcpuÕ¼ÓÐÂÊ100%£¬gsrvr.exe½ø³ÌÊý10+¡£
3.½â¾ö°ì·¨£ºÉý¼¶oracle°æ±¾´Ó10.2.0.1Éý¼¶µ½10.2.0.3»òÕß.2.0.4¡£
4.ÔÒò£º¾Ýesri¹¤³ÌʦËù³Æ£¬oracle10.2.0.1°æ±¾´æÔÚÓëarcgis²»¼æÈݵÄÎÞ·¨µ÷½ÚµÄbug¡£Ä¿Ç°Éý ......
Óï·¨£º
select *
from ±íÃû
where Ìõ¼þ1
start with Ìõ¼þ2
connect by prior µ±Ç°±í×Ö¶Î=¼¶Áª±í×Ö¶Î
start withÓëconnect by priorÓï¾äÍê³ÉµÝ¹é¼Ç¼£¬ÐγÉÒ»¿ÃÊ÷Ðνṹ£¬Í¨³£¿ÉÒÔÔÚ¾ßÓвã´Î½á¹¹µÄ±íÖÐʹÓá£
start with±íʾ¿ªÊ¼µÄ¼Ç¼
connect by prior Ö¸¶¨Ó뵱ǰ¼Ç¼¹ØÁªÊ±µÄ×ֶιØϵ
´úÂ룺
--´´½¨²¿Ãű ......
ORACLEѧϰÖгöÏÖµÄÎÊÌ⣨³ÖÐø¸üÐÂÖУ©
1¡¢ ORA:12545 ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ£¬Á¬½Óʧ°Ü
ÍøÉϲο¼µÄ½â¾ö°ì·¨
1.ËÑË÷ÄãµÄoracle°²×°Ä¿Â¼£¬ÕÒµ½ÕâÁ©¸öÎļþ tnsnames.ora ºÍ listener.ora ¼Çס¾Í¸ÄÕâÁ©¸öÎļþ¾ÍÐÐÁË£¬»¹ÓÐÒ»¸ö´óдµÄTNSNAMES.ORA²»ÓùÜËü¡£ËûÃǵÄ·¾¶ÈçÏ£ºÈç E:\oracle\ora92\n ......
½ñÌì°²×°Èí¼þÒ»Ö±ÔÚ²âÊÔÁ´½Ó²»ÄÜͨ¹ý£¬³öÏÖORA-12154: TNS: could not resolve service name£¬ºóÀ´²Å·¢ÏÖÊÇtnsnames.oraÖÐÓÐÎó¡£²éÕÒÍøÉϵÄ×ÊÁÏ£¬¼Ç¼ÏÂÀ´¡£
ÒªÅųý¿Í»§¶ËÓë·þÎñÆ÷¶ËµÄÁ¬½ÓÎÊÌ⣬Ê×Ïȼì²é¿Í»§¶ËÅäÖÃÊÇ·ñÕýÈ·(¿Í»§¶ËÅäÖñØÐëÓëÊý¾Ý¿â·þÎñÆ÷¶Ë¼àÌýÅäÖÃÒ»ÖÂ)£¬ÔÙ¸ù¾Ý´íÎóÌáʾ½â¾ö¡£ÏÂÃæÁгö¼¸ÖÖ³£¼ûµÄÁ¬½ÓÎÊÌâ ......