Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Load Profile
- ~~~~~~~~~~~~ Per Second Per Transaction
- --------------- ---------------
- Redo size: 5,866,486.08 52,784,835.36
- Logical reads: 209,979.50 1,889,330.92
- Block changes: 29,456.22 265,038.02
- Physical reads: 9,762.53 87,840.20
- Physical writes: 769.60 6,924.59
- User calls: 44.41 399.62
- Parses: 13.74 123.60
- Hard parses: 0.30 2.74
- Sorts: 1,093.89 9,842.48
- Logons: 0.22 2.01
- Executes: 293.96 2,644.94
- Transactions: 0.11
- Top 5 Timed Events Avg %Total
- ~~~~~~~~~~~~~~~~~~ wait Call
- Event Waits Time (s) (ms) Time Wait Class
- ------------------------------ ------------ ----------- ------ ------ ----------
- CPU time 127,946 44.0
- db file sequential read 113,295,053 72,035 1 24.8 User I/O
- PX Deq Credit: send blkd 3,726,822 19,724 5 6.8 Other
- db file scattered read 11,366,232 7,073 1 2.4 User I/O
- db file parallel write 2,375,276 4,830 2 1.7 System I/O
- Statistic Name Time (s) % of DB Time
- ------------------------------------------ ------------------ ------------
- sql execute elapsed time 291,764.0 100.4
- DB CPU 127,946.2 44.0
- RMAN cpu time (backup/restore) 19,875.9 6.8
- PL/SQL execution elapsed time 2,682.0 .9
- parse time elapsed 756.0 .3
- hard parse elapsed time 728.7 .3
- failed parse elapsed time 157.0 .1
- repeated bind elapsed time 39.6 .0
- connection management call elapsed time 16.7 .0
- PL/SQL compilation elapsed time 5.6 .0
- hard parse (sharing criteria) elapsed time 1.0 .0
- sequence load elapsed time 0.6 .0
- hard parse (bind mismatch) elapsed time 0.2 .0
- inbound PL/SQL rpc elapsed time 0.0 .0
- DB time 290,620.2 N/A
- background elapsed time 31,021.8 N/A
- background cpu time 24,848.6 N/A
- Operating System Statistics
- Statistic Total
- -------------------------------- --------------------
- AVG_BUSY_TIME 1,377,415
- AVG_IDLE_TIME 1,499,266
- AVG_IOWAIT_TIME 0
- AVG_SYS_TIME 371,584
- AVG_USER_TIME 1,004,968
- BUSY_TIME 11,026,010
- IDLE_TIME 12,000,775
- IOWAIT_TIME 0
- SYS_TIME 2,979,492
- USER_TIME 8,046,518
- LOAD 6
- OS_CPU_WAIT_TIME 621,800
- RSRC_MGR_CPU_WAIT_TIME 0
- VM_IN_BYTES 4,155,031,552
- VM_OUT_BYTES 0
- PHYSICAL_MEMORY_BYTES 17,099,546,624
- NUM_CPUS 8
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement