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 Database instance is allowed to access. - 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. - 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. - DBA_CLOUD_LINK_REGISTRATIONS and ALL_CLOUD_LINK_REGISTRATIONS Views
Displays details of all the data set registrations on an Autonomous Database instance. - V$CLOUD_LINK_ACCESS_STATS and GV$CLOUD_LINK_ACCESS_STATS Views
Displays access to each registered data set owned by an Autonomous Database instance.
Parent topic: Autonomous Database Views
DBA_CLOUD_LINK_ACCESS and ALL_CLOUD_LINK_ACCESS Views
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. |
Parent topic: DBMS_CLOUD_LINK Views
DBA_CLOUD_LINK_AUTHORIZATIONS View
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. |
Parent topic: DBMS_CLOUD_LINK Views
DBA_CLOUD_LINK_PRIVS and USER_CLOUD_LINK_PRIVS Views
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
|
PRIVILEGE |
VARCHAR2(9) |
NOT NULL |
Privilege, one of: REGISTER,
READ, AUTHORIZE, granted to
user.
|
SCOPE |
VARCHAR2(14) |
NOT NULL |
Scope of the privilege. |
Parent topic: DBMS_CLOUD_LINK Views
DBA_CLOUD_LINK_REGISTRATIONS and ALL_CLOUD_LINK_REGISTRATIONS Views
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. |
Parent topic: DBMS_CLOUD_LINK Views
V$CLOUD_LINK_ACCESS_STATS and GV$CLOUD_LINK_ACCESS_STATS Views
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 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 |
Parent topic: DBMS_CLOUD_LINK Views