Session 2: --查到具体session信息后,开始进行跟踪。 SYS@orcl150> exec dbms_system.set_sql_trace_in_session(5,19,true); PL/SQL procedure successfully completed. Session 1: 在session 1中进行一些操作. SQL> select xstatus,id,xid,xtype 2 from test1 3 where xid=2 4 and xstatus>0; XSTATUS...
EXEC sys.DBMS_SHARED_POOL.purge('000000010182AE70,1862304678', 'C'); We might try to identify a specific cursor with a query like the following. SELECT sql_id, address, hash_value, sql_text FROM v$sqlarea WHERE sql_text LIKE 'SELECT empno FROM emp WHERE job%'; We can then feed theA...