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||'\'
Ïà¹ØÎĵµ£º
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄÇ ......
ÎÊÌâÃèÊö
=======
ÔÚÊÔͼÆô¶¯Êý¾Ý¿âµÄʱºò,Oracle±¨¸æÏÂÁдíÎó£º
ERROR:
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
»ù±¾½âÊÍ
=======
Error: ORA-27101
Text: shared memory realm does not exist
-------------------------------------------
Ca ......
============================Question================================
SQL> select * from emp;
EMPID EMPNAME SALARY DEPTID
---------- ----------- ......
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊÇ
±íÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ¢²åÈë¡£Ò»µ©Ò»ÐÐÊý¾Ý²åÈëÊý¾Ý¿â£¬Ôò
rowidÔÚ¸ÃÐ ......