Re: Autoextend - where in the data dictionary ?

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 26 Jan 2001 12:09:50 GMT
Message-ID: <94rpee$sgl$1@news.liv.ac.uk>

,Neil Cudd <neil_at_cudd.demon.co.uk> wrote:
: I have a weird problem :

: Oracle 7.3.4.4 on AIX 4.3.3

: out of the blue I started to get a load of ORA 376's (file offline). Checked
: the files and they had a status of recover. Checked Alert Log and there were
: a load of os level errors saying no space left on device. Checked filesystem
: and it's 100% full.

: Now I was able to get round this but I have checked (via enterprise manager)
: and the files are NOT aoutextend (I never like auto extend anyway). I'd like
: to check this in the data dictionary, but can't find the relevant view. It
: does seem like the file system space is being 'nibbled' away over time and
: I'm racking my brain trying think how !!

: Any suggestions greatly appreciated,
: Neil C.

SYS table filext$

FILE# File no refs to dba_data_files MAXEXTEND Max size file can be (in blocks) INC Extend increment size (in blocks)

HTH Helen Received on Fri Jan 26 2001 - 06:09:50 CST