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
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
Title: Message
That
fixed it, thank you.
I
still haven't heard from oracle support yet.
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday,
August 07, 2003 4:44 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: possible Bug
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