Should my extents be bigger?

From: Jacques Raymond Kilchoer <jrkilch_at_costcare.com>
Date: 1996/09/19
Message-ID: <3241BB3C.5DA3_at_costcare.com>#1/1

Oracle7 Server Release 7.1.3.2.0 - Production Release VAX OpenVMS V6.1-1H2

I have a tablespace called TEMP with an initial_extent = 256,000
                                     a  next_extent    = 1,048,576
                                     a  min_extents    = 2
                                     a  max_extents    = 121

(see below)

The data file for the TEMP table has 524,288,000 bytes
(see below)

It seems to me that since tablespace TEMP has a max_extents of 121, it can use up
at most 1 * 256,000 (initial_extent) + 120 * 1,048,576 (next_extent)

• 256,000 + 125,829,120 = 126,085,120

Since 126,085,120 is less than 524,288,000 I would think that the datafile for the
tablespace never gets used to its full capacity.

Is my understanding correct?
If so, what should I do? Increate the next_extent size or the max_extents?

---

tablespace and datafile information
SQL> select * from dba_tablespaces where tablespace_name = 'TEMP' ;

TABLESPACE_NAME                INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ -------------- ----------- -----------

MAX_EXTENTS PCT_INCREASE STATUS
----------- ------------ ---------

TEMP                                   256000     1048576           2
        121            0 ONLINE

SQL> select * from dba_data_files where tablespace_name = 'TEMP' ;

FILE_NAME

---

   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS
---------- ------------------------------ ---------- ----------

---

ORA$DISK3:[MISDEV]TEMP_01.DBF

         3 TEMP                            524288000     256000

AVAILABLE

-- 
 ___                                                                  
___


(___)=================================================================(___)


|   | Jacques Raymond Kilchoer               MIS:Applications Support
|   |
|   | Technical Specialist           /^\  ^      (714) 729-4500 x3733
|   |
|   | Cost Care, Inc.          /\  _/   \/ \             fax 729-4651
|   |
|   | Newport Beach, CA  /\ /\/  \//     \  \_/\                     
|   |
|   |                   /  \ /    /       \ /   \             Schweiz
|   |
|___| Suisse       ____/____\____/_________\___ _\_______    Svizzera
|___|


(___)=================================================================(___)

Received on Thu Sep 19 1996 - 00:00:00 CEST