Parallel Execution 12c New Features Overview
Oracle 12c is the first release since a couple of years that adds significant new functionality in the area of Parallel Execution operators
, plan shapes
and runtime features
. Although 11gR2 added the new Auto DOP
feature along with In-Memory Parallel Execution
and Statement Queueing
, the 12c features are more significant because they introduce new operators that can change both execution plan shape and runtime behaviour.
Here is (more...)
Thanks everyone who attended my recent webinar at AllThingsOracle.com
The link to the webinar recording can be found here
The presentation PDF can be downloaded here
. Note that this site uses a non-default HTTP port, so if you're behind a firewall this might be blocked.
Thanks again to AllThingsOracle.com and Amy Burrows for hosting the event.
The next part of the video tutorial explaining the XPLAN_ASH Active Session History functionality has been published. In this part I begin the actual walk-through of the script output.
More parts to follow.
A new version 4.21 of the XPLAN_ASH utility is available for download. I publish this version because it will be used in the recent video tutorials explaining the Active Session History functionality of the script.As usual the latest version can be downloaded here.
This is mainly a maintenance release that fixes some incompatibilities of the 4.2 version with less recent versions (10.2 and 184.108.40.206).
As an extra however, (more...)
It's webinar time again.
Join me on Wednesday, January 28th at AllThingsOracle.com
for a session based on a real world customer experience.
The session starts at 3pm UK (16:00 Central European) time. The webinar is totally free and the recording will made available afterwards.
Here's the link to the official landing page
where you can register and below is the official abstract:
After a short introduction into what the Oracle Exadata Database Machine (more...)
I finally got around preparing another part of the XPLAN_ASH video tutorial.
This part is about the main funcationality of XPLAN_ASH: SQL statement execution analysis using Active Session History and Real-Time SQL Monitoring.
In this video tutorial I'll explain what the output of XPLAN_ASH is supposed to mean when using the Active Session History functionality of the script. Before diving into the details of the script output using sample reports I provide some overview and (more...)