Re: Newbie - How can I check diskspace usage?

Earvin C. Lim wrote:
>
> Hi all,
>
> We have created a database in a UNIX file system, and about 400MB is
> allocated to it. But how can I check how many actual diskspace is in
> use?

  You can use SELECT * FROM DBA_FREE_SPACES to check the free space.   You can use V$DATAFILE to check the file size of each tablespace.

  Alternatively, in PL/SQL,

  You can use DBMS_SPACE.UNUSED_SPACE to check the free space.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841