Re: Measuring I/O at the session level
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 6 Sep 2000 23:40:04 +0200
Message-ID: <968276683.20896.5.pluto.d4ee154e_at_news.demon.nl>
Date: Wed, 6 Sep 2000 23:40:04 +0200
Message-ID: <968276683.20896.5.pluto.d4ee154e_at_news.demon.nl>
select * from v$sess_io
Hth,
Sybrand Bakker, Oracle DBA
"Gerard Demers" <gdemers_at_bigyellow.com> wrote in message
news:8p651b$7r9$1_at_nnrp1.deja.com...
> How can you determine the Oracle session causing heavy I/O to a
> particular data base file? If this is not possible, how do you
> determine aggregate I/O activity associated with a particular Oracle
> session? We can find information about total activity to individual
> data base files but not what session is causing it.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 06 2000 - 23:40:04 CEST