Re: Temporary segments question

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 20 May 2001 23:09:19 +1000
Message-ID: <3b07c20f$1@news.iprimus.com.au>

Yes, it's called dba_tablespaces and you're looking for something called a temporary tablespace.

You, as a DBA, do not have anything to do with temporary segments, apart from allocating a sufficiency of space for them. By creating a temporary tablespace, you do that. It should be, as nigh as dammit, 99%+ full at all times.

Temporary segments are simply what happens when a sort can't take place fully in memory, and the PGA gets swapped to disk. It's the tablespace that does it.

HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"Bob" <no-one_at_localhost.com> wrote in message
news:3B04844E.A7894D73_at_localhost.com...


> Simple question, I think.  I'm sure there must be a dba_ view to let me

> see how much storage is allocated to temporary segments, but I can't

> find it.  Can someone help?

>

> Thanks,

>

> Frank

>

Received on Sun May 20 2001 - 08:09:19 CDT