Re: profile an application's block i/o at table and index level

According to Oracle Support,
"There is no such functionality to measure I/O against table or index."

However, there is the ability to measure blocks read/written, as well as the read/write times to datafiles.

The solution is to place each table to be measured into its own data tablespace, and the corresponding indexes for each table in their own index tablespace. The result is that each table to be measured has its own data and index tablespaces.

Utlbstat/estat can then be used to record the block i/o for each datafile.

In article <89ml6o$5be$1_at_nnrp1.deja.com>,   Allan Plesniarski <aplesnia_at_my-deja.com> wrote:
> Hi,
>
> we are looking to profile an application by block i/o at the table and
> index level. The goal is to be able to map tables and indexes to
> tablespaces (datafiles) spread across clients' controllers to evenly
> distribute i/o BEFORE any application database goes into production.
>
> Any suggestions would be appreciated.
> Allan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 10 2000 - 00:00:00 CST