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!

Sudden increase in Tablespace - Oracle 9.2.0.8

785789Jul 18 2010 — edited Aug 19 2010

The oracle tablespace increased suddenly but without loading the actual data. On 06/15, the tablespace has a free space on 1.5G, but all of a sudden, all 1.5G has been consumed and casued the batch job to abend due to lack of space in the tablespace. The tablepace was increased by 2.5G and the batch job ws successfully completed. Till now ( after 1 month) there was no decrease in the free space of the tablespace (still 2.5G) and there was a increase in the size of the tablespace.

Please could you help in sudden consumption of the free space by the tabllespace. here are the tablespace storage details.

BLOCK_SIZE 8192,
INITIAL_EXTENT 6553600,
NEXT_EXTENT 6553600,
MIN_EXTENTS 1,
MAX_EXTENTS 2147483645,
PCT_INCREASE 0,
MIN_EXTLEN 6553600,
STATUS ONLINE,
CONTENTS PERMANENT,
LOGGING LOGGING,
FORCE_LOGGING NO,
EXTENT_MANAGEMENT LOCAL,
ALLOCATION_TYPE UNIFORM,
SEGMENT_SPACE_MANAGEMENT AUTO,
DEF_TAB_COMPRESSION DISABLED

Thanks,
Mahesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2010

Added on Jul 18 2010

#general-database-discussions

7 comments

1,515 views