Re: direct path read/write temp waits

From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 27 Apr 2007 11:53:10 -0500

So far I am only seeing the SORT segments. I'll keep checking while the
process is running

thank you

Gene Gurevich



                                                                           
             "Alexander                                                    
             Fatkulin"                                                     
             <afatkulin@gmail.                                          To 
             com>                      "genegurevich@xxxxxxxxxxxxxxxxxxxxx 
             Sent by:                  "                                   
             oracle-l-bounce@f         <genegurevich@xxxxxxxxxxxxxxxxxxxxx 
             reelists.org              >                                   
                                                                        cc 
                                       oracle-l@xxxxxxxxxxxxx              
             04/26/2007 05:32                                      Subject 
             PM                        Re: direct path read/write temp     
                                       waits                               
                                                                           
             Please respond to                                             
             afatkulin@xxxxxxx                                             
                    om                                                     
                                                                           
                                                                           




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






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

References:

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

Re: direct path read/write temp waits

Other related posts: