Re: Performance Monitoring

From: astalavista <nobody_at_nowhere.com>
Date: Wed, 26 Sep 2007 21:18:01 +0200
Message-ID: <46fab053$0$32719$426a74cc@news.free.fr>

"Stefan Wetter" <swetter_at_arcor.de> a écrit dans le message de news: 46fa1a86$0$4518$9b4e6d93_at_newsspool3.arcor-online.net...
> Hello NG!
>
> I'm pretty new to this theme. My task is, at the moment, to improve the
> performance of a database of one of our customers.
>
> I monitored the database-activity with the help of some tools and find
> pretty much DISK-IO (read). I think that should be lower. To the same
> time, the buffers are only filled half.
>
> I think i should find out, wich tables cause the physical reads (, to
> examine which process does need them to optimize the clients if necessary.
> If not, i would change the storage clauses of that tables to use another
> part of the buffers.)
>
> So, my question at this time is: how can i find out which tables (or maybe
> indexes) cause the disk-io?
>
>
> Thank you very much in advance!
> Stefan

see V$SEGMENT_STATISTICS Received on Wed Sep 26 2007 - 14:18:01 CDT