Re: Table I/O

From: Jurij Modic <jmodic_at_src.si>
Date: Sun, 24 Oct 1999 20:54:08 GMT
Message-ID: <3814710d.13565804_at_news.siol.net>

On Sun, 24 Oct 1999 20:04:51 GMT, rstrouss_at_earthlink.net wrote:

>I once saw a script that figures out the I/O activity on a Table. I
>know they have a script to see file i/o, but I think table i/o would
>be even more useful.

Check the script catio.sql in your distribution's admin directory - it allows you to find out the distribution of I/Os between your tables.

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 Sun Oct 24 1999 - 22:54:08 CEST