RE: CURSOR_SPACE_FOR_TIME
Do you have the bug number? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 11:55 AM To: Multiple recipients of list ORACLE-L We are ran into a bug the other day where oracle dumps core with a ORA-07445 error. We tracked it down to a Context related bug where PL/SQL callout during heavy shared pool load cause the ora-07745 core dump. The suggested workarounds are to set CURSOR_SPACE_FOR_TIME to true. This is in 8.1.7.4.0 and is reportedly fixed in 9i. What are listers experience with this parameter? On our system it sound like setting this without altering the size of the shared pool would be potentially dangerous and could cause more problems that leaving it alone. This error is not a critical one to business functions and users here. (so far) Thanks Brad Odland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen 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).
CURSOR_SPACE_FOR_TIME
We are ran into a bug the other day where oracle dumps core with a ORA-07445 error. We tracked it down to a Context related bug where PL/SQL callout during heavy shared pool load cause the ora-07745 core dump. The suggested workarounds are to set CURSOR_SPACE_FOR_TIME to true. This is in 8.1.7.4.0 and is reportedly fixed in 9i. What are listers experience with this parameter? On our system it sound like setting this without altering the size of the shared pool would be potentially dangerous and could cause more problems that leaving it alone. This error is not a critical one to business functions and users here. (so far) Thanks Brad Odland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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).
Re: Cursor_space_for_time
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).
Cursor_space_for_time
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).
