Transaction Processing and JSON Database Workloads with Autonomous Database
Autonomous Database configures and optimizes your database for you, based on your workload.
Characteristics of Autonomous Database with Transaction Processing or JSON Database workloads:
-
The default data and temporary tablespaces for the database are configured automatically. Adding, removing, or modifying tablespaces is not allowed. Autonomous Database creates one tablespace or multiple tablespaces automatically depending on the storage size.
-
The database character set is Unicode
AL32UTF8
. See Choose a Character Set for Autonomous Database for more information. -
Compression is not enabled by default but Autonomous Database honors a compression clause if compression is specified on a table.
Accessing a database:
-
You do not have direct access to the database node. You can create and drop directories with
CREATE DIRECTORY
andDROP DIRECTORY
, as described in Create and Manage Directories.You can use
DBMS_CLOUD
procedures such asDBMS_CLOUD.DELETE_FILE
,DBMS_CLOUD.GET_OBJECT
, andDBMS_CLOUD.PUT_OBJECT
with files and objects. You do not have direct access to the local file system.
Parallel Execution with Transaction Processing or JSON Database workloads:
-
Parallelism is determined by the database service you use. See Database Service Names for Autonomous Database for details about parallelism support for each database service.
-
When you want to run DML operations in parallel and the database service you are using allows this, you can enable parallel DML in your session using the following SQL command:
ALTER SESSION ENABLE PARALLEL DML;
See VLDB and Partitioning Guide for more information on parallel DML operations.
-
If you create an index manually and specify the
PARALLEL
clause, thePARALLEL
attribute remains after the index is created. In this case SQL statements can run in parallel unbeknownst to the end user.To specify serial execution, change the
INDEX
parallel clause toNOPARALLEL
or set thePARALLEL
degree attribute to 1 to specify serial execution:ALTER INDEX index_name NOPARALLEL;
or
ALTER INDEX index_name PARALLEL 1;