When to pin objects in memory

[shans]

select ksmlrcom,ksmlrsiz,ksmlrnum from x$ksmlru;
Run this, based on ksmlrsiz and ksmlrnum find out which ksmlrcom should be pinned.

Thanks and Regards,
Satheesh Babu.S

[tamilselvan]

Pinning the PKG is necessary only in 7 and 8 to avoid 4031 error.

No need to pin PKG or procedure if you are using 8i or later release.
If the pkg size > 5K , then oracle now stores it in 5K piece in the SP.

Tamil

[OracleDoc]

tamil, can you give me some Doc's on that?
thanks!

[padders]

Is this sufficient?

http://asktom.oracle.com/pls/ask/f?p...2667245192483,

[Mr.Hanky]

Pinning, Keep pool, it's all the same crap. You are storing it in memory.

Listen to what I mean, not what I say!!

Isn't the keep pool more of a datawarehouse thing?

[OracleDoc]

Originally posted by padders
Is this sufficient?

http://asktom.oracle.com/pls/ask/f?p...2667245192483,

Thanks Padders that was a good read. Normally my Dadhas awesome advice and is able to filter and put into laymens terms all the rhetoric Oracle spews. However, just because one man says one thing doesn't mean it's the be all truth. In this particular case I'm going to have to disagree with him and the reason I am is because the code doesn't lie.
If you look at the DBMS_PIPE package that I pinned in my database yesterday from the above post and look at it this morning.

SUBSTR(OW SUBSTR(NA SUBSTR(O.      LOADS EXECUTIONS KEP
--------- --------- --------- ---------- ---------- ---
SYS       DBMS_PIPE PACKAGE         1935     723563 YES

Ever since I've pinned it, the loads have stayed the same.

[padders]

By all means post a followup then

http://asktom.oracle.com/pls/ask/f?p...:2667245192483

[OracleDoc]

Originally posted by padders
By all means post a followup then

http://asktom.oracle.com/pls/ask/f?p...:2667245192483

Hmmmm, I got a better idea why don't we get input from our community? Wouldn't you think the input from many people (with experience) would outway what one person says?

I'm not trying to spark a debate here. Like I said Tom is a great advisor. I think one should look at all the options (and opinions)before jumping to conclusions.

Move to Obfuscation Unlimited ??

[DaPi]

Originally posted by OracleDoc
Move to Obfuscation Unlimited ??

WHY? The kind of discussion you propose is EXACTLY what should be going on here.

My 2¢: Tom takes the official Oracle line (he has to). The official Oracle line is to have an infinite amount of memory and an infinite number of disks. Those of us who have to compromise might need to pin? resize SGA? etc? etc. At least with the query you gave, there is some basis for logical action and some means of measuring the effect of changes.

The big question: how does it reflect on response time or throughput?

[abhaysk]

Originally posted by DaPi
The big question: how does it reflect on response time or throughput?

It hardly does..