A Autonomous JSON Database for Experienced Oracle Database Users

This appendix provides information on using Autonomous JSON Database for experienced Oracle Database users with Autonomous Database Serverless.

For equivalent information about using Oracle Database features and options with Autonomous Database on dedicated Exadata infrastructure, see Oracle Database Features in Dedicated Autonomous Database Deployments.

• About Autonomous Database for Experienced Oracle Database Users
  Autonomous JSON Database configures and optimizes your database for you. You do not need to perform administration operations for configuring the database. SQL commands used for database administration such as CREATE TABLESPACE are not available. Similarly, other administrative interfaces and utilities such as RMAN are not available.
• Autonomous Database Views
  Autonomous Database provides several views that are not available in Oracle Database 19c. This topic lists the Autonomous Database specific views.
• Autonomous Database – Oracle Database Features
  Describes Oracle Database features available with Autonomous Database.
• Always Free Autonomous Database – Oracle Database 21c
  When you provision Always Free Autonomous Database you can select either Oracle Database 19c or Oracle Database 23ai.
• Autonomous Database RMAN Recovery Catalog
  You can use Oracle Autonomous Database as a Recovery Manager (RMAN) recovery catalog. A recovery catalog is a database schema that RMAN uses to store metadata about one or more Oracle databases.
• SODA Notes
  When you use SODA with Autonomous Database the following restrictions apply:
• Notes for Users Migrating from Other Oracle Databases
  Describes information that is useful when you are migrating from other Oracle Databases to Oracle Autonomous Database.
• Oracle LogMiner
  Describes restrictions for Oracle LogMiner on Autonomous Database.
• Choose a Character Set for Autonomous Database
  When you provision a database, depending on the workload type, you can select a database character set and a national character set.
• Database Features Unavailable in Autonomous Database
  Lists the Oracle Database features that are not available in Autonomous Database. Additionally, database features designed for administration are not available.

Autonomous Database – Oracle Database Features

Describes Oracle Database features available with Autonomous Database.

Autonomous JSON Database includes features that:

• Automate index management tasks, such as creating, rebuilding, and dropping indexes based on changes in the application workload.

  See Manage Automatic Indexing on Autonomous Database in Using Oracle Autonomous Database Serverless for more information.

  Note:

  There are restrictions for Automatic Indexing when you use JSON data with Autonomous JSON Database. See SODA Notes for more information.

• Gather real-time statistics automatically while a conventional DML workload is running. Because statistics can go stale between stats gathering jobs, online statistics gathering for conventional DML helps the optimizer generate more optimal plans. Online statistics aim to reduce the possibility of the optimizer being misled by stale statistics.

  See Real-Time Statistics for more information.

• Gather statistics automatically on a more frequent basis. High-Frequency Automatic Optimizer Statistics Collection complements the standard statistics collection job. By default, the collection occurs every 15 minutes, meaning that statistics have less time in which to be stale. High-Frequency Automatic Optimizer Statistics Collection is enabled by default.

  See Configuring High-Frequency Automatic Optimizer Statistics Collection for more information.

• Quarantine execution plans for SQL statements, for example, statements that are terminated by the Resource Manager for consuming excessive system resources in an Oracle Database. Automatic SQL Quarantine based on Resource Manager consumption limit violations is disabled by default but any manually quarantined SQL statement will be honored.

  See Quarantine for Execution Plans for SQL Statements Consuming Excessive System Resources for more information.

• Automatically assess the opportunity for SQL plan changes to improve the performance for known statements.

  See Managing the SPM Evolve Advisor Task for more information.

• Apache ORC format is supported in Autonomous Database for loading and querying data in object store.

  See Create Credentials and Load Data Pump Dump Files into an Existing Table and Query External Data with ORC, Parquet, or Avro Source Files in Using Oracle Autonomous Database Serverless for more information.

• Complex types are supported in Autonomous Database for ORC, Avro, and Parquet structured files.

  See DBMS_CLOUD Package ORC, Parquet and Avro Complex Types in Using Oracle Autonomous Database Serverless for more information.

SODA Notes

When you use SODA with Autonomous Database the following restrictions apply:

• Automatic indexing is not supported for SQL and PL/SQL code that uses the SQL/JSON function json_exists. See SQL/JSON Condition JSON_EXISTS for more information.

• Automatic indexing is not supported for SODA query-by-example (QBE).