mikaelronstrom

NDB Parallel Query, part 5

In this part we are going to analyze a bit more complex query than before.This query is a 6-way join.The query is:SELECT        supp_nation,        cust_nation,        l_year,        SUM(volume) AS revenueFROM        (                SELECT                        n1.n_name AS supp_nation,                        n2.n_name AS cust_nation,                        extract(year...

blog.dbi-services.com blog.dbi-services.com

Elapsed time of Oracle Parallel Executions are not shown correctly in AWR

As the elapsed time (time it takes for a task from start to end, often called wall-clock time) per execution of parallel queries are not shown correctly in AWR-reports, I thought I setup a testcase to find a way to get an elapsed time closer to reality. REMARK: To use AWR (Automatic Workload Repository) and ASH (Active Session History) as described in this Blog you need to have the Oracle Diagnostics Pack licensed. I created a table...