Re: can anyone help me tune the database

From: EdStevens <quetico_man_at_yahoo.com>
Date: 13 Sep 2006 05:52:35 -0700
Message-ID: <1158151955.110135.258060@m73g2000cwd.googlegroups.com>

trameshkumar_at_gmail.com wrote:
> All my tablespaces are locally managed (default in 9i if i am right)
>
> SQL> select tablespace_name, status, contents
> 2 from dba_tablespaces
> 3 where extent_management= 'LOCAL';
>
> TABLESPACE_NAME STATUS CONTENTS
> ------------------------------ --------- ---------
> SYSTEM ONLINE PERMANENT
> UNDOTBS1 ONLINE UNDO
> TEMP ONLINE TEMPORARY
> INDX ONLINE PERMANENT
> TOOLS ONLINE PERMANENT
> USERS ONLINE PERMANENT
> OCTOPUS ONLINE PERMANENT
> IOAS ONLINE PERMANENT
>
>
> sort_area_size integer 524288
> pga_aggregate_target big integer 39845888
>

<snip>

If you were thinking that this demonstrates that the TS are locally managed, then you missed the boat. Try

select tablespace_name, EXTENT_MANAGEMENT from dba_tablespaces; Received on Wed Sep 13 2006 - 07:52:35 CDT