OraFAQ Forum: Performance Tuning » PLSQL and related cursors generated in v$sql

Home » RDBMS Server » Performance Tuning » PLSQL and related cursors generated in v$sql (10gr2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Thu, 26 January 2012 02:35

nikko
Messages: 9
Registered: September 2010

Junior Member

Hello

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
PROCEDURE PROCEDURE1 
AS 
BEGIN
 insert into t values(1,1);
END PROCEDURE1;

, the 2 following cursors are created in v$sql :

select SQL_ID, SQL_TEXT  from v$sql
where sql_id in ('71pj8t5nz1d80','2s567zb6684sh');

"SQL_ID"	"SQL_TEXT"
"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.
Regards
Nikko

Report message to a moderator