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.

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!
burleson
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.
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.