Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181

    Unanswered: db_keep_cache_size

    Hi All,

    I have configured the db_keep_cache_size on my new 9i development box = 16M and then realised I didn't know how to pin the various objects in there. I have looked around but can't find the syntax.

    Could anyone give me a pointer?

    Can I pin (keep) tables as well as indexes in there?

    Thanks in advance for any help.

    Rgs,
    Breen.

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Use alter table... storage(buffer_pool keep) and the same for indexes. You should also do the same for those object which go in the recycle pool. I use the following script to identify objects I might want to put into the keep pool.

    Alan

    select
    'alter table ' || owner || '.'|| table_name || ' storage (buffer_pool keep);'
    from dba_tables
    where buffer_pool!='KEEP'
    and num_rows between 1 and 50000
    and table_name not like 'TEMP%'

  3. #3
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Thank you AlanP,

    And thanks for the script.

    Regards,
    Breen.

  4. #4
    Join Date
    Jul 2009
    Location
    Ohio
    Posts
    3
    You can also pin procedures and other objects in your Shared Pool. This can improve performance as well.
    Last edited by bcarrdba; 07-31-09 at 22:51.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Replying to a 6 YEAR old post may not be best use of your time & efforts.
    I doubt OP will benefit from your sage advice.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jul 2009
    Location
    Ohio
    Posts
    3
    Thanks for sharing your opinion - that is also very useful

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •