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||''||BU 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: Arun Chakrapanirao 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).