Re: Use of TEMP tablespace other than sorting

"Anurag Varma" <avdbi_at_hotmail.com> wrote:

>Rick,
>
>What do the following queries say:
>
>select tablespace_name, contents, extent_management, initial_extent, allocation_type
>from dba_tablespaces where tablespace_name = '<yourtablespacenamehere>';

From my head: TEMP, locally managed, 4 MB, uniform

>and
>
>select name, value from v$parameter where name in ('sort_area_size', 'hash_area_size');

That I will have to query tomorrow at office.

>hash operations also use temp tablespace. However, I have seen this happen primarily in places where
>the so called temporary tablespace is defined with contents "permanent" i.e. not exactly a temporary tablespace.
>Happens when hash_area_size is much bigger than the uniform extent size of the temp tablespace.

TEMP is temporary, not permanent. Your hint with hash_area_size means that I would need to diminish its value, right?

Thanks

Rick Denoire Received on Thu Feb 27 2003 - 17:48:04 CST