OraFAQ Forum: Server Administration » Simple editing of initDB.ora

Home » RDBMS Server » Server Administration » Simple editing of initDB.ora (RDBMS 11.2.0.2 RHEL6)

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

Simple editing of initDB.ora [message #511919]

Thu, 16 June 2011 01:43

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

I have a simple question. If I edit the lines below, do I have to edit BOTH lines or ONLY for example "*.__sga_target=18816M" and the "testdb.__sga_target=19730006016" will automatically change, or do I have to take out the calculator (and edit the testdb.__sga_target=19730006016 as well)?

*.__db_cache_size=12928M
testdb.__db_cache_size=13555990528
*.__java_pool_size=256M
testdb.__java_pool_size=268435456
*.__large_pool_size=128M
testdb.__large_pool_size=134217728
*.__oracle_base='/testdb/oracle'# ORACLE_BASE set from environment
*.__pga_aggregate_target=32384M
testdb.__pga_aggregate_target=33957085184
*.__sga_target=18816M
testdb.__sga_target=19730006016
*.__shared_io_pool_size=0
testdb.__shared_io_pool_size=0
*.__shared_pool_size=4992M
testdb.__shared_pool_size=5234491392
*.__streams_pool_size=128M
testdb.__streams_pool_size=134217728

[Updated on: Thu, 16 June 2011 01:52]

Report message to a moderator

Re: Simple editing of initDB.ora [message #511920 is a reply to message #511919]

Thu, 16 June 2011 02:03

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

These lines are from a spfile (or in a init.orra generated from a spfile).
They are automatically calculated and changed by Oracle.
You can do 2 things
- leave them as it
- remove them
but do not change the values.

Regards
Michel

Report message to a moderator

Re: Simple editing of initDB.ora [message #511922 is a reply to message #511919]

Thu, 16 June 2011 02:14

hristo
Messages: 258
Registered: May 2007

Senior Member

Never mind. I found out the I could "replace" all those values with SGA_TARGET instead. Smile

I will use this init file for another database.

[Updated on: Thu, 16 June 2011 02:15]

Report message to a moderator

Previous Topic:	Remote external jobs on Windows
Next Topic:	Re-scheduling DBA_SCHEDULER_JOBS to run on specific node?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 15:16:50 CST 2025