Autonomous AI Database Views

Autonomous AI Database provides several views that are not available in Oracle Database 19c. This topic lists the Autonomous AI Database specific views.

• Track Table and Partition Scan Access with Autonomous AI Database Views

  Oracle Autonomous AI Database tracks the scan count for tables and partitions. Use the table access stats data dictionary and dynamic views to retrieve scan count information.

• Track Oracle Cloud Infrastructure Resources, Cost and Usage Reports with Autonomous AI Database Views

  Oracle Autonomous AI Database tracks the Oracle Cloud Infrastructure resources, cost and usage reports. You can access these reports using the OCI views.

• Pipeline Views

  Lists details for the DBMS_CLOUD_PIPELINE views.

• DBMS_CLOUD_AI Views

  The DBMS_CLOUD_AI package uses the following views.

• DBMS_CLOUD_AI_AGENT Views

  The DBMS_CLOUD_AI_AGENT package uses the following views.

• DBMS_CLOUD_FUNCTION Views

  The DBMS_CLOUD_FUNCTION package uses the following views.

• DBMS_CLOUD_LINK Views

  The DBMS_CLOUD_LINK package uses the following views.

• DBMS_DATA_ACCESS Views

  Describes the Autonomous AI Database dynamic performance views you can use with the DBMS_DATA_ACCESS package to monitor Table Hyperlink URL usage.

• DBA_NONJSON_OBJECTS View

  Displays the list of non-JSON objects on an Autonomous AI Database instance and includes a column with the space consumption in bytes of the object and dependent objects.

• DBA_PROXY_SQL Views

  Describes the Autonomous AI Database DBA_PROXY_SQL views.

• DBMS_CLOUD_IMPORT Views Describes the Autonomous AI Database DBMS_CLOUD_IMPORT views.

• Lockdown Errors View

  Lists details for the DBA_LOCKDOWN_ERRORS view.

• Oracle Cloud Infrastructure Logging Interface Views

  The Oracle Cloud Infrastructure (OCI) logging interface views enable authorized users to access log data through a set of views.

• Real Application Testing Capture Replay Views

  Oracle Real Application Testing capture replay views.

• Stripe Views on Autonomous AI Database

  Stripe is an online payment processing and credit card processing platform for businesses. Users can query views created on top of Stripe APIs using the DBMS_CLOUD package to get Stripe information such as invoices, subscriptions, and customers.

• Track DBMS_CLOUD Load Operations

  DBMS_CLOUD tracks details for load operations for each instance and for users.

• V$CLIENT_ERRORS View

  Describes the columns in the V$CLIENT_ERRORS View.

• PURGE_CONVERTED_STMTS View

  Describes the Autonomous AI Database PURGE_CONVERTED_STMTS view.