Re: Is there a way to get the count of v$sql from a AWR report (output of awrrpt.sql or awrrpti.sql)

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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l