Re: i/o waits by session?

From: Chuck <chuckh_at_softhome.net>
Date: Tue, 10 Sep 2002 08:39:51 -0400
Message-ID: <alkp6o$1rfjro$1@ID-85580.news.dfncis.de>

"srivenu" <srivenu_at_hotmail.com> wrote in message news:1a68177.0209062258.1b74367d_at_posting.google.com...
> If you want to see the I/O for a particular application usage.
> Have only one session accessing the database, collect file I/O
> statistics using v$FILESTAT, run the application for some time and run
> V$FILESTAT to collect end statistics.
> The difference is the file I/O usage of your application file wise.
> regards
> Srivenu

Unfortunately I can't have the database all to myself. It is a 24x7 production database. Received on Tue Sep 10 2002 - 07:39:51 CDT