Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> does parse time cpu account for library cache waits?

does parse time cpu account for library cache waits?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 20 Mar 2003 16:15:19 GMT
Message-ID: <3e79e5a4.2070544755@nyc.news.speakeasy.net>


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
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Mar 20 2003 - 10:15:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US