DBA_PROXY_SQL Views
Describes the Autonomous AI Database DBA_PROXY_SQL views.
DBA_PROXY_SQL_ACCEPTED_MAPPINGS View
The DBA_PROXY_SQL_ACCEPTED_MAPPINGS view lists all the records of the routing table in the router Autonomous AI Database instance.
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the table |
ROUTER_DATABASE_OCID |
VARCHAR2(512) |
OCI ID of the router database instance |
DBA_PROXY_SQL_ACTIONS View
Displays the action names for which query offload is configured. You must query this view from a session that is not enabled for query offload on an Autonomous AI Database instance.
| Column | Datatype | NULL | Description |
|---|---|---|---|
ACTION_NAME |
VARCHAR2(4000) |
List of actions |
DBA_PROXY_SQL_MAPPINGS View
The DBA_PROXY_SQL_MAPPINGS view lists all the records of the routing table in the router Autonomous AI Database instance.
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the table |
OBJECT_NAME |
VARCHAR2(128) |
Name of the object |
DATABASE_OCID |
VARCHAR2(512) |
OCI ID of the target database instance |
DBA_PROXY_SQL_MODULES View
Displays the module names for which query offload is configured. You must query this view from a session that is not enabled for query offload on an Autonomous AI Database instance.
| Column | Datatype | NULL | Description |
|---|---|---|---|
MODULE_NAME |
VARCHAR2(4000) |
List of modules |