Hello to all
My hit ratio in 97.3% i need to increase it to 99%
I run on win2003 ENT and oracle 10.2.0.2
This is my oracle parameter of the sga:
Db_cache_size is 2634022912
shared_pool_size 654311424
This the result of the commend show sga
SQL> show sga
Total System Global Area 3338665984 bytes
Fixed Size 2057224 bytes
Variable Size 687868920 bytes
Database Buffers 2634022912 bytes
Redo Buffers 14716928 bytes
as i read in note and in the forums i need to increase the db_cache_size
My question is how much in need to increase the db_cache_size? And if i should increase the shared_pool_size also?
I have about 3G free in the server
Thanks
Menashe