recipients of list ORACLE-L
Subject: Re: WARNING: CURSOR_SHARING=FORCE on 8.1.7
I think I need to have a chat with Kevin when I see him at the NYOUG
meeting...
I'm on 8.1.6 and have been using CURSOR_SHARING=FORCE for about a
year. No
problems. Admittedly, we don't do too many
Eeeek! It just keeps getting worse! Can someone on 8.1.7.x on a NON-HP
platform using CURSOR_SHARING=FORCE and CBO at the system level try the
following test for me?
--
DROP TABLE REJ_TEST CASCADE CONSTRAINTS ;
CREATE TABLE REJ_TEST (
ACCESSCONTROLID NUMBER (10)
Title: RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Eeeek! It just keeps getting worse! Can someone on 8.1.7.x
on a NON-HP
platform using CURSOR_SHARING=FORCE and CBO at the system
level try the
following test
It also causes ORA 600's, it was supposed to be fixed in Patch 8..1.7.1.. I
believe.
KK
-Original Message-
Sent: Tuesday, August 21, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L
Although it works for me under Oracle 8.1.7.1.4 on Win/2K as shown below, I
do have doubts about
Hi all,
Just thought I'd share an experience (ON-TOPIC!) with everyone. After
upgrading from 8.0.6 to 8.1.7 on HP/UX 11.0, we've had a few problems with
CURSOR_SHARING=FORCE. The reason I decided to use it is because our apps
don't use bind variables and I wanted to decrease the size of our
Hey Jon,
We're on 8.1.7.1.0. And as luck would have it, 8.1.7.2.0 came out THE DAY
AFTER our upgrade, so I dunno if it appears there.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original
: CURSOR_SHARING=FORCE on 8.1.7
Hey Jon,
We're on 8.1.7.1.0. And as luck would have it, 8.1.7.2.0 came out THE DAY
AFTER our upgrade, so I dunno if it appears there.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International