Hi Conny, Is that a bug? is BMC support aware of this?
Guillaume ________________________________ From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Conny Martin [conny.mar...@t-systems.com] Sent: Monday, November 29, 2010 3:13 PM To: arslist@ARSLIST.ORG Subject: AW: ORACLE Cursor Sharing ** Frank, IMHO this parameter does not have an effect on performance. Somtimes arserverd issues an "alter session set cursor_sharing = exact" for some reason. To reset it back to it's desired value you have to specify it in ar.cfg <SQL > <TID: 1081108800> <RPC ID: 0000013703> <Queue: Fast > <Client-RPC: 390620 > <USER: xxx > /* So Nov 14 2010 08:21:24.2067 */INSERT INTO B233C536870999 (C536870999, entryId) VALUES (:x,'W00000015085672') <SQL > <TID: 1081108800> <RPC ID: 0000013703> <Queue: Fast > <Client-RPC: 390620 > <USER: xxx > /* So Nov 14 2010 08:21:24.2068 */Set LOB into the above row ... <SQL > <TID: 1081108800> <RPC ID: 0000013703> <Queue: Fast > <Client-RPC: 390620 > <USER: xxx > /* So Nov 14 2010 08:21:24.2068 */ALTER SESSION set CURSOR_SHARING = EXACT <SQL > <TID: 1081108800> <RPC ID: 0000013703> <Queue: Fast > <Client-RPC: 390620 > <USER: xxx > /* So Nov 14 2010 08:21:24.2070 */OK <SQL > <TID: 1081108800> <RPC ID: 0000013703> <Queue: Fast > <Client-RPC: 390620 > <USER: xxx > /* So Nov 14 2010 08:21:26.9983 */OK <SQL > <TID: 1081108800> <RPC ID: 0000013703> <Queue: Fast > <Client-RPC: 390620 > <USER: xxx > /* So Nov 14 2010 08:21:26.9983 */ALTER SESSION set CURSOR_SHARING = FORCE Don't know why, but always when inserting an attachment these alter session statements are issued. Kind Regards Conny ________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Frank Caruso Gesendet: Montag, 22. November 2010 19:46 An: arslist@ARSLIST.ORG Betreff: ORACLE Cursor Sharing ** Does anyone know what effect setting the Oracle Cursor Sharing parameter in the ar.cfg has on performance? I understand what cursor sharing is and have it set at the Oracle (database) level but want to know why it needs to be set in the ARS server config file. Thank you, _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"