Execution Plans, Hints and Outlines in Oracle 18c

Today's post is about execution plans. This quick example using the HR sample schema, highlights the importance of using SQL Hints to influence the execution path.Let me use below SQL as an example:SELECT     COUNT(*)FROM    hr.employees a,    hr.departments b,    hr.locations cWHERE    a.department_id = b.department_id    AND b.location_id = c.location_id    AND a.salary > 3000    AND c.postal_code IS… Continue reading Execution Plans, Hints and Outlines in Oracle 18c

EBS ADOP Phase Failing Due to ORA-600 Error

There’s an issue in EBS 12.2 and database 12.1.0.2 versions related to Materialized Views. While executing ADOP (prepare, apply, finalize or cutover) phases, the cycle could fail due to an ORA-600 : internal error code, arguments: [kqllod:no stub for dependency parent] error.After working with Oracle, they provided information about BUG 27883586 related to MView Refresh or… Continue reading EBS ADOP Phase Failing Due to ORA-600 Error

OEM 13c Reporting Incorrect Tablespace Space Usage (%) After July 2018 PSU

The topic for today is Tablespace monitoring. OEM 13c started reporting inaccurate values for the Space Usage (%) metric after applying either the April 2018 or the July 2018 Database PSU's. The way this was detected, is that OEM 13c Corrective Actions started firing here and there after the patches. Oracle confirmed this is tracked… Continue reading OEM 13c Reporting Incorrect Tablespace Space Usage (%) After July 2018 PSU

RMAN Recovery Catalog Issues after 12.2 Upgrade

Well, after the upgrade of the DB to 12.2 the next step is to upgrade the RMAN Recovery Catalog to the same version in order to be able to run backups using it. The process is pretty straight forward..    Connect to RMAN using target and catalog.    Execute upgrade catalogRMAN> upgrade catalog;This finishes correctly. But then… Continue reading RMAN Recovery Catalog Issues after 12.2 Upgrade

Exadata/Exacloud CellServer health using AWR report

Exadata’s unique sauce relies on the fact that the DB instance can offload work to the CellServers to speed up I/O bound queries. But how do you monitor the health of the CellServers?A quick and dirty way, especially if you don’t have access to the CellServers is to use AWR in a database that’s currently… Continue reading Exadata/Exacloud CellServer health using AWR report

Exalogic Agents being automatically deleted from OEM 13c

Oracle Enterprise Manager (OEM) 13c is capable of monitoring virtual guest hosts running on Exalogic (virtual configuration). OEM will connect (read-only) to the Oracle VM Manager and get the configuration and status of the VM’s running there. Then you can deploy an agent to those VM hosts and you have a complete monitoring solution for… Continue reading Exalogic Agents being automatically deleted from OEM 13c

How To Connect To The Oracle Cloud DB Instance?

In my previous post (How To Create An Oracle Cloud Instance) I showed you create your first Oracle Cloud DB instance. Now that the instance is there the question is, how to connect to it?Let's say you want to connect using SQL Developer to start creating objects and inserting data. First you need to enable… Continue reading How To Connect To The Oracle Cloud DB Instance?