Home » RDBMS Server » Backup & Recovery » Creating Database in Oracle 10g
Creating Database in Oracle 10g [message #201318] Fri, 03 November 2006 08:39 Go to next message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
Hello all,

We need to create a new database in Oracle 10g R2 in Sun solaris 5.8.

Our approximate size of the database is 30Gb.

Can you please advice how to set initializtion parameters in the init.ora. For example, how to set db_block size, cache size and all the other parameters while creating the db.

Is it advisable to use the default parameter settings come up while installing oracle 10g.

Please advice?

Thanks and Regards,
Prashanth
Re: Creating Database in Oracle 10g [message #201322 is a reply to message #201318] Fri, 03 November 2006 08:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Is it advisable to use the default parameter settings
You have not provided the useful information to start with.
How is the database about to be used?
Is it an OLTP/DSS/DataMart/OLAP/XMLDB...?
If you are not sure about these, start with default ( and low settings and adjust later).
Re: Creating Database in Oracle 10g [message #201348 is a reply to message #201322] Fri, 03 November 2006 11:19 Go to previous message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
Its for OLTP purposes.
Previous Topic: Few questions on RMAN
Next Topic: help me to recover data
Goto Forum:
  


Current Time: Mon Dec 05 13:21:33 CST 2016

Total time taken to generate the page: 0.10157 seconds