OraFAQ Forum: Server Administration » How can I modify to default parameter

Home » RDBMS Server » Server Administration » How can I modify to default parameter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can I modify to default parameter [message #51767]

Wed, 12 June 2002 17:05

Debuger
Messages: 2
Registered: June 2002

Junior Member

Hi,
everyone, now I need to create a new DB on machine, but someone require the default parameter must be changed to optimal, how can I do that?

Thanks

Report message to a moderator

Re: How can I modify to default parameter [message #51770 is a reply to message #51767]

Wed, 12 June 2002 17:33

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

which default parameter you are speaking about?
anyhow, when u use dbca or manually using initsid.ora, you can change any initsid.ora

Report message to a moderator

Re: How can I modify to default parameter [message #51772 is a reply to message #51767]

Wed, 12 June 2002 18:09

Debuger
Messages: 2
Registered: June 2002

Junior Member

oh, thanks, like the SYSTEM tablespace size, temp size
and the rollback segment size, pls help me

Report message to a moderator

Re: How can I modify to default parameter [message #51774 is a reply to message #51772]

Wed, 12 June 2002 20:13

Vikas Gupta
Messages: 115
Registered: February 2002

Senior Member

The default parameter can be modified by changing values in the initSid.Ora parameter file.

You should know the implications of changing the parameters, before doing so. And I don't think there
are any fixed optimal parameters. They will be different for different database.

However to start off.. Oracle has provided hints in important parameter settings, in the initSid.ora file itself. You can choose the database size and comment/uncomment the parameters based on it.

Run performance querries on your database and then change the parameters as required.

Report message to a moderator

Re: How can I modify to default parameter [message #51814 is a reply to message #51767]

Fri, 14 June 2002 11:54

Grant
Messages: 578
Registered: January 2002

Senior Member

You have to read the manual. There is too much information to post it to you here. I would suggest you use the Database Assistant and have it write to scripts (to create it later) and review the scripts along with the manual on the settings in the initSID.ora file.

Report message to a moderator

Previous Topic:	crash
Next Topic:	Roles??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 20:29:16 CDT 2024