DBMS_DATA_ACCESS Views

Describes the Autonomous Database dynamic performance views you can use with the DBMS_DATA_ACCESS package to monitor Pre-Authenticated Request (PAR) URL usage.

V$DATA_ACCESS_URL_STATS and GV$DATA_ACCESS_URL_STATS Views

Displays access to each PAR URL owned by an Autonomous Database instance.

When a PAR URL is accessed, CPU time, User I/O wait time, are updated in the V$DATA_ACCESS_URL_STATS view.

The GV$CLOUD_LINK_ACCESS_STATS view contains the additional column named INST_ID of data type NUMBER. The INST_ID column displays the instance from which the associated V$ view information was obtained. The INST_ID column can be used as a filter to retrieve V$CLOUD_LINK_ACCESS_STATS information from a subset of available instances.

Column Datatype NULL Description
INST_ID NUMBER NOT NULL Instance ID
PRE_AUTH_URL_ID VARCHAR2(128) NOT NULL Pre-Authenticated Request URL identifier
ELAPSED_TIME NUMBER NOT NULL Elapsed time (in microseconds) of local SQL
CPU_TIME NUMBER NOT NULL CPU time (in microseconds) of local SQL
USER_IO_WAIT_TIME NUMBER NOT NULL User I/O Wait time (in microseconds) of local SQL
EXECUTIONS NUMBER NOT NULL Number of executions of local SQL
FETCHES NUMBER NOT NULL Number of fetches of local SQL
ROWS_PROCESSED NUMBER NOT NULL Number of rows retrieved by local SQL
CON_ID NUMBER NOT NULL Container ID