Re: Free disk space on Oracle volumes ?

Jarek Palka <jpalka_at_interia.KILLSPAM.pl> wrote in message news:<3D3EA969.9090702_at_interia.KILLSPAM.pl>...
> Użytkownik Jarek Palka napisał:
> > Is it possible to determine how much space left on volumes where Oracle
> > data_files reside ?
> > Is there a PL/SQL package/procedure which returns amount of free server
> > disk
> > space (or server disk usage ) ?
> > I'd like know free disk space, NOT FREE tablespace size.
> >
>
> Of course I know how to check free space on OS level (Win,unix,Netware).
> I'd like to develop OS platform independent and Oracle version independent
> PL/SQL STORED PROCEDURE working in JOB and checking amount of free space left on
> server disks.

How about this? It's going to be inefficient even though the file is sparse:

for i in 10 .. 100000 loop
 execute immediate 'create temporary tablespace aa tempfile '/theFS/aa.dbf' size ' || i || 'm;';

• drop aa if no exception, otherwise report the free space left as the number used end loop;

Even on Windows, sparse files are supported (for NT, SP4 I believe has to be applied; no problem for Windows2000).

Yong Huang Received on Wed Jul 24 2002 - 17:28:14 CDT