VIEW: CTXSYS.CTX_FILTER_CACHE_STATISTICS

Source

View Text - Preformatted

select u1.name     fcs_index_owner,
       i.idx_name  fcs_index_name,
       p.ixp_name  fcs_partition_name,
       ctxsys.drvparx.GetFilterCacheSize     fcs_size,
       ctxsys.drvparx.GetFilterCacheEntries  fcs_entries,
       ctxsys.drvparx.GetFilterCacheRequests fcs_requests,
       ctxsys.drvparx.GetFilterCacheHits     fcs_hits
  from ctxsys.dr$index i, ctxsys.dr$index_partition p, sys.user$ u1
       where i.idx_owner# = u1.user# and
             i.idx_option like '%U%' and
             i.idx_id =
               ctxsys.drvparx.FilterCacheGetStats(i.idx_id, i.idx_owner#,
                                                  u1.name, i.idx_name,
                                                  p.ixp_name) and
             i.idx_id = p.ixp_idx_id (+)

View Text - HTML Formatted

SELECT U1.NAME FCS_INDEX_OWNER
, I.IDX_NAME FCS_INDEX_NAME
, P.IXP_NAME FCS_PARTITION_NAME
, CTXSYS.DRVPARX.GETFILTERCACHESIZE FCS_SIZE
, CTXSYS.DRVPARX.GETFILTERCACHEENTRIES FCS_ENTRIES
, CTXSYS.DRVPARX.GETFILTERCACHEREQUESTS FCS_REQUESTS
, CTXSYS.DRVPARX.GETFILTERCACHEHITS FCS_HITS
FROM CTXSYS.DR$INDEX I
, CTXSYS.DR$INDEX_PARTITION P
, SYS.USER$ U1
WHERE I.IDX_OWNER# = U1.USER# AND I.IDX_OPTION LIKE '%U%' AND I.IDX_ID = CTXSYS.DRVPARX.FILTERCACHEGETSTATS(I.IDX_ID
, I.IDX_OWNER#
, U1.NAME
, I.IDX_NAME
, P.IXP_NAME) AND I.IDX_ID = P.IXP_IDX_ID (+)