candidate for buffer pools
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: candidate for buffer pools

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    this is a query that find a good candidate for putting object in the buffer pool keep.


    --Candidat pour le keep pool.
    select obj object,
    count(1) buffers,
    avg(tch) avg_touches
    from
    x$bh,
    (select value totsize from v$parameter where name = 'db_block_buffers')
    where
    lru_flag = 8
    group by obj
    having avg(tch) > 5
    and count(1) > 20;




    How can i know, what is the object?

    ex of result:

    OBJECT BUFFERS AVG_TOUCHES
    --------- --------- -----------
    27004 7 14.857143
    27082 25 4.28
    27158 6 3.1666667
    28022 8 5.375

    i want to know what is the table or the index or whaterver.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    well I guess object would be the object_id in dba_objects





  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Actualy it is DATA_OBJECT_ID from DBA_OBJECTS, not OBJECT_ID.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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