Home » RDBMS Server » Server Administration » segments
segments [message #309583] Fri, 28 March 2008 01:07 Go to next message
sidd_411
Messages: 30
Registered: March 2008
Karma: 0
Member
Hi,

what should be the default values for

db_cache_size
shared_pool_size


in my spfile, it is

db_cache_size=0
shared_pool_size=4
Re: segments [message #309584 is a reply to message #309583] Fri, 28 March 2008 01:08 Go to previous messageGo to next message
sidd_411
Messages: 30
Registered: March 2008
Karma: 0
Member
sorry, title is wrong, I apologize for that
Re: segments [message #309597 is a reply to message #309583] Fri, 28 March 2008 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
What do you mean "what should be"?
What is the default value?
What is the value you should set if you don't know what to set?
What...?

Regards
Michel
Re: segments [message #309657 is a reply to message #309583] Fri, 28 March 2008 05:45 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Karma: 0
Senior Member
Can you start your instance with such configuration?
Re: segments [message #309821 is a reply to message #309583] Sat, 29 March 2008 01:31 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Karma: 0
Senior Member

What is your database version?
If it is "0" then you must use AUTOMATIC SGA configuration.
through setting 'SGA_TARGET' parameter.

Re: segments [message #309836 is a reply to message #309657] Sat, 29 March 2008 02:53 Go to previous messageGo to next message
sidd_411
Messages: 30
Registered: March 2008
Karma: 0
Member
Ya i can
Re: segments [message #309837 is a reply to message #309836] Sat, 29 March 2008 02:54 Go to previous messageGo to next message
sidd_411
Messages: 30
Registered: March 2008
Karma: 0
Member
mine is

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Re: segments [message #309899 is a reply to message #309583] Sat, 29 March 2008 13:15 Go to previous message
varu123
Messages: 754
Registered: October 2007
Karma: 0
Senior Member
Whats the output of :
SQL> show sga
SQL> show parameter SGA_TARGET
SQL> show parameter SGA_MAX_SIZE
SQL> select * from v$sgainfo;
Previous Topic: Status Pending
Next Topic: standby database goes down.
Goto Forum:
  


Current Time: Tue Aug 22 12:01:02 CDT 2017

Total time taken to generate the page: 0.05934 seconds