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.

Why is PLUS_IX_04 continuing to fill up and PLUS_IX_05 not being written to?

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

Many thanks!

Never allow a table/index to run oput of extents (use emaxextents unlimited).


Never allow a tablspace to not exent (autoextend on).


Then you must only watch the OS data dicectory 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-2017 Invision Power Services, Inc.