DBA_PROXY_SQL Views
Describes
the Autonomous Database
DBA_PROXY_SQL views.
- DBA_PROXY_SQL_ACCEPTED_MAPPINGS View
TheDBA_PROXY_SQL_ACCEPTED_MAPPINGSview lists all the records of the routing table in the router Autonomous 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 Database instance. - DBA_PROXY_SQL_MAPPINGS View
TheDBA_PROXY_SQL_MAPPINGSview lists all the records of the routing table in the router Autonomous 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 Database instance.
Parent topic: Autonomous Database 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 Database instance.
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the table |
OBJECT_NAME |
VARCHAR2(128) |
Name of the object |
ROUTER_DATABASE_OCID |
VARCHAR2(512) |
OCI ID of the router database instance |
Parent topic: DBA_PROXY_SQL Views
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 Database instance.
| Column | Datatype | NULL | Description |
|---|---|---|---|
ACTION_NAME |
VARCHAR2(4000) |
List of actions |
Parent topic: DBA_PROXY_SQL Views
DBA_PROXY_SQL_MAPPINGS View
The DBA_PROXY_SQL_MAPPINGS view lists all the records of
the routing table in the router Autonomous 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 |
Parent topic: DBA_PROXY_SQL Views
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 Database instance.
| Column | Datatype | NULL | Description |
|---|---|---|---|
MODULE_NAME |
VARCHAR2(4000) |
List of modules |
Parent topic: DBA_PROXY_SQL Views