Hi Kunwar,
"SQL ordered by Version Count" shows how many child cursors per statements
(for those that have more than 20)
Regards,
Franck.
On Fri, May 3, 2019 at 3:54 PM kunwar singh <krishsingh.111@xxxxxxxxx>
wrote:
Hi Listers,
I have an academic sort of question.
Many a times i get a request to review the AWR report and i dont have yet
got the connection to the DB.
So is there a way i can calculate the number of rows in v$sql from any of
the data points in the AWR .
The purpose is to just check how many child cursors exist in the database.
Even if you could provide a rough math , that would be helpful.
I was thinking of "Library Cache Activity" and "Memory Statistics" , but
i will have to run few tests in order to understand how those change w.r.t
to increase/decrease in v$sql count.
I plan to do that, but thought of checking if someone already has a answer
to it ;)
--
Cheers,
Kunwar