gc wait events
-
I have a 10.2.0.4 RAC database, I have traced a session which is doing serveral inserts, and the tkprof files reports the next:
INSERT INTO BS_PAYS_DETAIL (tz_lock, SALDOS_JTS_OID, HP_JTS_OID, CUOTA,
VENCIMIENTOCUOTA, NROASIENTOMOV, FECHAPROCESOMOV, FECHAVALOR, CAPITALPAGADO,
INTERESPAGADO, INTERESRECALCULADO, CAPITALADELANTADO, MORAPAGADA,
BONIFICACION, IVAAPLICADO, SUCURSALSALDO, SUCURSALMVTO, RELACIONCAPIVA)
VALUES
(:1, :2, , :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17,
:18)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 22613 0.30 0.32 0 0 0 0
Execute 22614 47.57 261.49 124 140436 304802 22614
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 45227 47.87 261.82 124 140436 304802 22614
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 147 (TOPAZ)