Autonomous Database with Data Warehouse ignores hints

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.

Ref:

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-optimizer-stats-data-warehouse.html#GUID-0C542F13-F856-4A98-8E87-2042B2326CF6

A password is needed for downloading old Oracle patches

Here we’ll show you a demonstration on how to download an old Oracle patch if needed.

Please go to the Doc ID 2118136.2 for selecting what we like to download, for exemple select Oracle Database base releases choice.

When selected, it chows us the links for available patches.

For older version, we need to open a non-technical SR to receive a physical media or a link for downloading.

To do it, please follow the Doc ID 1071023.1

When we’re trying to download an old patch, for exemple the 30557433

Make a search for this  patch, after that please click on Download bouton.

It will ask you to put a password received for when a non-technical SR was been created.

References :

Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)

How to Request Software Media when it is Unavailable on the Oracle Software Delivery Cloud Site (Doc ID 1071023.1)

Oracle Critical Patch Update – April 20, 2021

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.

For more details:

https://www.oracle.com/security-alerts/cpuapr2021.html

Putting Data Security and Protection First

Putting Data Security and Protection First

Three foundational principles of Oracle Security

To help every organization move forward with confidence, there are three strategic security pillars to be taken in consideration :

  • architected-in,
  • automated,
  • and always-on.

Here’s how it works in practice, with these articles :

https://www.oracle.com/webfolder/s/assets/ebook/security-first/index.html

Security Articles:

Predefined Database Service Names for Autonomous Transaction Processing

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.

For more détails, you can reach the below link:

Ref:

https://docs.oracle.com/en/cloud/paas/atp-cloud/atpgs/autonomous-connect-database-service-names.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE

How to protect your data

Oracle event : April 1, 2021

Cyber ​​attacks and ransomware (ransomware) are on the rise and require us to protect our data ever more effectively.

In a digitalized environment, the loss of access to your data is detrimental for your company, its reputation, its productivity and its sustainability.

IT teams have been able to deploy effective solutions to counter traditional data and database risks, but are they ready to face these new threats?

Predefined Autonomous Databases Role

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.

For more details please refer to the below link:

Ref:

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-EC14B465B873

Default AWR retention period for Autonomous Database

AWR retention period for Autonomous Database

The default eight-day retention period for Autonomous Database performance data can be modified using
MODIFY_SNAPSHOT_SETTINGS subprogram procedure of DBMS_WORKLOAD_REPOSITORY

Be aware that increasing the retention time results in more storage usage for performance data.

For more details, you can refer to the below link:

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3