Long Parse Time For a SQL When Using The Parallel Hint (Doc ID 2907509.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Long parse time for a SQL

Slow query when using the parallel hint

Removing the parallel hint get the query to run faster.

SQL> @../../../run_the_slow_parsing_query_without_parallel_hint.sql

no rows selected

Elapsed: 00:00:01.87 <<<< elapsed time is almost 2 seconds

Using the parallel hint raises the elapsed time to 273 seconds


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 271.00 271.48 0 0 0 0 <<<<<<<<
Execute 1 0.00 0.10 0 53 2 0
Fetch 1 0.02 1.46 0 2 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 271.02 273.05 0 55 2 6

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.