eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: CTXSYS.CTX_FILTER_CACHE_STATISTICS

Object Details

Object Name:	CTX_FILTER_CACHE_STATISTICS
Object Type:	VIEW
Owner:	CTXSYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
FCS_INDEX_OWNER	VARCHAR2	(128)	Yes
FCS_INDEX_NAME	VARCHAR2	(30)	Yes
FCS_PARTITION_NAME	VARCHAR2	(30)
FCS_SIZE	NUMBER
FCS_ENTRIES	NUMBER
FCS_REQUESTS	NUMBER
FCS_HITS	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FCS_INDEX_OWNER
,      FCS_INDEX_NAME
,      FCS_PARTITION_NAME
,      FCS_SIZE
,      FCS_ENTRIES
,      FCS_REQUESTS
,      FCS_HITS
FROM CTXSYS.CTX_FILTER_CACHE_STATISTICS;

Dependencies

[top of page]

CTXSYS.CTX_FILTER_CACHE_STATISTICS references the following:

CTXSYS: DR$INDEX; DR$INDEX_PARTITION; DRVPARX - show dependent code
SYS: USER$

CTXSYS.CTX_FILTER_CACHE_STATISTICS is referenced by following:

PUBLIC: CTX_FILTER_CACHE_STATISTICS