Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Which tables are hot?
Not by tables that I know of. You can id which datafile and equate that to tablespace and then (roughly) to tables however. There are two things you can look at...Look at the sqldba monitor utility
sqldba
>mon files
for activity/s.
You can also do the following in version 7
select name, physrds,physwrts
from v$datafile a,V$filestat b where a.file# = b.file# ;
for total activity to date.
Bill Wine <biwine_at_vassar.edu> wrote in article
<5dd6tv$16s_at_vassun.vassar.edu>...
> I have a tablespace with hundreds of tables in it. I would like to
> move the most heavily accessed tables to new tablespaces on another
> disk.
>
> Is there a way to measure which tables are hot?
>
> Thanks for your advice.
>
> Bill
>
>
Received on Sat Feb 08 1997 - 00:00:00 CST