-
Asyncronous Pl/sql Block In Library Cache
Question is regarding the Tuning of Library Cache and the Fragmentation / Cache-Hit of Library Cache---------->
Does anybody has an idea as to why Oracle recommends to avoid "Large ANONYMOUS PL/SQL Blocks" and use Procedures/Functions instead?
How does it affects the Cache-Hit ratio, using Large Anonymous Blocks vis-a-vis Procedure/Function?
Mohan Wagh.
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
|