OraFAQ Forum: Server Administration » valus in init.ora file

Home » RDBMS Server » Server Administration » valus in init.ora file

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

valus in init.ora file [message #296174]

Fri, 25 January 2008 00:06

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi,

I have put values:

1. shared_pool_size to 800M in my init.ora but in the EM Console the displayed value is 768M

2.same for db_cache_size which is set to 1GB in init.ora but showing 960M in EM.

Also, I have

alter system set sga_target =0

, so that the values set in init.ora is displayed in EM.

Thank you

Report message to a moderator

Re: valus in init.ora file [message #296185 is a reply to message #296174]

Fri, 25 January 2008 00:52

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

Senior Member
Account Moderator

Are you sure you are using init.ora and not spfile?
Prove what you say, use SQL*Plus and post the queries and their result.

Regards
Michel

[Updated on: Fri, 25 January 2008 00:53]

Report message to a moderator

Re: valus in init.ora file [message #296190 is a reply to message #296174]

Fri, 25 January 2008 01:14

dirish
Messages: 232
Registered: November 2006

Senior Member

when i start the db i just say startup pfile=/directory/initdb.ora

Report message to a moderator

Re: valus in init.ora file [message #296194 is a reply to message #296190]

Fri, 25 January 2008 01:24

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

Senior Member
Account Moderator

Query v$parameter and show the result for the relevant parameters.

Regards
Michel

Report message to a moderator

Re: valus in init.ora file [message #296460 is a reply to message #296194]

Sun, 27 January 2008 12:28

larrycatt
Messages: 3
Registered: January 2008
Location: Virginia Beach, VA

Junior Member

Just type show parameters in sqlplus

SQLPLUS> show parameters
or
SQLPLUS> show parameter <parameter name>

gives same results.

Report message to a moderator

Previous Topic:	Estimate database size
Next Topic:	dirty buffers and changed data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 28 00:39:58 CST 2025