SQL> create or replace procedure p
  2  is
  3    no_such_table_error exception;
  4    pragma exception_init(no_such_table_error, -942);
  5  begin
  6    execute immediate 'select * from no_such_table';
  7  exception
  8    when no_such_table_error
  9    then
 10      null;
 11  end;
 12  /

Procedure created.

SQL>
SQL> exec for i in 1..200 loop p;end loop

PL/SQL procedure successfully completed.

-- alert.log

Thu Aug 29 08:46:53 2019
PDB(3):WARNING: too many parse errors, count=100 SQL hash=0x99f3c1d8
PDB(3):PARSE ERROR: ospid=19966, error=942 for statement:
Thu Aug 29 08:46:53 2019
PDB(3):select * from no_such_table
PDB(3):Additional information: hd=0xbc478320 phd=0xbfb7c040 flg=0x28 cisid=138 sid=138 ciuid=138 uid=138
Thu Aug 29 08:46:53 2019
PDB(3):----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0xbcf507e0         6  procedure TC.P
0xbc185668         1  anonymous block
PDB(3):WARNING: too many parse errors, count=200 SQL hash=0x99f3c1d8
PDB(3):PARSE ERROR: ospid=19966, error=942 for statement:
Thu Aug 29 08:46:53 2019
PDB(3):select * from no_such_table
PDB(3):Additional information: hd=0xbc478320 phd=0xbfb7c040 flg=0x28 cisid=138 sid=138 ciuid=138 uid=138
Thu Aug 29 08:46:53 2019
PDB(3):----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0xbcf507e0         6  procedure TC.P
0xbc185668         1  anonymous block

SQL> create table px1 as select rownum id from xmltable('1 to 1000');

Table created.

SQL> create table px2 pctfree 99 as select rownum id, cast('x' as char(100)) pad from xmltable('1 to 5000');

Table created.

SQL>
SQL> select /*+ monitor
  2             no_unnest(@inner)
  3          */
  4         count(id)
  5    from px1
  6   where not exists (
  7           select /*+ qb_name(inner) parallel(px2 4)*/
  8                  null
  9             from px2
 10            where id = px1.id);

 COUNT(ID)
----------
         0

SQL>
SQL> select dbms_sqltune.report_sql_monitor(session_id=> sys_context('userenv', 'sid')) from dual;

DBMS_SQLTUNE.REPORT_SQL_MONITOR(SESSION_ID=>SYS_CONTEXT('USERENV','SID'))
---------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Monitoring Report

SQL Text
------------------------------
select /*+ monitor no_unnest(@inner) */ count(id) from px1 where not exists ( select /*+ qb_name(inner) parallel(px2 4)*/ null from px2 where id = px1.id)

Global Information
------------------------------
 Status              :  DONE (ALL ROWS)
 Instance ID         :  1
 Session             :  TC (54:35537)
 SQL ID              :  fr4s51y9frf36
 SQL Execution ID    :  16777236
 Execution Started   :  08/29/2019 10:01:51
 First Refresh Time  :  08/29/2019 10:01:51
 Last Refresh Time   :  08/29/2019 10:02:43
 Duration            :  52s
 Module/Action       :  SQL*Plus/-
 Service             :  pdb
 Program             :  sqlplus.exe
 Fetch Calls         :  1

Global Stats
========================================================================================================
| Elapsed |   Cpu   |    IO    | Application | Concurrency |  Other   | Fetch | Buffer | Read  | Read  |
| Time(s) | Time(s) | Waits(s) |  Waits(s)   |  Waits(s)   | Waits(s) | Calls |  Gets  | Reqs  | Bytes |
========================================================================================================
|      20 |    2.30 |       15 |        0.01 |        0.00 |     3.06 |     1 |   429K | 11583 |   4GB |
========================================================================================================

Parallel Execution Details (DOP=4 , Servers Allocated=1604)
================================================================================================================================================================
|      Name      | Type  | Server# | Elapsed |   Cpu   |    IO    | Application | Concurrency |  Other   | Buffer | Read  | Read  |        Wait Events         |
|                |       |         | Time(s) | Time(s) | Waits(s) |  Waits(s)   |  Waits(s)   | Waits(s) |  Gets  | Reqs  | Bytes |         (sample #)         |
================================================================================================================================================================
| PX Coordinator | QC    |         |      20 |    2.27 |       14 |        0.01 |        0.00 |     3.06 |   424K | 11450 |   4GB | PX Deq: Signal ACK EXT (2) |
|                |       |         |         |         |          |             |             |          |        |       |       | direct path read (15)      |
| p000           | Set 1 |       1 |    0.15 |    0.01 |     0.14 |             |             |     0.00 |   1290 |    32 |  10MB | direct path read (28)      |
| p001           | Set 1 |       2 |    0.15 |    0.01 |     0.14 |             |             |          |   1203 |    36 |   9MB | direct path read (30)      |
| p002           | Set 1 |       3 |    0.15 |    0.01 |     0.15 |             |             |          |   1184 |    31 |   9MB | direct path read (27)      |
| p003           | Set 1 |       4 |    0.15 |    0.01 |     0.15 |             |             |          |   1275 |    34 |  10MB | direct path read (25)      |
================================================================================================================================================================

SQL Plan Monitoring Details (Plan Hash Value=2622980363)
=============================================================================================================================================================
| Id |        Operation         |   Name   |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Read  | Read  | Activity |      Activity Detail       |
|    |                          |          | (Estim) |      | Active(s) | Active |       | (Actual) | Reqs  | Bytes |   (%)    |        (# samples)         |
=============================================================================================================================================================
|  0 | SELECT STATEMENT         |          |         |      |         1 |    +52 |     1 |        1 |       |       |          |                            |
|  1 |   SORT AGGREGATE         |          |       1 |      |         1 |    +52 |     1 |        1 |       |       |          |                            |
|  2 |    FILTER                |          |         |      |        51 |     +2 |     1 |        0 |       |       |     1.46 | PX Deq: Signal ACK EXT (2) |
|  3 |     TABLE ACCESS FULL    | PX1      |    1000 |    3 |        51 |     +2 |     1 |     1000 |     1 | 16384 |          |                            |
|  4 |     PX COORDINATOR       |          |         |      |        51 |     +2 |  2600 |     1000 |       |       |          |                            |
|  5 |      PX SEND QC (RANDOM) | :TQ10000 |       1 |  383 |        53 |     +0 |  2199 |      400 |       |       |          |                            |
|  6 |       PX BLOCK ITERATOR  |          |       1 |  383 |        53 |     +0 |  2199 |      999 |       |       |          |                            |
|  7 |        TABLE ACCESS FULL | PX2      |       1 |  383 |        53 |     +0 | 12752 |      999 | 11597 |   4GB |    98.54 | Cpu (10)                   |
|    |                          |          |         |      |           |        |       |          |       |       |          | direct path read (125)     |
=============================================================================================================================================================