Home » RDBMS Server » Server Administration » cannot increase db buffer cache hit ratio
cannot increase db buffer cache hit ratio [message #369299] Tue, 08 August 2000 03:55 Go to next message
WCK
Messages: 4
Registered: July 2000
Junior Member
I have increased the db buffer 4 folds, up the shared_pool_size by 4 times and yet I still can't get the db buffer cache hit ratio about 50%.
where did I go wrong?
Re: cannot increase db buffer cache hit ratio [message #369310 is a reply to message #369299] Fri, 11 August 2000 06:24 Go to previous messageGo to next message
Rajesh Matkar
Messages: 20
Registered: September 1999
Junior Member
Hi,
What is the total memory for your oracle server m/c i.e. total RAM ? Is any other s/w all installed on your oracle server m/c ? what are the current values for SGA buffers ?
Re: cannot increase db buffer cache hit ratio [message #369315 is a reply to message #369299] Mon, 14 August 2000 08:49 Go to previous message
Alpesh Patel
Messages: 4
Registered: August 2000
Junior Member
Hi

Please make sure that swapping is not taking place on server.

Alpesh
Previous Topic: Audit Transactions
Next Topic: ROLLBACK SEGMENTS -SHRINKS
Goto Forum:
  


Current Time: Fri Mar 29 05:55:57 CDT 2024