Query to extract Initial & Next Extents 
Author Message
 Query to extract Initial & Next Extents


This info can be found within the database (inside systables).

SELECT fextsize, nextsize
FROM systables
WHERE tabname = "your_table_name";

Your post says something about creation time. Just in case you were unaware
you can specify the creation size for extents within the CREATE TABLE



> I am currently writing queries for capacity planning and I need to be
> able to extract the initial and next extent values given to tables on
> creation.  My problem is I cannot find the relevant fields in the
> sysmaster database, but I know it is there somewhere as oncheck -pt
> displays them.

> Cheer

> Dave Samuels   DBA
> Siemens Microelectronics Ltd

Bill Ennis            Voice: 312-474-7516
SSA                   Fax:   312-474-7460

Wed, 18 Jun 1902 08:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Query to extract Initial & Next Extents

2. How do you determine initial and next extents ?

3. initial and next extents

4. Initial,Next Extents and Byte allocation confusion

5. Initial extent size < first extent

6. query on dba_rollback_segs shows different initial extent

7. next extent-, exist extent-question

8. Extents and next extent size

9. Extent/Next Extent

10. Extent/Next Extent

11. first extent and next extent

Powered by phpBB® Forum Software