Bill Wine wrote:
>
> 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
The performance monitoring SQL command files utlbstat and utlestat can
identify hot tables and tablespaces. You'll find them in
$ORACLE_HOME/rdbms/admin.
--
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Thu Feb 06 1997 - 00:00:00 CST
