| shantanu |
Posted: Jan 30, 2008 09:42:02 PM |
Total Post: 42
Joined: May, 2007
|
Hello DBA's
While practicing I brought 'EXAMPLE' tablespace in to offline state and performed restore of the example datafile which completed successfully but when performing media recovery its failing with error : " Unable to allocate
32332 bytes of shared memory shared pool...etc etc. I tried to flush shared pool, buffer cache to free up library cache which did'nt work. How Can I complete the media recovery and bring tablespace online.
|
|
|
 Mohammed Taj |
| Posted: Jan 31, 2008 09:53:36 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
Increase sga(shared_pool) memory.
|
|
|
|
|
| shantanu |
| Posted: Jan 31, 2008 11:38:28 AM | |
|
Total Post: 42
Joined: May, 2007
|
When tried results in "Insufficient memory to grow pool"
current shared_pool_size = 54M where as total SGA_MAX_SIZE = 71M. any suggestion how to increase?
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 01, 2008 11:56:29 PM | |
|
Total Post: 694
Joined: Jul, 2007
|
What is physical memory on system ? (RAM)
|
|
|
|
|
| shantanu |
| Posted: Feb 02, 2008 12:01:26 PM | |
|
Total Post: 42
Joined: May, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
