DBMS_CLOUD_LINK Views
The DBMS_CLOUD_LINK package uses the following views.
DBA_CLOUD_LINK_ACCESS and ALL_CLOUD_LINK_ACCESS Views
Displays details of the registered data sets an Autonomous AI Database instance is allowed to access.
Only the ADMIN user and users with the PDB_DBA role are privileged to access DBA_CLOUD_LINK_ACCESS. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
NAMESPACE |
VARCHAR2(128) |
NOT NULL |
Namespace of registered data set. |
NAME |
VARCHAR2(128) |
NOT NULL |
Name of registered data set. |
CREATED |
TIMESTAMP(6) |
NOT NULL |
Time/Date when the data set was created. |
LAST_MODIFIED |
TIMESTAMP(6) |
NOT NULL |
Time when metadata of data set was last modified |
AUTHORIZATION_REQUIRED |
VARCHAR2(1) |
NOT NULL |
Data set requires additional authorization. Possible values are: “T” or “F”. |
DATA_SET_OWNER |
VARCHAR2(128) |
NULL |
Data set owner. |
DESCRIPTION |
CLOB |
NULL |
Provides a text description. |
PROXY_SQL_ENABLED |
VARCHAR2(1) |
NOT NULL |
Indicates whether or not a Cloud Link is registered with Proxy SQL enabled. Possible values are: ‘Y’ if Proxy SQL is enabled and ‘N’ if Proxy SQL is not enabled. |
DBA_CLOUD_LINK_AUTHORIZATIONS View
Displays details of which databases are authorized to access data sets. This applies to data sets that require additional authorization.
Only the ADMIN user and users with the PDB_DBA role are privileged to access DBA_CLOUD_LINK_AUTHORIZATIONS. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
NAMESPACE |
VARCHAR2(128) |
NOT NULL |
Namespace of registered data set. |
NAME |
VARCHAR2(128) |
NOT NULL |
Name of registered data set. |
CLOUD_LINK_DATABASE_ID |
VARCHAR2(40) |
NOT NULL |
Database ID of database that has been authorized for access. |
DBA_CLOUD_LINK_PRIVS and USER_CLOUD_LINK_PRIVS Views
Displays details of the Cloud Link specific privileges, REGISTER, READ, AUTHORIZE, granted to specific users or to the current user.
USER_CLOUD_LINK_PRIVS columns are the same as those in DBA_CLOUD_LINK_PRIVS. (except for GRANTEE).
Only the ADMIN user and users with the PDB_DBA role are privileged to read from DBA_CLOUD_LINK_PRIVS. You cannot grant access to other users.
The privilege to read from USER_CLOUD_LINK_PRIVS view is granted to the ADMIN user, to the PDB_DBA role, and to the role DWROLE.
| Column | Datatype | NULL | Description |
|---|---|---|---|
GRANTEE |
VARCHAR2(128) |
NOT NULL |
Name of user to whom privilege is granted. This column is not available in USER_CLOUD_LINK_PRIVS. |
PRIVILEGE |
VARCHAR2(9) |
NOT NULL |
Privilege, one of: REGISTER, READ, AUTHORIZE, granted to user. |
SCOPE |
VARCHAR2(14) |
NOT NULL |
Scope of the privilege. |
DBA_CLOUD_LINK_REGISTRATIONS and ALL_CLOUD_LINK_REGISTRATIONS Views
Displays details of all the data set registrations on an Autonomous AI Database instance.
Only the ADMIN user and users with the PDB_DBA role are privileged to access DBA_CLOUD_LINK_REGISTRATIONS. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
NAMESPACE |
VARCHAR2(128) |
NOT NULL |
Namespace of registered data set. |
NAME |
VARCHAR2(128) |
NOT NULL |
Name of registered data set. |
ID |
RAW(16) |
NOT NULL |
Unique ID of registered data set. |
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of object (table or view owner). |
OBJECT_NAME |
VARCHAR2(128) |
NOT NULL |
Name of object. |
SCOPE |
CLOB |
NOT NULL |
JSON document with details of who is allowed to access the registered data set. |
DESCRIPTION |
CLOB |
NOT NULL |
Description of registered data set. |
CREATED |
TIMESTAMP(6) |
NOT NULL |
Time/Date when the data set was created. |
LAST_MODIFIED |
TIMESTAMP(6) |
NOT NULL |
Time when metadata of data set was last modified |
AUTHORIZATION_REQUIRED |
VARCHAR2(1) |
NOT NULL |
Data set requires additional authorization. Possible values are: “T” or “F”. |
DATA_SET_OWNER |
VARCHAR2(128) |
NULL |
Data set owner. |
PROXY_SQL_ENABLED |
VARCHAR2(1) |
NOT NULL |
Indicates whether or not a Cloud Link is registered with Proxy SQL enabled. Possible values are: ‘Y’ if Proxy SQL is enabled and ‘N’ if Proxy SQL is not enabled. |
DBA_CLOUD_LINK_SERVICE_MAPPINGS View
Displays details of all service mappings for Cloud Links consumer databases. Each service mapping consists of a Cloud Link database ID and a database service.
Only the ADMIN user and users with the PDB_DBA role are privileged to access DBA_CLOUD_LINK_SERVICE_MAPPINGS. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
CLOUD_LINK_DATABASE_ID |
VARCHAR2(40) |
NOT NULL |
Database Identifier of consumer database or “ANY”. |
SERVICE_NAME |
VARCHAR2(10) |
NULL |
Database service name (HIGH, MEDIUM, or LOW). |
V$CLOUD_LINK_ACCESS_STATS and GV$CLOUD_LINK_ACCESS_STATS Views
Displays access to each registered data set owned by an Autonomous AI Database instance.
V$CLOUD_LINK_ACCESS_STATS tracks the elapsed time, DB CPU time, the number of rows retrieved, the number of executions, and the unique database identifier of the database accessing a registered data set.
In addition to the V$CLOUD_LINK_ACCESS_STATS information, the GV$CLOUD_LINK_ACCESS_STATS view contains an extra 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.
The unique database identifier does not disclose the OCIDs (Tenancy, Compartment, Database). This information can be used for auditing an Autonomous AI Database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INST_ID |
NUMBER |
NOT NULL |
Instance ID |
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of object(table or view owner) |
OBJECT_NAME |
VARCHAR2(128) |
NOT NULL |
Name of object |
DATA_SET_NAMESPACE |
VARCHAR2(128) |
NOT NULL |
Namespace of registered data set |
DATA_SET_NAME |
VARCHAR2(128) |
NOT NULL |
Name of registered data set |
SQL_ID |
VARCHAR2(13) |
NOT NULL |
SQL ID of local SQL accessing a registered data set |
LAST_ACTIVE_TIME |
DATE |
NOT NULL |
Time when local SQL was last active |
CLOUD_LINK_DATABASE_ID |
VARCHAR2(512) |
NOT NULL |
Database identifier of database accessing a registered data set |
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 |