Re: How to find hot tables in a DB?

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 27 Oct 1999 19:36:27 GMT
Message-ID: <381c539f.5209895_at_news.siol.net>


On Wed, 27 Oct 1999 11:14:36 GMT, (SightBlinder) wrote:

>Are there any tools/scripts to help determine what tables are getting
>hit the most within Oracle?

The script "catio.sql" in your $ORACLE_HOME/dbms/admin directory will help you get this information

>any help would be appreciated?
>Jim

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Oct 27 1999 - 21:36:27 CEST

Original text of this message