Hello everybody,
please i am looking where Oracle database stores information about used DOP (degree of parallelism) for given query (sql_id). I am interested in both v$ views and awr tables for the old queries. I am able get this information only as a part of the execution plan but i need use it in the SQL statement. In my example DOP is 40 and get this execution plan by executing dbms_xplan.display_cursor.
Any idea please?
Thank you,
Jakub.
| 3 | PX SEND QC (RANDOM) | :TQ10000 | 1 | | | | | Q1,00 | P->S | QC (RAND) |
| 4 | SORT AGGREGATE | | 1 | | | | | Q1,00 | PCWP | |
| 5 | PX BLOCK ITERATOR | | 65440 | 4 (0)| 00:00:01 | 1 | 45 | Q1,00 | PCWC | |
|* 6 | TABLE ACCESS INMEMORY FULL| V_TABLE | 65440 | 4 (0)| 00:00:01 | 1 | 180 | Q1,00 | PCWP | |
-----------------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
6 - inmemory(:Z>=:Z AND :Z<=:Z)
Note
-----
- Degree of Parallelism is 40 because of hint