Re: Parallel and QBname

PARALLEL() is a statement level or object level hint, not a query block hint.

We can't see your query or the definitions of any tables of views used in your query so we can't tell you why you're seeing so many Unused parallel hints, or why 8 is the degree of parallelism reported. I haven't seen any notes anywhere explaining why the parallel() hint never seems to get into the Outline Information, but possibly it's a deliberate choice aimed at encouraging people to enable automatic parallelism.

If you want to create a baseline, patch, or profile with a "parallel" hint in it you'll probably have to use SHARED(...) rather than PARALLEL(...)

Regards
Jonathan Lewis

<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sat, 16 Jan 2021 at 18:09, Moustafa Ahmed <moustafa_dba_at_hotmail.com> wrote:

> Hello folks
>
> Running dbms_xplan.display_cursor with advanced options on a sql running
> with parallel slaves I can see as you know “Outline Data” and QBnames..
>
>
> 1-I know the sql is running in parallel.
>
> 2-I see “PQ_DISTRIBUTE_WINDOW”, “PQ_DISTRIBUTE” in outline data.
>
> 3-no related parallel variables in “OPT_PARAM”.
>
> 4-hint report part shows
>
>
>
> Hint Report (identified by operation id / Query Block Name / Object Alias):
>
> Total hints for statement: 6 (U - Unused (5))
>
> ---------------------------------------------------------------------------
>
>
>
> 0 - STATEMENT
>
> U - PARALLEL(8) / duplicate hint
>
> U - PARALLEL(8) / duplicate hint
>
> U - PARALLEL(8) / duplicate hint
>
> U - PARALLEL(8) / hint overridden by another in parent query
> block
>
> U - PARALLEL(8) / hint overridden by another in parent query
> block
>
> - PARALLEL(8)
>
>
>
>
>
>
>
> 1-Why I can not see a “Query Block” with the parralele hint and its degree?
>
> 2-what should I do If want to inject the same parralel hint with same
> degree on same qb?
>

--
http://www.freelists.org/webpage/oracle-l