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

From: Franck Pachot <>
Date: Sat, 4 May 2019 17:08:49 +0200
Message-ID: <>

Hi Kunwar,
"SQL ordered by Version Count" shows how many child cursors per statements (for those that have more than 20)

On Fri, May 3, 2019 at 3:54 PM kunwar singh <> 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

Received on Sat May 04 2019 - 17:08:49 CEST

Original text of this message