-
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
-
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
-
tamil, can you give me some Doc's on that?
thanks!
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
-
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?
I remember when this place was cool.
-
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.
Code:
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.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
-
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 ??
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
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?
-
Originally posted by DaPi
The big question: how does it reflect on response time or throughput?
It hardly does..
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
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
|