Your problem is probably the large number of parses that seem to be happening. Also the stats have no meaning here if you don't tell us over what time period they have been collected.
Anjo. On Thursday 26 December 2002 12:39, Arun Chakrapanirao wrote: > Hi, > Has any enabled cursor_Space_for_time=true in your databases,IF yes have > you faced any issues,Cause we are facing lots of contention on latch free > for library cache issue and one of the main culprit is that SYSDATE FROM > DUAL,Just wondering if we enable this parameter will it by some chance be > able reduce the contention. > Or is there any other way you people who might have been facing like these > kind of issues are able to sort it out in any other way > > SQL_TEXT||''||LOADS||''||EXECUTIONS||''||PARSE_CALLS||''||DISK_READS||''||B >U FFER_GETS||' '||ROWS_PROCESSED > --------------------------------------------------------------------------- >- ---- > SELECT USER FROM SYS.DUAL 2 57825830 888196 0 75584 57822907 > > > > SELECT PHONE_EXTENSION,ANI,DNIS,MESSAGE_TYPE,MESSAGE_SUB_TYPE > FROM ATS_CTI_IN WHERE AGENT_ID = :b1 AND STATUS = 'A' > AND MESSAGE_TYPE = '0604' AND MESSAGE_SUB_TYPE = '0010' > FOR UPDATE OF STATUS NOWAIT > > LOADS||''||EXECUTIONS||''||PARSE_CALLS||''||DISK_READS||''||BUFFER_GETS||'' >| > > |R > > --------------------------------------------------------------------------- >- ---- > 1 11181720 1206070 588283 -1807011658 1204738 > > > LATCH_WHERE_AND_LABEL COUNT(0) > -------------------------------------------------- ---------- > kglpnc: child[child] 1063 > kqreqd: rel enqueue[] 1117 > kglhdgn: child:[latch] 2227 > kgllkdl: child: cleanup[latch] 3743 > kcbrls: kslbegin[buffer DBA] 4053 > kglpnal: child: before processing[latch] 4780 > kglupc: child[child] 5182 > > > Please let me know > Thanks in Advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
