********************************************************************************

SQL ID: b52m6vduutr8j Plan Hash: 4234963248

delete from RecycleBin$
where
 bo=:1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        9      0.00       0.00          0          0          0           0
Execute      9      2.50      18.78          0     580835         10           1
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       18      2.50      18.78          0     580835         10           1

Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
         0          0          0  DELETE  RECYCLEBIN$ (cr=64537 pr=0 pw=0 time=2445801 us)
         0          0          0   TABLE ACCESS FULL RECYCLEBIN$ (cr=64537 pr=0 pw=0 time=2445785 us cost=1488 size=34 card=2)

********************************************************************************

SQL ID: 0k8h617b8guhf Plan Hash: 4234963248

delete from RecycleBin$
where
 purgeobj=:1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        4      0.00       0.00          0          0          0           0
Execute      4      1.05       7.77          0     258151          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        8      1.05       7.77          0     258151          0           0

Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
         0          0          0  DELETE  RECYCLEBIN$ (cr=64537 pr=0 pw=0 time=2137032 us)
         0          0          0   TABLE ACCESS FULL RECYCLEBIN$ (cr=64537 pr=0 pw=0 time=2137026 us cost=1489 size=17 card=1)

********************************************************************************