| segments [message #309583] |
Fri, 28 March 2008 01:07  |
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 #309899 is a reply to message #309583] |
Sat, 29 March 2008 13:15  |
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; |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
