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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
