Release Automation

Expand all | Collapse all

Installation on Oracle Database

Jump to Best Answer
  • 1.  Installation on Oracle Database

    Posted 03-02-2016 10:34 AM

    Hi guys!

      Do any of you can share information on data files (location and their average size) of an RA's database on Oracle?

     

    Plus, do you know if there's information on average growing of these files?

     

    Thank you so much!!!

    Patricio



  • 2.  Re: Installation on Oracle Database
    Best Answer

    Posted 03-16-2016 12:23 PM

    Hi Patricio,

     

    This is definitely a tough one to answer, as disk usage by enterprise database servers can vary heavily depending on the configuration.   Assuming a pretty standard configuration, in a base installation with little to no additional operations performed on the database, the size is going to be around roughly 450-500M in terms of the amount of space the nolio tablespace uses on disk, eg(5.x installation):

     

    -rw-r-----  1 oracle oinstall 501M Mar 16 12:10 nolio_tbs.dbf

     

    To answer your question about where the tablespace is typically located on disk, you will find them usually stored in(of course substitute the base path to your oracle install):

     

    /u01/app/oracle/product/11.2.0/db_1/dbs

     

    The file extension by default with 11g is .dbf, the only other tablespace nolio utilizes by default is a temporary tablespace which is of negligible size.

     

    Let me know if this helps and if you have any additional questions, thanks!

     

    Jeremy



  • 3.  Re: Installation on Oracle Database

    Posted 03-17-2016 05:38 PM

    Patricio,

     

    Do you have any further questions on this one?  If not, would you mind marking Jeremy's suggesting as the answer for your thread?