Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53

    Unanswered: Objects pinned into shared pool

    Is there a way to know which are the objects thats pinned into shared pool? Any view or sql that i would use?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    column owner format a11 heading Schema
    column name format a25 heading Object|Name
    column namespace heading Name|Space
    column type heading Object|Type
    column kept format a4 heading Kept
    column sharable_mem format 999,999 heading Shared|Memory
    column executions format 999,999 heading Executes
    set lines 132 pages 47 feedback off
    break on owner on namespace on type
    select
    substr(OWNER,1,10) "OWNER",
    substr(NAMESPACE,1,12) "NAMESPACE",
    substr(TYPE,1,12) "TYPE",
    substr(NAME,1,25) "NAME",
    SHARABLE_MEM,
    LOADS,
    EXECUTIONS,
    LOCKS,
    PINS,
    KEPT
    from
    v$db_object_cache
    where
    type not in ('NOT LOADED','NON-EXISTENT')
    and kept='YES'
    order by owner,namespace,type,executions desc;
    clear columns
    clear breaks

    HTH
    Gregg

Posting Permissions

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