RE: NEXT_EXTENT and PCT_INCREASE

Initial_extent and next_extent in DBA_TABLES show what you requested. Initial_extent and next_extent in DBA_EXTENTS show what Oracle actually allocated. You have an LMT with an 8M uniform extent. When you request 170M initial extent, that request is recorded in dba_tables and then Oracle will allocate 22 extents of 8M each to satisfy the 170M initial request and record that in dba_extents. That's the smallest to be equal or greater than the requested 170M.

At 03:44 PM 8/26/2003 -0800, you wrote:

>Why the table was created with initial extent as 1700M,
>but dba_extents says the first extent is 8M only?
>
>SQL> select initial_extent from dba_tables where table_name='BSIS';
> 1782579200
>
>SQL> select bytes from dba_extents where segment_name='BSIS' and extent_id=1;
> 8388608
>
>SQL> select bytes,count(*) from dba_extents where segment_name='BSIS'
>group by bytes;
> 8388608 113
> 67108864 137
>
>-----Original Message-----
>Sent: Tuesday, August 26, 2003 3:14 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Roger,
>
>1. Space management can be specified for a tablespace, not a segment. Create
>ASSM tablespace and alter table ... move there.
>
>2. Locally managed tablespace, I guess. Oracle doesn't need NEXT_EXTENT and
>PCT_INCREASE then.
>
>HTH
>Vadim
>
>-----Original Message-----
>Sent: Tuesday, August 26, 2003 3:59 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>
>I have the following output when I querying dba_tables.
>
>Question 1: This table is created using manual management method, right?
> What do I do in order to turn it to Automatic segment-space
>management?
>
>Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE?
>
>Thanks,
>
>Roger Xu
>
>
> PCT_FREE PCT_USED INI_TRANS MAX_TRANS
>---------- ---------- ---------- ----------
> 10 40 1 255
>
>INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
>-------------- ----------- ----------- ----------- ------------
> 527491072 1 2147483645
>
> FREELISTS FREELIST_GROUPS
>---------- ---------------
> 1 1
>
>LOGGING BACKED_UP NUM_ROWS
>------- --------- ----------
>YES N 216122635
>
> BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT
>---------- ------------ ---------- ----------
> 7651115 4307 319 0
>
>
>AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS
>----------- ------------------------- -------------------
> 254 4496 2
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Roger Xu
> INET: roger_xu_at_dp7uptx.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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.net
>--
>Author: Gorbounov,Vadim
> INET: vadim.gorbounov_at_liberate.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).
>
>For technical support please email tech_support_at_dp7uptx.com or you can
>call (972)721-8257.
>This email has been scanned for all viruses by the MessageLabs Email
>Security System.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Roger Xu
> INET: roger_xu_at_dp7uptx.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).