Re: Use of TEMP tablespace other than sorting

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Sat, 01 Mar 2003 03:00:47 +0100
Message-ID: <1k006v8a677drnh7l4igr9gua5sqjdgemo@4ax.com>

Take a look at this:

SQL> @nr_rows.sql

TABLE_NAME                       NUM_ROWS LAST_ANA
------------------------------ ---------- --------
T_GC_PEAK_QUANT                  11944095 12.01.03
T_MS_MATCH                       65717610 12.01.03
T_GC_SAMPLE                        148005 12.01.03

SQL> spool query.txt
SQL> select
tablespace_name,contents,extent_management,initial_extent,allocation_type from dba_tablespaces where tablespace_name='TEMP';

TABLESPACE_NAME                CONTENTS  EXTENT_MAN INITIAL_EXTENT

ALLOCATIO

------------------------------ --------- ---------- --------------
---------    
TEMP                           TEMPORARY LOCAL             4194304
UNIFORM      

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

NAME

---

VALUE

---

sort_area_size
4194304

hash_area_size
8388608 Received on Fri Feb 28 2003 - 20:00:47 CST