rem
rem  This view must be run on the database where instance tuning is take place
rem  if complete shared pool information is required for the evaluation.
rem

create or replace view sys.v$xppoolsegs (segment_size, name)
as select ksmchsiz, ksmchcom from x$ksmsp 
       where ksmchcls not in ('free', 'perm');