Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question on extents.

448778Sep 3 2009 — edited Sep 3 2009

This is the tablesapce defination I got for my tablespace usng DBMS_METADATA

CREATE TABLESPACE "ABC_DEFAULT" DATAFILE
'/aspdev/db62ora1/oradata/ICDEV/ABC_default.dbf' SIZE 209715200
AUTOEXTEND ON NEXT 131072 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO

1) How many extents will be created while creating a tablespace.
2) How many extents will be created while creating first table.
3) when the file gets extended how many extents will be created.

I am trying to find the used space in the tablespace and although I am inserting data in lots of table still the usage of the tablespace is not increasing. and also the total bytes in the user_extents is not increasing.

This post has been answered by EdStevens on Sep 3 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2009

Added on Sep 3 2009

#general-database-discussions

14 comments

826 views