| Shared Pool. [message #64968] |
Fri, 19 March 2004 05:30  |
Max
Messages: 18
Registered: May 2002
|
Junior Member |
|
|
Is it good to flush shared pool every night...
-Max
|
|
|
|
| Re: Shared Pool. [message #64969 is a reply to message #64968] |
Fri, 19 March 2004 07:36  |
Thiru
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.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
