Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> does parse time cpu account for library cache waits?
trying to convince developers to use binds more :)
it turns out the database is spending 10%+ of CPU just parsing:
CPU used by this session 59,509,459 parse time cpu 7,048,429
here are related library cache waits:
select event, total_waits, total_timeouts, average_wait from v$system_event
library cache pin 182269 1126 3.29589782 library cache lock 27791 26112 294.223418 library cache load lock 12471 4599 124.732179.......