|PLSQL and related cursors generated in v$sql [message #540836]
||Thu, 26 January 2012 02:35
Registered: September 2010
I wanted to know how to find the links between cursors that have been created
in v$sql after compiling a PLSQL procedure.
For example, if i compile the following procedure :
create or replace
insert into t values(1,1);
, the 2 following cursors are created in v$sql :
select SQL_ID, SQL_TEXT from v$sql
where sql_id in ('71pj8t5nz1d80','2s567zb6684sh');
"2s567zb6684sh" "BEGIN PROCEDURE1; END;"
"71pj8t5nz1d80" "INSERT INTO T VALUES(1,1)"
Thus, i would like to know how to find that the cursor 71pj8t5nz1d80 is called/linked
by the cursor 2s567zb6684sh.
This would be help me for interpreting some sql statistics in v$sqlstats in where
such cursors appear and related sql statistics are accounted twice.
Thanks in advance.