How much space is Oracle data occupying?
- Article Type: Q&A
- Product: Aleph
- Product Version: 21
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