Home » RDBMS Server » Performance Tuning » PLSQL and related cursors generated in v$sql (10gr2)
PLSQL and related cursors generated in v$sql [message #540836] Thu, 26 January 2012 02:35 Go to next message
nikko
Messages: 8
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
Re: PLSQL and related cursors generated in v$sql [message #540840 is a reply to message #540836] Thu, 26 January 2012 03:01 Go to previous message
Michel Cadot
Messages: 59749
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Thus, i would like to know how to find that the cursor 71pj8t5nz1d80 is called/linked
by the cursor 2s567zb6684sh.


No way.

Regards
Michel
Previous Topic: Can anyone help to do some tuning on ORACLE 9i?
Next Topic: Tune Query or Modify Index or Partition
Goto Forum:
  


Current Time: Sun Nov 23 07:35:59 CST 2014

Total time taken to generate the page: 0.08730 seconds