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!

Hi,

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

READ: http://www.dba-oracle.com/t_alter_table_in...s_unlimited.htm

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

READ: http://www.dba-oracle.com/t_alter_autoextend_on.htm

Then you must only watch the OS data dicectory space.