Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. How much space is Oracle data occupying?

    How much space is Oracle data occupying?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How much space does the z00p take?
      • How Not To Block in Tab_Block_Circ
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. contype:kba
      3. Oracle (500)
      4. Prod:Aleph
      5. System Management (500)
      6. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved