Major characteristics of an Autonomous ( Data Warehouse and Transaction Processing ) database …

  For an Autonomous Data Warehouse database :- 1.. The default data and temporary tablespaces for the database are configured automatically. Adding, removing, or modifying tablespaces is not allowed. 2.. Parallelism is enabled by default. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database … Continue reading Major characteristics of an Autonomous ( Data Warehouse and Transaction Processing ) database …