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

Report message to a moderator

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: 10707
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).

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Few questions on RMAN
Next Topic: help me to recover data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 13:58:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.