How much space is Oracle data occupying?

Question

How can the space occupied by Oracle data on a server be calculated?

Answer

1. The simplest method is go to the oradata directory (usually "/exlibris/oradata/xxxxx" <where "xxxxx" is the database name>, but sometimes "/oradata" or "/exlibris1/oradata" or "/exlibris2/oradata", etc.) and do "du -sh".

2. Alternatively, one can do util o/13/1 ("List of Database Files") and total up the space occupied by each datafile.

Additional Information

* If this is a TWO_TASK installation (with the ORA_HOST parameter in aleph_start having a different value than the WWW_HOST parameter and with the Oracle data residing on a separate server), this inquiry needs to be performed on the database server.

* The ./oradata directory contains, in addition to the .dbf database files, the (relatively small) *.redo.log and *.ctl files, and the (often substantial) ./arch directory (Oracle archive logs).

Category: System Management (500)

Subject: Oracle (500)

• Article last edited: 10/8/2013