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 - 11:43:13 CST
