DBMS_DATA_ACCESS Views
Describes
the Autonomous Database dynamic performance views
you can use with the DBMS_DATA_ACCESS package to monitor Table Hyperlink
URL usage.
- V$DATA_ACCESS_URL_STATS and GV$DATA_ACCESS_URL_STATS Views
Displays access to each Table Hyperlink owned by an Autonomous Database instance.
Parent topic: Autonomous Database Views
V$DATA_ACCESS_URL_STATS and GV$DATA_ACCESS_URL_STATS Views
When a Table Hyperlink is accessed, CPU time, User I/O wait time, are updated
in the V$DATA_ACCESS_URL_STATS view.
The GV$DATA_ACCESS_URL_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$DATA_ACCESS_URL_STATS
information from a subset of available instances.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INST_ID |
NUMBER |
NOT NULL |
Instance ID |
SQL_ID |
VARCHAR2(13) |
NOT NULL |
SQL ID of SQL accessing data when a Table Hyperlink is accessed |
PRE_AUTH_URL_ID |
VARCHAR2(128) |
NOT NULL |
Table Hyperlink 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 |
USER_ID |
VARCHAR2(128) |
Application User ID defined for Table Hyperlink | |
CON_ID |
NUMBER |
NOT NULL |
Container ID |
Parent topic: DBMS_DATA_ACCESS Views