Oracle DBA Forums > Increasing the shared_pool

Full Version: Increasing the shared_pool_size

Oracle DBA Forums > Oracle > Oracle Forum

CHANDRASEKAR

Jul 2 2008, 06:38 AM

Sir,
The statspack analyzer has suggested to increse my shared pool size. Can i do it dynamically. The server is cattering to the need of 25 lakh consumers in Electricity board. Kindly guide the safe procedure for incresing the shared pool size

chandrasekar

HAL9000

Jul 2 2008, 07:26 AM

"Kindly guide the safe procedure for incresing the shared pool size"

http://www.fast-track.cc/s66.htm

"alter system set shared_pool_size=2g;"

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.