| performance problem (Hit Ratio) [message #526209] |
Mon, 10 October 2011 03:07  |
oradba123
Messages: 86
Registered: June 2009
Location: india
|
Member |
|
|
Dear All,
Our users are complaing about performce problem reagrding some reports then i check Hit ratios of main buffer pool (shared pool,database buffer,library cache...etc) , but Buffer cache Hit
ration is around 61.15% then i have just enable Automatic shared memory management by increasing SGA_TARGET size & STATISTICS_LEVEL to typical after doing this Data buffer Hit ration is 49.48% even i rebuild all indexes of the schema whose facing performance problem , so please some one suggets me to increase the peromance of the database. quick response
will be higly appreciated. thank
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
