|
|
Re: Flush shared pool [message #385441 is a reply to message #385440] |
Mon, 09 February 2009 12:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Thanks Thomas for your help.
But unfortunately I could not get the required information
for the link.I could not find if we can flush only
streams_pool.We can issue the following command to
flush everything in SGA:-
alter system flush global;
But I am not sure if It can impact as I have to
flush streams_pool from production database.
I would highy appreciate If you could give more specific
answer to this.
Regards,
Varun Punj,
|
|
|
|
|
|
Re: Flush shared pool [message #385448 is a reply to message #385446] |
Mon, 09 February 2009 12:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
The best thing to resolve critical issues would be to remove the cause for the critical issue. Since we don't know what critical issue you are talking about, we can't suggest anything.
Oracle isn't like Windows where "trying to reboot" is always a good suggestion. Any critical issues have their own specific fixes.
|
|
|