Re: How to see what is in temporary tablespace

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Tue, 27 Aug 2002 21:19:26 +0200
Message-ID: <akgjd3$4fs$1@news1.xs4all.nl>

Query the views:

V$SORT_SEGMENT
V$SORT_USAGE For description see Oracle Reference, Chapter 3 - Dynamic Performance (V$) views.

Steve Mitchell <stevem_at_hdcsi.com> schreef in berichtnieuws tWMa9.6296$8W6.674206917_at_newssvr13.news.prodigy.com...
|
| Is there any way for me to see exactly what is in my temporary table space
| at any given time? I have problems with the temporary table space growing
| to be much larger than I think it should be. I don't know what's in there
| and want to find out.
|
| Any help would be greatly appreciated.
|
| --steve
|
|
|
Received on Tue Aug 27 2002 - 14:19:26 CDT