Skip to Content
0
Former Member
Jan 18, 2011 at 04:19 PM

how to incrase quality data buffer

272 Views

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