| increasing buffer cache....! [message #128457] |
Mon, 18 July 2005 12:30  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai ,
we are using statspack for performance issues.based on that report generated on that , it is found that the buffer hit ratio is below 90% and needs to be increased. it is indicated that buffer size is 78M.but in parameters there is not like that set while shared pool size is there.how to see the buffer cache size and then we have to change it using alter system set and all.plz help out.
regards
bala
|
|
|
|
|
|
|
|
|
|
| Re: increasing buffer cache....! [message #128464 is a reply to message #128457] |
Mon, 18 July 2005 13:30  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
If you are on 10g, you can set sga_target and forget about tuning the buffer cache, let oracle do it for you. If you are on 9i, I think there is a buffer cache advisory you can run which will give you an idea of the kind of performance results from changing the size. In either case, suggest reading the performance tuning guide and concepts guide sections on memory.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
