Home » RDBMS Server » Performance Tuning » Shared Pool.
Shared Pool. [message #64968] Fri, 19 March 2004 05:30 Go to next message
Messages: 18
Registered: May 2002
Junior Member
Is it good to flush shared pool every night...


Re: Shared Pool. [message #64969 is a reply to message #64968] Fri, 19 March 2004 07:36 Go to previous messageGo to next message
Messages: 1089
Registered: May 2002
Senior Member
I wouldnt make it a routine. It flushes everything(ie library cache,data dictionary cache) resulting in unnecessary hard parses. When you size the shared_pool(ie not overallocate) properly ,employ bind variables,use large_pool etc, shared_pool rarely gets fragmented and you will never have the need to flush the cache.

Re: Shared Pool. [message #65003 is a reply to message #64968] Sat, 27 March 2004 09:33 Go to previous message
Messages: 411
Registered: November 1998
Senior Member
No Way.......
Previous Topic: Application is Hanging.
Next Topic: View index
Goto Forum:

Current Time: Tue Sep 22 07:39:34 CDT 2020