Re: Which tables are hot?

1. Try something involving v$access, which is used by sqldba table monitor
2. Attach a trigger to your tables that adds up in a counter whenever it is accessed

Remember the best move is to spread the most used tables among your devices, not take them all to another disk (unless it is a fast and/or raid one)

Bruno.

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 Sun Feb 16 1997 - 00:00:00 CST