10gR4 will modify payroll and send me the check.
Jared
On Monday 21 July 2003 19:39, Mladen Gogala wrote:
10gR3 will read programmer's mind and automatically correct all design
errors. RDBMS 11T will look like Arnie Schwartzenegger (T is for
Terminator). I'll be back.
On 2003.07.21 22:04,
Hopefully, not a pink one?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 22, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
10gR4 will modify payroll and send me the check.
Jared
On Monday 21 July 2003 19:39,
Color may be irrelevant, depending on amount.
Gogala, Mladen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/22/2003 12:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: HP-UX 11i/9.2.0.3
Jared,
With your luck the check you refer to will be like the ckeck in a
restaurant. Don't forget the tip.
Ron
[EMAIL PROTECTED] 07/22/03 03:34PM
Hopefully, not a pink one?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July
Ok you guys...
Here's the latest on the 'real' subject of this thread.
You know what an explain plan looks like, right? On our
production DB, it looked like
SELECT STATEMENT CHOOSE
SORT GROUP BY
TABLE ACCESS BY INDEX ROWID
INDEX RANGE SCAN
Ok...so far so what, right? Well, on our
Metalink has a note that the INLIST ITERATOR may cause problems on certain platforms.
That's about as much detail as it offers.
I don't know the internal workings of II, but I suspect there is some sort of merging
occuring after each (or all) iterations. Perhaps someone on the list can explain
SIGSEGV = Segment Violation = invalid address = bad code
Sounds like you need to contact SAP and/or Oracle support.
Jared
Vergara, Michael (TEM) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/21/2003 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions
Most likely some thing to do with OS library. contact OWS.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
He needs to contact oracle support, because the dump came from the
oracle server process. If he's lucky, the one-off patch is already published
and he only needs to download it from Metalink and apply it. If not,
then he has to wait for oracle 9BF (BF = Bug Free)
Mladen Gogala
Oracle DBA
Jared:
I am in contact with SAP support, but they're scratching
their collective heads, too. I was hoping that maybe a
SAP-savvy lister would be able to say We had that...here's
the fix.
What's strange is that the report runs to completion on our
Stage server.
Thanks,
Mike
-Original
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions
Raj:
Is OWS 'Oracle Worldwide Support'? Our Oracle
support
comes directly from SAP, and they're on the case, but
are as flummoxed as I am. Right now they're trying
to
convince me that the problem is in the NLS
parameters.
However, these values
Oh no! I have to wait for 9iBF? I'll be retired by
then, and I'm only ... well ... never mind how old
I am. I don't wanna wait that long.
Cheers,
Mike
-Original Message-
Sent: Monday, July 21, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L
He needs to contact oracle support,
Ron:
According to the ABAP programmers, the code 'variant' is
identical. The generated SQL 'looks' the same, but the
execution plans are radically different.
Thanks,
Mike
-Original Message-
Sent: Monday, July 21, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L
Is or are ALL of
Michael,
When you say 'different execution plans', what are the differences? Is the
choice in execution plans causing the ORA-07445? If so, why are the execution plans
different (there has to be a reason)? Statistics, parameters, etc. will alter the
execution plan choices.
The
Actually, I'm quite unaware of ORA-07745 as an execution plan. Can EXPLAIN
PLAN
foretell the error?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Monday, July 21, 2003 6:20 PM
To: Multiple recipients of list ORACLE-L
Michael,
Okay, so its Monday...
What I meant to say is that are the queries with different execution plans the ones
encountering 7445s. If there is a common thread in the execution plans (i.e. hash join
instead of nested loops), then the hj may be triggering the 7445s.
Actually, 10g will have a new
Metalink: 241160.1 ALERT: ORA-7445 Signalled from Different Functions on 64-bit HP-UX.
Versions 9.2.0.2 and 9.2.0.3
-Original Message-
From: Daniel Fink [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 6:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: HP-UX 11i
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: HP-UX 11i/9.2.0.3/Strange Executions
He needs to contact oracle support, because the dump came from the
oracle server process. If he's lucky, the one-off patch is already
10gR2 will automatically correct the errors.
I'm waiting for the version that will know that I *meant* to type
select when I actually type seelct
--- Daniel Fink [EMAIL PROTECTED] wrote:
Okay, so its Monday...
What I meant to say is that are the queries with different execution
plans the
10gR3 will read programmer's mind and automatically correct all design
errors. RDBMS 11T will look like Arnie Schwartzenegger (T is for
Terminator). I'll be back.
On 2003.07.21 22:04, Rachel Carmichael wrote:
10gR2 will automatically correct the errors.
I'm waiting for the version that will
20 matches
Mail list logo