Re: Reads vs. Writes

laredotornado_at_zipmail.com (D. Alvarado) wrote in message news:<9fe1f2ad.0404191053.618421cf_at_posting.google.com>...
> Hello, For Oracle 8i, I want to get a sense for the number of reads
> being performed against all tables in a particular schema vs. the
> number of writes performed. What data dictionary tables are ideal for
> this purpose? Thanks, -

Well, if you have all tables in a particular datafile, you can use this (Metalink Note:1019629.6):

select name
df,

        phywrts
writes,

        phyrds
reads
from v$datafile a,

        v$filestat b
where a.file# = b.file#
order by 2 desc ,1 desc
/

jg

--
@home.com is bogus.
"If I go to jail I want you to be my roomate." - Gene Simmons