Help - Search - Members - Calendar
Full Version: Datafiles filling up
Oracle DBA Forums > Oracle > Oracle Forum
dchin
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!
burleson
Hi,

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

Yeah! Oracle will hang if a index cannot extend!

Read this carefully:

http://www.dba-oracle.com/topica/oracle_ca...ty_planning.htm

************************************************

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:

http://www.rampant-books.com/download_sizi...preadsheets.htm
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-2014 Invision Power Services, Inc.