Is there a way to get the count of v$sql from a AWR report (output of awrrpt.sql or awrrpti.sql)
From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Fri, 3 May 2019 09:53:35 -0400
Message-ID: <CAJSrDUrER28=hMKa4n1xYqnBgHNUzm40MVn_mTb_yTuVCzqvvA_at_mail.gmail.com>
Hi Listers,
I have an academic sort of question.
Date: Fri, 3 May 2019 09:53:35 -0400
Message-ID: <CAJSrDUrER28=hMKa4n1xYqnBgHNUzm40MVn_mTb_yTuVCzqvvA_at_mail.gmail.com>
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
Received on Fri May 03 2019 - 15:53:35 CEST