Thanks for reply, we are running 10G on Linux. I never used ADDM ansd
AWR before. Will look at manual but if you have some good brief handson
notes on how-to use them quickly please share. I will appreciate a
lot. Thanks again
On Feb 7, 10:43 am, "MTNorman" <mtnor..._at_duke-energy.com> wrote:
> On Feb 7, 12:18 pm, soalvajav..._at_yahoo.com wrote:
>
> > Do you know of any sql script which help me to find out:
>
> > What are the most hitted tables and most qyery sql run by a vendor
> > application? ( we have an out of box ERP kind of application here )
>
> > And what are the most important and perhaps missing indexes in the
> > Application Oracle Schema?
>
> > Thanks for help
> > Frank
>
> What database version? StatsPack prior to 10g, ADDM and/or AWR
> reports in 10g (both of these require licensing). These sort your
> queries by most often run, longest running, returning the most number
> of rows, performing the most IO, etc. They even tell you that table
> ABC had 654,321 full table scans in the last 24 hours. Otherwise you
> need to query the data dictionary tables - again which data dictionary
> tables is version dependent.
Received on Wed Feb 07 2007 - 17:47:56 CST
