"Liggs" <liggs_at_hotmail.com> wrote in message
news:ag1g24$r1a$1_at_knossos.btinternet.com...
> This has nothing to do with autoextend, I think you misunderstood the
> problem.
> Anyway they are set aside for just oracle datafiles. The point is that
> 'df .' ignores the sparse files 'reported' size and goes on 'real' size
> (i.e. much smaller),
> and hence gives you a false impression of the real amount of 'free' disk
> space in a filesystem.
> Hence the amount of real disk space Oracle requires when it uses the TEMP
> datafile grows by
> someone just running a query, with NO autoextend etc. enabled.
> If you see 1Gb free in a filesystem, you assume you can use all of that.
> Otherwise it becomes a manageability problem.
> Alun
My point is that autoexend gives you the same problem. You see in the file
system that you have 1gb free and so you can use it. your dba can see in
oracle that the datafile can grow by another 500mb before it hits its size
limit so the sysadmin and the dba both assume that that space is free for
their use. Oracle can tell you the size of the files so I don't really see
the problem.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Jul 04 2002 - 09:27:24 CDT
