Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Free disk space on Oracle volumes ?
a tempfile does not take up any space, at least on UNIX
consequently, you can create as many tempfiles as you like
consequently, this method is not going to work
to accomplish what you want, you'd have to create datafiles which seems a lilttle bit too expensive
maybe there is some other way?
Regs
AK
Yong Huang wrote:
> 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 Thu Jul 25 2002 - 21:48:50 CDT