Oracle-L: Cursor_space_for

From: Arun Chakrapanirao <ArunC_at_1800FLOWERS.com>
Date: Thu, 26 Dec 2002 12:39:03 -0800
Message-ID: <F001.00522893.20021226123903@fatcity.com>

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: ArunC_at_1800FLOWERS.com

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: ListGuru_at_fatcity.com (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). Received on Thu Dec 26 2002 - 14:39:03 CST

Cursor_space_for_time