Autonomous Database with Data Warehouse ignores optimizer hints and PARALLEL hints in SQL statements by default. If your application relies on hints you can enable optimizer hints by setting the parameter OPTIMIZER_IGNORE_HINTS to FALSE at the session or system level using ALTER SESSION or ALTER SYSTEM.
A Critical Patch Update is a collection of patches for multiple security vulnerabilities. This Critical Patch Update addresses 384 new security patches. Some of the vulnerabilities addressed in this Critical Patch Update affect multiple products. Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply Critical Patch Update patches as soon as possible.
The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low.
The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
Autonomous Databases come with a predefined database role named DWROLE. This role provides the common privileges for a database developer or data scientist to perform real-time analytics. Depending on the usage requirements you may also need to grant individual privileges to users.