DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: shared pool fragmentation

  1. #1
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24

    shared pool fragmentation

    hello:
    I want to get the fragmentation % of the shared pool , is there some script that can help me to tune this???

    Thanks ---
    Marcelo Quesada
    :)

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Code:
    -------------------------------------------------------------------------------
    --
    -- Script:	shared_pool_lru_stats.sql
    -- Purpose:	to check the shared pool lru stats
    -- For:		8.0 and higher
    --
    -- Copyright:	(c) Ixora Pty Ltd
    -- Author:	Steve Adams
    --
    -------------------------------------------------------------------------------
    @save_sqlplus_settings
    
    column kghlurcr heading "RECURRENT|CHUNKS"
    column kghlutrn heading "TRANSIENT|CHUNKS"
    column kghlufsh heading "FLUSHED|CHUNKS"
    column kghluops heading "PINS AND|RELEASES"
    column kghlunfu heading "ORA-4031|ERRORS"
    column kghlunfs heading "LAST ERROR|SIZE"
    
    select
      kghlurcr,
      kghlutrn,
      kghlufsh,
      kghluops,
      kghlunfu,
      kghlunfs
    from
      sys.x_$kghlu
    where
      inst_id = userenv('Instance')
    /
    curtesy from Steve Adams

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