Parallel and QBname
From: Moustafa Ahmed <moustafa_dba_at_hotmail.com>
Date: Sat, 16 Jan 2021 18:08:30 +0000
Message-ID: <BN6PR06MB27853221A175778621454028E1A60_at_BN6PR06MB2785.namprd06.prod.outlook.com>
Hello folks
--
http://www.freelists.org/webpage/oracle-l Received on Sat Jan 16 2021 - 19:08:30 CET
Date: Sat, 16 Jan 2021 18:08:30 +0000
Message-ID: <BN6PR06MB27853221A175778621454028E1A60_at_BN6PR06MB2785.namprd06.prod.outlook.com>
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 Received on Sat Jan 16 2021 - 19:08:30 CET