3.117 ALL_AVTUNE_ARCHIVE_QUERIES

ALL_AVTUNE_ARCHIVE_QUERIES displays the query history used for auto tuning the auto-cache enabled analytic views accessible to the current user.

Related Views

  • DBA_AVTUNE_ARCHIVE_QUERIES displays the query history used for auto tuning all auto-cache enabled analytic views in the database.

  • USER_AVTUNE_ARCHIVE_QUERIES displays the query history used for auto tuning the auto-cache enabled analytic views owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the analytic view

AV_NAME

VARCHAR2(128)

NOT NULL

Name of the analytic view

QUERY_TOTAL_TIME

NUMBER(38,3)

Amount of time (in seconds) that was taken for the query

QUERY_TIMESTAMP

TIMESTAMP(6) WITH TIME ZONE

Timestamp of the query

SQL_ID

VARCHAR2(13)

NOT NULL

SQL identifier for the query object

INST_ID

NUMBER

NOT NULL

Identifier of the instance where the query was executed

CACHE_ID

NUMBER(38)

If a cache was used, the ID of the cache. Otherwise, null.

HARD_PARSE_TIME

NUMBER

NOT NULL

Average hard parse time used (in seconds)

EXECUTIONS

NUMBER

NOT NULL

Number of executions of the query

Note:

This view is available starting with Oracle Database 23ai, Release Update 23.7.

See Also: