Database DB Id Instance Inst Num Startup Time Release RAC ~~~~~~~~ ----------- ------------ -------- --------------- ----------- --- xxxxxxxxxx xxxxxx 1 21-Feb-11 08:27 10.2.0.4.0 NO Host Name: xxxxxxxxxxxxxx Num CPUs: 8 Phys Memory (MB): 22,526 Load Profile Per Second Per Transaction ~~~~~~~~~~~~ --------------- --------------- Redo size: 76,893.99 72,238.61 Logical reads: 1,901.77 1,786.63 Block changes: 580.57 545.42 Physical reads: 0.72 0.67 Physical writes: 5.73 5.38 User calls: 439.85 413.22 Parses: 131.69 123.71 Hard parses: 0.07 0.07 Sorts: 5.03 4.72 Logons: 0.01 0.01 Executes: 140.72 132.20 Transactions: 1.06 % Blocks changed per Read: 30.53 Recursive Call %: 21.94 Rollback per transaction %: 0.42 Rows per Sort: 186.47 Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time ----------------------------------------- ------------ ----------- ------ ------ enq: TX - row lock contention 482 1,406 2918 96.8 CPU time 42 2.9 db file sequential read 671 2 3 .2 control file sequential read 9,728 1 0 .1 log file parallel write 1,167 0 0 .0 ------------------------------------------------------------- Statistic Time (s) % of DB time ----------------------------------- -------------------- ------------ sql execute elapsed time 1,449.5 99.6 DB CPU 42.5 2.9 PL/SQL execution elapsed time 3.6 .3 parse time elapsed 2.0 .1 hard parse elapsed time 0.4 .0 hard parse (sharing criteria) elaps 0.1 .0 hard parse (bind mismatch) elapsed 0.1 .0 PL/SQL compilation elapsed time 0.0 .0 repeated bind elapsed time 0.0 .0 connection management call elapsed 0.0 .0 sequence load elapsed time 0.0 .0 failed parse elapsed time 0.0 .0 DB time 1,455.1 background elapsed time 2.5 background cpu time 1.4 ------------------------------------------------------------- Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn --------------------------------- ------------ ------ ---------- ------ -------- enq: TX - row lock contention 482 95 1,406 2918 0.5 db file sequential read 671 0 2 3 0.7 control file sequential read 9,728 0 1 0 10.2 log file parallel write 1,167 0 0 0 1.2 log file sync 819 0 0 0 0.9 control file parallel write 433 0 0 0 0.5 db file parallel write 583 0 0 0 0.6 log file switch completion 4 0 0 10 0.0 SQL*Net more data to client 758 0 0 0 0.8 cursor: pin S wait on X 3 100 0 11 0.0 os thread startup 4 0 0 8 0.0 log file sequential read 4 0 0 2 0.0 latch free 1 0 0 7 0.0 SQL*Net break/reset to client 4 0 0 1 0.0 rdbms ipc reply 20 0 0 0 0.0 SQL*Net message from client 291,832 0 8,055 28 304.6 virtual circuit status 30 100 900 30001 0.0 Streams AQ: qmn slave idle wait 32 0 898 28063 0.0 Streams AQ: qmn coordinator idle 65 51 898 13816 0.1 jobq slave wait 42 98 125 2976 0.0 SQL*Net message to client 291,830 0 0 0 304.6 SQL*Net more data from client 70 0 0 0 0.1 ------------------------------------------------------------- Elapsed Elap per CPU Old Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value ---------- ------------ ---------- ------ ---------- --------------- ---------- 1400.31 25 56.01 96.2 0.00 0 196095129 UPDATE LGNCC_LOCK SET LOCKEDBY = :1, LOCKEDDATE = :2 WHERE LOCKA BLE = :3 AND LOCKABLEREF IS NULL