SYSTEM.MVIEW_WORKLOAD

Table 34-27 SYSTEM.MVIEW_WORKLOAD

Column	NULL?	Datatype	Description
APPLICATION		VARCHAR2(30)	Optional application name for the query
CARDINALITY		NUMBER	Total cardinality of all of tables in query
WORKLOADID		NUMBER	Workload id identifying a unique sampling
FREQUENCY		NUMBER	Number of times query executed
IMPORT_TIME		DATE	Date at which item was collected
LASTUSE		DATE	Last date of execution
OWNER		VARCHAR2(30)	User who last executed query
PRIORITY		NUMBER	User-supplied ranking of query
QUERY		LONG	Query text
QUERYID		NUMBER	Id number identifying a unique query
RESPONSETIME		NUMBER	Execution time in seconds
RESULTSIZE		NUMBER	Total bytes selected by the query