i/o waits by session?

From: Chuck <chuckh_at_softhome.net>
Date: Fri, 6 Sep 2002 09:46:37 -0400
Message-ID: <alabjt$1o7pbd$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----

Hash: SHA1

I know by querying V$SESSION_EVENT that a particular SID has experienced very high i/o waits (up to 2 minutes per i/o!). Is there a way to break down the i/o waits for that SID by file or filesystem? V$SESSION_WAIT will only show me the current waits at a given point in time. I need to see the i/o by file or filesystem for the entire session, or at least over a given period of time for that one session.

-----BEGIN PGP SIGNATURE-----

Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPXixulVYIIV9CtSHEQIXcACffINB1/pgKB0pPqBB8pMGnMmuyKsAoI1h /5e6zPX0nuzkl1OhFugdtuh3
=ESjW
-----END PGP SIGNATURE-----
Received on Fri Sep 06 2002 - 08:46:37 CDT