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

VIEW: SYSTEM.MVIEW_FILTERINSTANCE

Object Details
Object Name: MVIEW_FILTERINSTANCE
Object Type: VIEW
Owner: SYSTEM
Subobject Name:
Status: VALID

Workload filter instance records

[View Source]

Columns
Name Datatype Length Mandatory Comments
RUNID NUMBER
Yes
FILTERID NUMBER

SUBFILTERNUM NUMBER

SUBFILTERTYPE VARCHAR2 (12)
STR_VALUE VARCHAR2 (1028)
NUM_VALUE1 NUMBER

NUM_VALUE2 NUMBER

DATE_VALUE1 DATE

DATE_VALUE2 DATE

Query Text

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


SELECT RUNID
,      FILTERID
,      SUBFILTERNUM
,      SUBFILTERTYPE
,      STR_VALUE
,      NUM_VALUE1
,      NUM_VALUE2
,      DATE_VALUE1
,      DATE_VALUE2
FROM SYSTEM.MVIEW_FILTERINSTANCE;

Dependencies

[top of page]

SYSTEM.MVIEW_FILTERINSTANCE references the following:

SchemaSYSTEM
TableMVIEW$_ADV_FILTERINSTANCE

SYSTEM.MVIEW_FILTERINSTANCE is not referenced by any database object