Wednesday , May 29 2024

Oracle Autonomous Data Warehouse

In today’s article, we will be cover about Oracle Autonomous Data Warehouse Optimizer Statistics Management.

Autonomous Data Warehouse has the ability to automatically collect statistical information for tables added directly on SQL.

For example, optimizer statistics are collected automatically for processes using the DBMS_CLOUD package.

If you have a table that changes using the DML operations we routinely use, you can do the following to gather statistics for those tables.

The example shows the collection of statistics for all tables using the “SH” schema.

However, Autonomous Data Warehous by default ignores the use of optimizer and Parallel hint in SQL statements. In other words, it comes disabled.

If your application uses hint, you need to edit the ” OPTIMIZER_IGNORE_HINTS ” parameter at system or session level.

It can be activated by setting the parameter “FALSE”.


About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

Leave a Reply

Your email address will not be published. Required fields are marked *