Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004

    Unanswered: Default Initialization Parameters

    Hi All

    I am trying to find out what the default initialization parameters are for an Oracle database instance. I have tried various sources metalink, www) but they do not detail all the parameters.

    Any info will be greatly appreciated.

  2. #2
    Join Date
    Jan 2004
    Check the Server Reference Manual.
    It give a description of all parameters and default values.

    If you don't have one,

  3. #3
    Join Date
    Apr 2003
    Greenville, SC (USA)
    Default init params will not usually be sufficient for a database.
    You will have to determine your needs (number of users, number, size
    and executions of constructs (procedures, etc...)). How many
    db_block_buffers are needed, etc ...

    To get a feel for the "defaults", go thru the create database wizard
    and create database and "save to file" ... this will create scripts
    that you can run later, BUT it will create an initxxx.ora file that you
    can look at....

    OR if you have an existing database, look at the database parameters
    and look for "DEFAULT" to see what it currently running as default parameters.


  4. #4
    Join Date
    Jul 2003
    $ORACLE_HOME/dbs has a sample init.ora file with the so-called defaults listed for various sized databases.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts