Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: latch free - library cache

RE: latch free - library cache

From: Michael Wu <>
Date: Wed, 28 May 2003 14:09:42 -0800
Message-ID: <>


With Oracle, I got one of the following three problems when CF=F or S.

1) ORA-03113: end-of-file on communication channel
2) ORA-01802: Julian date is out of range
3) performance problems.

My previous statement is still valid.    

-----Original Message-----

Sent: Thursday, May 15, 2003 2:52 PM
To: Multiple recipients of list ORACLE-L

Send it to me ... I have it CS=F working on all of my 5 production RAC instances 9202 with 5 patches (for various reasons). XML/JAMA/Intermedia/CLOBS ... you name it, we have it.

ps: what are the problems you are facing?


Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----

Sent: Thursday, May 15, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L

If somebody can make CURSOR_SHARING = SIMILAR|FORCE to work even with 9iR2 (with the latest patch), I am willing to give him $1000.

-----Original Message-----

Sent: Thursday, May 15, 2003 9:42 AM
To: Multiple recipients of list ORACLE-L

Cursor sharing set to FARCE forces constants to be converted into bind variables and enables SQL statements to be shared even if the're not identical. It also enables quite a few very interesting ora-0600 and ora-7445 errors that have very good applications in a DSS environment. It will work properly in Oracle 19zR20 and not in oracle 9iR2. Plase, de patient. Your money is very important to us.

This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege.

Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer.

Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities.

Please see the official ORACLE-L FAQ:
Author: Michael Wu

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message to: (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 Wed May 28 2003 - 17:09:42 CDT

Original text of this message