Re: Database cursor sharing

2008-04-10 Thread William Rentfrow
Worthington Sent: Wed 4/9/2008 2:09 PM To: arslist@ARSLIST.ORG Subject: Re: Database cursor sharing ** Sorry -- I usually reference my source. :-) Guess I wasn't thinking rtfm... lol White Paper Oracle's Cursor Sharing for BMC® Remedy® Products January 2007 *67831* -- Tony Wort

Re: Database cursor sharing

2008-04-09 Thread Tony Worthington
entfrow <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 04/09/2008 01:50 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Database cursor sharing ** I'm checking this...what document is this from? The server

Re: Database cursor sharing

2008-04-09 Thread William Rentfrow
t: Re: Database cursor sharing ** Strange that it would alter to both exact and force when having the system set to force in one operation. Are you seeing the alter sessions right next to each other or are there various inserts in between? Exact is used when inserting into long raw. Have you ver

Re: Database cursor sharing

2008-04-09 Thread Tony Worthington
L PROTECTED] 262-703-5911 William Rentfrow <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 04/09/2008 01:15 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Database cursor sharing We have two systems - both on

Database cursor sharing

2008-04-09 Thread William Rentfrow
We have two systems - both on Solaris logical servers, both on the same box. Both have remote Oracle databases. (7.1 001 for Solaris w/Oracle, IM 7.03) Dev = faster response time (saving an Incident takes 9 seconds) QA = very slow response time (saving an Incident takes 65 seconds). These two