Help - Search - Members - Calendar
Full Version: Datafiles filling up
Oracle DBA Forums > Oracle > Oracle Forum
I have a tablespace PLUS_IX with 5 datafiles PLUS_IX_01, etc.
PLUS_IX_04 is 85% full, up from 78% last month
PLUS_IX_05 is 22% full.
PLUS_IX_01 to _03 are 73% full.
Should I be concerned that PLUS_IX_04 is getting full? If so, what actions are recommended?

ALTER INDEX ..... REBUILD has been run on all the indices.

Many thanks!

>> Should I be concerned that PLUS_IX_04 is getting full?

Yeah! Oracle will hang if a index cannot extend!

Read this carefully:


Always define a tablespace objects with maxextents unlimited, and the data files autoextend on.

Then the only way you can lock-up is if you run out of room in the disk filesystem!

I use these capacity planning spreadsheets to ensure that I always have free space:
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.