|
-
Hi,
Lots of parsing causes fragmentation on sharedpool which has to be avoided.If parsing is more,adding shared pool size, might worsen the situation as it has to scan more memory than before for similar SQL statements.
Frequently used packages could be KEPT in the shared pool using dbms_shared_pool.keep procedure.
For more information can check
Docid 62143.1 in Metalink.
K.Chithra
Oracle DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|