how long to create a db?

[Thargy]

I've just run a dbca-produced creation script. It was generated as a 'new database' without all the optional extras and I then invoked the batch file.

To my amazement, this took over 30 minutes to complete. Seeing as how the dbca can do the job in 5 minutes, I was surprised. Is this normal?

Can anyone tell me what a typical creation time is for a standard database?

Regards

Tharg

Grinding away at things Oracular

 

[slaing]

Which DBCA options are you using when you get it to complete in 5 mins ?

30 mins is the sort of figure I get from DBCA on an average spec 'in-use' Dell server, choosing 'New database' and then defining char set, tablespaces, locations etc myself.

If you're choosing any of the Data Warehouse / General Purpose / Transaction Processing options then DBCA will cheat and just 'unzip' a pre-prepared database for you from the .dfj files in $oracle_home\assistants\dbca\templates

Steve

 

[Thargy]

slaing,

thanks for the clarification, I thought it was being done with smoke and mirrors! I can readily believe unpacking "one I made earlier" is quicker than doing it the hard way.

I am relieved to hear that my average spec "in use" dell server is delivering at the normal pace.

Regards

Tharg

Grinding away at things Oracular

 

[SantaMufasa]

John (ThargTheSlayer),

The actual "CREATE DATABASE..." command takes only a few seconds. The bulk of "the rest of the 30 minutes" results from running the scripts that create the Oracle database data dictionary infrastructure. The "scripts" to which I refer that I run are:

(connected as a SYSDBA)$ORACLE_HOME\rdbms\admin\catalog
$ORACLE_HOME\rdbms\admin\catproc
$ORACLE_HOME\rdbms\admin\catblock
$ORACLE_HOME\rdbms\admin\catexp
$ORACLE_HOME\rdbms\admin\utlxplan
$ORACLE_HOME\rdbms\admin\utltkprf
$ORACLE_HOME\sqlplus\admin\plustrce
(then connected as "SYSTEM")
$ORACLE_HOME\sqlplus\admin\pupbld

Running this lot takes around 30 minutes.

Let us know if this solves the mystery.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Thargy]

Santa,

thanks for that. I was dreading testing my scripting, as 30 minutes per test run would wipe me out. I presume that since the above are provided by oracle corporation, they can be guaranteed to run error-free. Will I be safe to do my test runs up to that point, winkle out the bugs, and then just do one full run at the end? Are there any gotcha's with this approach?

Regards

Tharg

Grinding away at things Oracular

 

[Beilstwh]

Only on Gotcha. Your database will not be usable until you run all the oracle supplied scripts.

Bill
Oracle DBA/Developer
New York State, USA

 

[SantaMufasa]

...and invariably, there those scripts do throw errors, but they are not fatal in that the errors result from such things as attempting to a) DROP objects that do not exist and b) CREATE objects (e.g., SYNONYMS) that do exist.

(Oracle, IMHO, did a remarkably shoddy job on these scripts since they could do checking for the existence of objects prior to running commands that depend either on the objects' existence or non-existence.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]