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 ho
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 s
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
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:
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, Mla
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.2
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
You need Rdb (Oracle's other database) for that to work:
eg:
SQL> seelct count(*) from pot;
%SQL-I-SPELLCORR, identifier SEELCT replaced with SELECT
334
1 row selected
SQL> show version
Current version of SQL is: Oracle Rdb SQL V7.1-101
Underlying versions are:
Database with filenam
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
> p
lease respond 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, t
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
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 "FOR
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,
W
d 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 ORACLE-L <[EMAIL PROTE
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 7
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
EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/21/2003 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: HP-UX 11i/9.2.0.3/Strange Executions
Hi Everyone!
HELP!
I upgraded my SAP *PRODUC
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
parame
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 Mes
lease respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:HP-UX 11i/9.2.0.3/Strange Executions
Hi Everyone!
HELP!
I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend.
Everything up until n
chael (TEM)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/21/2003 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: HP-UX 11i/9.2.0.3/Strange Executions
Hi Everyone!
HELP!
I
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
cipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: HP-UX 11i/9.2.0.3/Strange Executions
Hi Everyone!
HELP!
I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend.
Everything up until now has been OK. However, I now have some
SAP Transactions (
Hi Everyone!
HELP!
I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend.
Everything up until now has been OK. However, I now have some
SAP Transactions (read: data entry forms) that are abending
unexpectedly.
What's strange is that when we run the transaction on our Stage
server
24 matches
Mail list logo