Re: Which tables are hot?

From: Mark Rosenbaum <mjr_at_netcom.com>
Date: 1997/02/21
Message-ID: <mjrE5yIpB.87r@netcom.com>#1/1

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?

Unless you are on a server where you are only running one instance of the Data Base (no other programs or Data Bases) you might want to first look at the system level performance. Otherwise you might miss multiprocessing interactions. For most UI*Xes try sar -d

mjr Received on Fri Feb 21 1997 - 00:00:00 CST