I've no experience with Peoplesoft and Oracle 9, but ..
Try setting the following parameters
optimizer_features_enable = 8.1.6
As I recall this prevented Oracle from incorrectly tossing out some subselects. I'm
not sure if it is even valid in 9iR2
_ignore_desc_in_index = TRUE
Not setting
While I am waiting for oracle support to respond to my tar update (2nd
callback) I am just wondering if anybody has found this problem.
We have the following select query (from a peoplesoft implementation)
SELECT a.emplid, a.effdt
FROM PS_JOB A
WHERE A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_JOB
Title: RE: possible Bug in Oracle 9.2.0.2
You it is a bug
alter session|system set _unnest_subquery=false
/
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
QOTD: Any clod can have facts, having an opinion is an art
!
-Original Message- From:
Browett, Darren [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 06, 2003 7:34 PM To: Multiple recipients of list ORACLE-L Subject: possible Bug in Oracle 9.2.0.2
While I am waiting for orac
Did you open an iTar with Oracle? If so, what severity was it logged at? How
you answer certain questions on the iTAR form will impact the severity of
the tar, and as a result the time for responses from Oracle.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent:
Can you please list select emplid, empl_rcd, effdt, effseq, empl_status
from ps_job where emplid = '3442'
At 03:34 PM 8/6/2003 -0800, you wrote:
While I am waiting for oracle support to respond to my tar update (2nd
callback) I am just wondering if anybody has found this problem.
We have the
Title: Message
I
already have :)
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday,
August 07, 2003 12:04 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: possible Bug in Oracle
9.2.0.2
Tell them ...
Raj
!
-Original Message-From: Browett, Darren
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 2:49
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
possible Bug in Oracle 9.2.0.2
That
fixed it, thank you.
I
still haven't heard from oracle support yet