RE: TEMP Tablespace

Hi Charlie

Size of 16GB is a bit too big for a temporary tablespace. But anyway. Try creating equally sized extents for temp. To speed up the index creation set sort area size higher. Maybe create extents of size initial 40m next 40m. Make sure pctincrease is set to 0.
The Temporary tablespace is created as type TEMPORARY.

alter tablespace TEMP temporary;

Best Regards

Suhen Pather
Oracle DBA
Strandbags Australia
Land 02 9749 7791
email suhen.pather_at_strandbags.com.au

-----Original Message-----
From: Emine ATES [mailto:emineates_at_postmaster.co.uk] Sent: Thursday, November 30, 2000 9:09 AM To: Multiple recipients of list ORACLE-L Subject: Re: TEMP Tablespace

Really, I didn't work with such a big temp tablespace, but I recommend you creating it as a temporary tablespace because oracle behaves different for allocating sort extents at temporary tablespaces. Good luck.

On Wed, 29 Nov 2000 07:30:32 -0800 "Charlie Mengler" <charliem_at_mwh.com> wrote:
> Oracle V7.3.4.3 on Solaris V2.6
>
> The volume of data I'm required to support has just increased
significantly.
> I've been force to increase the size of TEMP to around 16GB to support
> index creation on a new LARGE table. TEMP is/was configured as -
>
>
> SQL> select * from dba_tablespaces where tablespace_name = 'TEMP';
>
> TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
MAX_EXTENTS PCT_INCREASE STATUS CONTENTS
> ------------------------------ -------------- ----------- -----------
----------- ------------ --------- ---------
> TEMP 1048576 2097152 1
505 1 ONLINE PERMANENT
>
> Now I'm getting errors involving hitting the 505 MAXEXTENT limit.
> I know I can increase this limit, but I suspect that the values
> INITIAL & NEXT should also be increased.
>
> What values do you have for TEMP where it is sized in the 10 - 40 GB
range.
>
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct
> 858-831-2229 San Diego, CA 92131
> You don't know what you don't know. Think about it.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Emine ATES
  INET: emineates_at_postmaster.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may