Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> sorting and temporary tablespace used history info
Hi,
Is there any v$ view to find out sorting history, not an active sort
information...?
For e.g.
In the morning, you see your temporary tablespace has been eaten up.
you want to find out which SQL_ID performed sort operation (assume
sort in this case) have eaten up your temporary tablespace during the
night.
You can query v$sort_usage, or v$tempseg_usage, those views won't give
you the sort history information, but only gives you current running
query sorting information.
Shed any light? Thanks for your info... Received on Fri May 04 2007 - 20:13:05 CDT
![]() |
![]() |