|
-
Originally posted by OracleDoc
Ever since I've pinned it, the loads have stayed the same.
Have you monitored the total number of loads though? If DBMS_PIPE is now pinned then I expect that other code is being aged out faster and suffering more loads. I'd try monitoring total loads, not just this one package.
From the Tom Kyte thread, this is the most interesting comment for me ...
If you use it -- it'll stay.
If you don't -- it'll go.
If you pin it -- it'll stay -- meaning, if you use it, it would stay anyway. If
you DON'T use it, why did you pin it?
pinning was "useful" for big packages before the 4k pagesize stuff.
after that, not very useful
It makes sense ... and if you pin a package then it has to be at the expense of others, right?
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
|