When to pin objects in memory - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 27

Thread: When to pin objects in memory

  1. #11
    Join Date
    Jul 2004
    Location
    bangalore
    Posts
    24
    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

  2. #12
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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

  3. #13
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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

  4. #14
    Join Date
    Jan 2004
    Posts
    162

  5. #15
    Join Date
    Jan 2001
    Posts
    3,131
    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.

  6. #16
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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.

    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

  7. #17
    Join Date
    Jan 2004
    Posts
    162
    By all means post a followup then

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

  8. #18
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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 ??
    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

  9. #19
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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?

  10. #20
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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
  •  


Click Here to Expand Forum to Full Width