RE: temp tablespace blow up
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: Jay.Miller@xxxxxxxxxxxxxxxx, lyallbarbour@xxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 17 Aug 2007 08:26:16 +0800
Btw, the v$sort_usage & v$tempseg_usage have "lied" for me before (due bugs
or anomalies).
If you're just interested in how much free space there's available for you
then use v$temp_extent_pool...
Tanel.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jay.Miller@xxxxxxxxxxxxxxxx
Sent: Friday, August 17, 2007 06:56
To: lyallbarbour@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: temp tablespace blow up
Just because no one else mentioned it (that I noticed) I'll point out that
having a large number of extents in the temp tablespace is fine and no
reason to drop it. The temporary extents are reused whenever needed.
If you are ever concerned about current usage of the temp tablespace you can
look at v$sort_usage.
Other related posts:
