Home » RDBMS Server » Server Administration » Flush shared pool (10.2.0.2)
Flush shared pool [message #385439] Mon, 09 February 2009 11:34 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts
1,Is there anyway to flush streams_pool.
Regards,
Varun Punj,
Re: Flush shared pool [message #385440 is a reply to message #385439] Mon, 09 February 2009 11:49 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
alter system
Re: Flush shared pool [message #385441 is a reply to message #385440] Mon, 09 February 2009 12:11 Go to previous messageGo to next message
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 #385443 is a reply to message #385441] Mon, 09 February 2009 12:26 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You can't only flush streams_pool, only the entire SGA as it is described in the documentation.
Re: Flush shared pool [message #385445 is a reply to message #385443] Mon, 09 February 2009 12:36 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Is it good idea to flush SGA in production database to resolve
any critical issue.
Regards,
Varun Punj,
Re: Flush shared pool [message #385446 is a reply to message #385439] Mon, 09 February 2009 12:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You do what is required to keep production functioning;
whether or not that includes flushing SGA it depends upon details.
Re: Flush shared pool [message #385448 is a reply to message #385446] Mon, 09 February 2009 12:48 Go to previous message
ThomasG
Messages: 3211
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.
Previous Topic: 10gR1 to 10gR2 (merged)
Next Topic: Maximum Size setting of datafiles
Goto Forum:
  


Current Time: Fri Jul 05 04:14:29 CDT 2024