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
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
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: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
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
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
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
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
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: DB cache filled up, any solution????
Next Topic: error while running script
Goto Forum:
  


Current Time: Thu Dec 08 16:33:05 CST 2016

Total time taken to generate the page: 0.06788 seconds