Re: direct path read/write temp waits

From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
To: "genegurevich@xxxxxxxxxxxxxxxxxxxxx" <genegurevich@xxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 27 Apr 2007 09:32:26 +1100

It's all in the v$tempseg_usage (=v$sort_usage),

I thought you was probably looking for select * from v$tempseg_usage
where segtype='SORT'...

On 4/27/07, genegurevich@xxxxxxxxxxxxxxxxxxxxx
<genegurevich@xxxxxxxxxxxxxxxxxxxxx> wrote:

Alex,

How do I do that? I couldn't see any v$ table that has information about
has segments

thank you

Gene Gurevich


--
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: direct path read/write temp waits
From: genegurevich

References:
- Re: direct path read/write temp waits
  - From: Alexander Fatkulin

Other related posts:

Browse oracle-l