Find list of SQL IDs for the queries executed in a stored procedure
Hi,
I am not sure if this question should goto SQL or PLSQL. Here it is:
Is there any way to find out the SQL IDs of the SQL queries executed in a stored procedure?
I am aware that the individual query's SQL IDs can be found in the v$sqlarea. But, here I just want to the use the stored procedure name to find out the SQL IDs of queries inside it.
Thanks.
I am not sure if this question should goto SQL or PLSQL. Here it is:
Is there any way to find out the SQL IDs of the SQL queries executed in a stored procedure?
I am aware that the individual query's SQL IDs can be found in the v$sqlarea. But, here I just want to the use the stored procedure name to find out the SQL IDs of queries inside it.
Thanks.
0