Re: New TPC benchmarks

Yes, both DB2, SQL Server and Oracle arrive in special editions for these benchmarks. Note also that no indexes are used - Oracle uses hash clusters, for instance. No indexes in sight. Just like certain large customers are running special versions of the Oracle RDBMS, by the way. So it's all ab

Re: connection pooling from an application server to oracle

I agree that the implementation of a connection pool is dependent on the app server, which for various reasons, might choose not to use the connection pool inherent in the programming interface, whether it's OCI or JDBC. One reason may be that the app server already has its own connection pool

RE: OT - RE: Re: Who are certified Oracle Masters?

Woooh . waiting for ROTK here too ;) The execs finally let Peter Jackson show the full version in the Cinema …. See.. even in the Movie Biz, damagement rears it’s ugly head …..     -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dr

RE: Free Memory in v$sgastat

Hi Mladen, I try to understand 8i, and I am not using MTS, my current understanding is UGA and PGA only exists (I mean in use or in the picture) when you are using MTS. Oracle themselves said "'free memory' are more properly thought of as wasted space" I just wondering why this million dollar R

Re: connection pooling from an application server to oracle

I didn't reply to Vadim because I'm not a developer and I have no idea how appservers work. You say that as of 9i application servers can use OCCI multiplexing. Isn't that dependendent on a particular app server? I was talking about iPlanet 6.5 because that is the last version that I have some

Re: Free Memory in v$sgastat

Sinardy, you've attended wrong database tuning course. You need free memory in your shared pool. There is no such thing as "sga fragmentation" unless there is not enough free memory to satisfy average request. While oracle is not monitoring the size of an average shared pool request. you have t

Free Memory in v$sgastat

Hi all,   Why free memory in v$sgastat is a symptom of the fragmentation?   Why these "free memory" are more properly thought of as wasted space?       Thanks   Sinardy

Re: Re: New TPC benchmarks

what's really helpful about these, are the server tweaks made (if you deploy on win32).   check out http://www.tpc.org/results/FDR/TPCC/dell_2650_261103_fdr.pdf   Pg 170 - there's a list of all of the services that are disabled/stopped - 24 in all. Pg 224 - the section of the MS diagnostics report

Re: connection pooling from an application server to oracle

From 9i on, application servers can actually make use of the connection pooling and session pooling features within OCI instead of implementing their own. An interesting concept is how the 9i OCI API separates the notion of session pooling from connection pooling. You can have multiple session

RE: 8i pl/sql question

can you return multiple values from a modified version of myfunction(1) ?? If so, then you can replace multiple calls by only one. And no, bulk binds is only within dml/select statements. Raj Rajendra dot Jamadagni

Re: Re: New TPC benchmarks

Nuno,   > The whole thing is an extravagant waste. I beg to differ. When I ask for 2 external storage units of 14 drives apiece (DAS), and they look at me like I obviously have no clue about their intentions of a 3 drive RAID something other than 10 config, a configuration that they can download ju

table partitions

create table aadedupekeys ( file_id number, rundate date, pk number(10), dk varchar2(128), constraint aadedupekeys_pk primary key (file_id,rundate) ) ; Is there anyway to partition a table (above) in months e.g. ('January','Februray'...). I want to use the rundate and lis

Re: OffTopic : sed : Alternate (2,4,6..) replacement

Hello, assuming that you can use GNU sed, than "sed '2~2s/this/that/'" should do what you want. Regards, uwe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Uwe Weber INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San D

OT - RE: Re: Who are certified Oracle Masters?

how scary would it be to arrive at the exam, and the inquisitioner is dressed as Gandalf. Right after he hands out the exam he slams his staff to the floor and screams   "NONE SHALL PASS".   I'm looking forward to the midnight showing of LOTR - ROTK tomorrow night. The movie is 3 hours, 42 minutes

RE: New TPC benchmarks

Mogens, I wanted to clear something up - I keep seeing you post that SANs are slower than direct attached - I've said it before and I'll say it again: simply not true. There is zero, zero, zero reason why a SAN must be slower than a direct attached. In fact, in the fastest benchmark described

Re: Re: New TPC benchmarks

> Mogens Nørgaard <[EMAIL PROTECTED]> wrote: > Today it's only a question of finding a sponsor for the benchmark. > Then > you can break any report. > It's not only today... It's been like that for the last 8 years or so. Basically: "Have $$$? Will win" is the entire philosophy of all this TP

Re: connection pooling from an application server to oracle

> I can imagin single call to allocate more than one connection if more than > one transaction contexts required for this call (although, smartest app > servers and the best databases can optimize even this transaction can be > suspended and then resumed after another transaction commits), but it

RE: Re: Who are certified Oracle Masters?

http://www.oracle.com/education/certification/index.html?dba9i_ocm.html Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Akshay Kumar Sent: Tues

Oracle 9i OCP Upgrade

Hi all, I'm going to give up the exam for oracle 9i OCP upgrade path. Is anybody recently attended the exam 1z0-30?, I would like to hear up some tips about the exams.. How hard it's. I'm preparing with OTN notes, oracle9i new features student guide and other resources. Can anyboday share there

Re: RedHat Advanced Server v3.0, anyone?

Do you mean Oracle attorney actually sued you before??? - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, December 15, 2003 18:34 Subject: RE: RedHat Advanced Server v3.0, anyone? MetaLink is an official Oracl

RE: RedHat Advanced Server v3.0, anyone?

MetaLink is an official Oracle support mechanism for paid subscribers. Please be careful about cutting and pasting documentation from MetaLink into a mailing list.  Quoting parts of a MetaLink document may be OK. Please do not quote entire articles, and *especially* do not cut and paste forum a

OffTopic : sed : Alternate (2,4,6..) replacement

Hi List I need some help on this; How do i replace the 2nd,4th,6th occurances of a column (vertical) in a file. I know sed does it within a row $ cat swt 01:this is a file1 this 02:this is a file1 this 03:this is line3 04:this is line4 $ sed 's/this/that/2' swt 01:this is a file1 that 02:this is

Re: New TPC benchmarks

I love to read the Full Disclosure Reports: "There were 672 x 18GB15krpm HDD Ultra320 HP, 1344 x 36GB15krpm HDD Ultra320 HP and 224 x 146GB 10krpm HDD Ultra320 HP in the benchmarked configuration." FYI: 672+1344+224 = 2240. IBM is considering a 1.6M benchmark, and the only problem these days i

RE: connection pooling from an application server to oracle

Mladen, Probably, something is very wrong with application design. >With iPlanet, it looks like this: >Application invokes bean, pumpkin or servlet which has something to do >with oracle. The app server pooling mechanism will allocate one of the >already established dedicated server connection

Re: SMON offlining US=##

Gene, This message will be quite common if you are using Automatic Undo Management (AUM). As additional undo segments are needed, they are created. After a period of inactivity, SMON will offline them. Do not fear, they will be onlined if needed. I have a paper about AUM on my site at www.optimal

8i pl/sql question

Hi: Oracle 8173 DB. I have a package funtion, part of it is doing something like this: utl_file.put_line(fpn, myFunction1(myID, 1)); utl_file.put_line(fpn, myFunction1(myID, 8)); utl_file.put_line(fpn, myFunction1(myID, 6)); utl_file.put_line(fpn, myFunction1(myID, 35)); utl_file.p

RE: SMON offlining US=##

That's SMON taking undo segments offline. -Original Message- Sent: Monday, December 15, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I have been noticing this message in the alter logfiles for ORacle9. Can anyone explain what it means (or refer me to a document) please? thank

Problem Creating Java Source

Hi, im currently running the following code inside a sql script: . CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "TimeZoneConvert" AS public class TimeZoneConvert { public static int get_utc_offset (String p_tz) { java.util.TimeZone tz = java.util.TimeZone.getTimeZone(p_tz);

SMON offlining US=##

I have been noticing this message in the alter logfiles for ORacle9. Can anyone explain what it means (or refer me to a document) please? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-

Re: Re: Who are certified Oracle Masters?

What were you expected to do in the final exam ? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 8:59 AM > how many people are actually OCMs? and those of you that are, has it helped you in getting work? > > > > From: "R

New TPC benchmarks

http://www.tpc.org/tpcc/results/tpcc_perf_results.asp Finally, Oracle reclaims the lead! That Sqlserver isn't as scalable argument doesn't work too well when Sqlserver has a higher TPC benchmark. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Boligan

Re: Using a '.' in a username

Pete, feel free to put out the attitude anytime :) joe Pete Sharman wrote: OK, I've been using Oracle since 5.0, so does that mean I can give you the company line and the condescending attitude? J Actually, I think you're reading too much into Vlad's email. He was simply pointing out it COULD

Re: connection pooling from an application server to oracle

Duly noted. I guess that Saddam Hussein related excuses will no longer work, either. I'll have to thoroughly comb my book of excuses. On 12/15/2003 01:54:35 PM, Paul Drake wrote: > Mladen, > > Tread lightly on the "solar flares" my friend. > Last time we had some severe flares, 2 of my client si

Re: connection pooling from an application server to oracle

Mladen,   Tread lightly on the "solar flares" my friend. Last time we had some severe flares, 2 of my client sites lost their air conditioning units, which resulted in media failures. Hadn't had any air conditioning outages in at least 3 years at sites. Just a strange (circumstantial) coincidence,

Re: Using a '.' in a username

Which is precisely what I've said in my post about connection pooling. Homo sapiens sapiens is a funny species. I like some other species, like Natasha Henstridge, much better. On 12/15/2003 01:14:25 PM, "Goulet, Dick" wrote: > Joe, > > I believe you've hit that nail squarely on the head.

Re: Using a '.' in a username

Mladen Gogala wrote: Thanks, Vladimir. I haven't looked in the manual but as I've said, using those things in usernames or table names is a cruel and unusual practice which should be avoided if possible. Agreed, my point was the examples have to be consistent -- $SHELL does pay attention to the dou

RE: Using a '.' in a username

OK, I've been using Oracle since 5.0, so does that mean I can give you the company line and the condescending attitude?  J   Actually, I think you're reading too much into Vlad's email.  He was simply pointing out it COULD be done.  As you say, that doesn't mean it SHOULD be done, but I d

Re: Using a '.' in a username

Joe I do not think that message with a simple example and two references to the documentation was a bad and the example of schema naming was an excerption only. I've explained what I think about it in my previous message: " I'm not quite sure about common sense here. DBA who creates such names for

RE: Using a '.' in a username

Joe, I believe you've hit that nail squarely on the head. But then there are piles of dummies out there who like doing the dumb thing. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, December 15, 2003 12:55 PM To: Multiple recipients of li

RE: Using a '.' in a username

Last time I looked in my ANSI SQL standard usernames and object names were suppose to be : 1) Upper case 2) Could not contain punctuation characters 3) Could not contain spaces 4) etc... But as always Oracle has allowed these "exceptions" so long as they are imbed

Re: Using a '.' in a username

Please unless you've been at oracle doing oracle stuff since 1990 back in version 5 days, you can spare me the condescending attitude and the company line, the bottom line is oracle is just like C, it will let you shoot off your own foot(and thats the way most of us like it). its not dumbproof

RE: Re: 24 x 7 x 365

Tanel, There's a whole boatload of race conditions in that sort of replication architecture. As murali has pointed out, single-side commits create manual rollback situations - plus what happens when both transactions succeed, but in the delay between the two commits one side begins operating on

Re: Using a '.' in a username

Joe Testa wrote: besides the point the example is a schema.object_name NOT a user.name, evidently since its NOT in quotes. Does that mean that you cannot create such user(s) and connect as it was shown? Please read what it's written in the documentation -- that's why I put references. -- Vladimir

Re: Using a '.' in a username

Thanks, Vladimir. I haven't looked in the manual but as I've said, using those things in usernames or table names is a cruel and unusual practice which should be avoided if possible. On 12/15/2003 12:04:26 PM, Vladimir Begun wrote: > Mladen Gogala wrote: > > To use "." in the username is a cruel an

Re: Using a '.' in a username

Joe Testa wrote: But the point is you can't expect people to escape quotes, puhhhleas, try that in m$ windoze, does it work?, D:\>sqlplus \"j.j\"/[EMAIL PROTECTED] SQL*Plus: Release 9.2.0.1.0 - Production on Mon Dec 15 09:27:14 2003 Copyright (c) 1982, 2002, Oracle Corpora

Re: Using a '.' in a username

besides the point the example is a schema.object_name NOT a user.name, evidently since its NOT in quotes. joe Vladimir Begun wrote: Mladen Gogala wrote: To use "." in the username is a cruel and unusual practice which exposes funny sqlplus behavior: $ sqlplus "test.yogi" Mladen, please have

Re: Using a '.' in a username

But the point is you can't expect people to escape quotes, puhhhleas, try that in m$ windoze, does it work?, i dont have a machine to test that dumb OS anymore. :) joe Vladimir Begun wrote: Mladen Gogala wrote: To use "." in the username is a cruel and unusual practice

Re: Using a '.' in a username

Mladen Gogala wrote: To use "." in the username is a cruel and unusual practice which exposes funny sqlplus behavior: $ sqlplus "test.yogi" Mladen, please have a look 1. It's not sqlplus but $SHELL behavior, try this $ sqlplus \"test.yogi\" 2. Oracle9i SQL Reference Release 2 (9.2) CREATE USER 3.

Re: Re: 24 x 7 x 365

Tanel,   If this is the approach, then quite a bit of code would have to be developed on the front end to handle transaction integrity.   For example when one fails and the other has completed the write successfully, they will have to be physically removed.  What about if the record that is commit

Re: Using a '.' in a username

To use "." in the username is a cruel and unusual practice which exposes funny sqlplus behavior: $ sqlplus "test.yogi" SQL*Plus: Release 9.2.0.4.0 - Production on Mon Dec 15 11:27:17 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter password: ERROR: ORA-01017: inva

Re: connection pooling from an application server to oracle

On 12/15/2003 10:54:27 AM, "Mercadante, Thomas F" wrote: > But Mladen, sooner or later, somebody is going to wise-up and catch you in > your attempt at passing the blame. When this happens to me, I quote to > 80-20 rule. 80% gain in application thruput is brought thru Sql tuning (or > rewrite).

RE: connection pooling from an application server to oracle

Well said, Thomas! The longer I'm a DBA the more I find that having the right reply (like your example) is than necessarily being able to provide a thorough technical explanation they won't understand anyway. Obviously I still want to have the technical understanding. Thanks for sharing. Dennis Wi

RE: connection pooling from an application server to oracle

But Mladen, sooner or later, somebody is going to wise-up and catch you in your attempt at passing the blame. When this happens to me, I quote to 80-20 rule. 80% gain in application thruput is brought thru Sql tuning (or rewrite). If they say "The database is slow", I say "Show me the sql that i

RE: connection pooling from an application server to oracle

Ryan It depends on the application. For most applications the app. server connection pooling works satisfactorily (with grumbling from the DBA). For other applications that isn't good enough. An example might be a high-security financial application where you must trace each connection and trans

Using a '.' in a username

All, Is a '.' in the Oracle username legal in 8.1.7? I can create an account as follows: SQL>CREATE USER "PETER.LEE" idenfied by password; SQL>GRANT DBA TO "PETER.LEE" SQL>CONN PETER.LEE/[EMAIL PROTECTED] alias]; SQL> select * from user_role_privs; USERNAME GRANTED_ROLE

Re: connection pooling from an application server to oracle

Such app server side connection pooling is a nightmare for a DBA. Http pages ([aj]sp junk,php,mod_plsql,mod_perl using Apache::DBI) will each open one connection per page, as well as most CGI scripts (Adam von Nieda's exquisite oracle tool on http://www.oracletool.com is what comes to mind). If the

Re: RE: connection pooling from an application server to oracle

I might be totatly off here, but I think it depends on the type of the pool. For example in OCI land there are two - connection pool and session pool. The former is stateful, while the latter is stateless. Again unless I am totally off base, with a session pool I think your session gets returned to

Re: connection pooling from an application server to oracle

At 05:59 AM 12/15/2003, [EMAIL PROTECTED] wrote: The software engineers here are using an application server with connection pooling to connect to our oracle instances. They are doing it with a dedicated connection to Oracle. No MTS. This concerns me. how do you handle transaction control in this

RE: RE: connection pooling from an application server to oracle

Ryan, My understanding is that the transactions are packaged differently. For example, a trans that would come thru the app server will be packaged - like begin trans, exec trans and end trans - all as one call to the database. Almost like a two-phased commit (indeed, the errors that get reported

Re: RE: connection pooling from an application server to oracle

application connection level pooling = nothing for the dba to worry about (except making sure processes parameter is large enough) MTS= DBA has to manage it all and to your question, the answer is yes --- [EMAIL PROTECTED] wrote: > so if user A has 10 DML statements to do in one transaction. The

IBM mainframe/linux/oracle/SAN

Title: IBM mainframe/linux/oracle/SAN Anyone using that combination? We're looking at RHAS 3.0 at a cost of 15-18K.  Just wondering if anyone out there doing it? thanks, joe * This message, including any attachments, may contain

Re: RE: connection pooling from an application server to oracle

so if user A has 10 DML statements to do in one transaction. The application server will be smart enough to to only allow user 'A' to use that connection until a 'commit' is issued? how does application level connection pooling compare to MTS? > > From: Rachel Carmichael <[EMAIL PROTECTED]> >

Re: Fedora (pink hat)

Thanks! On 12/12/2003 05:54:32 PM, David Hau wrote: > I had installed 9.2 on Fedora and created a new DB. Everything has been > working fine so far. oemapp console, sqlplus and dbca all work fine. > Haven't tried other tools. > > As Joe mentioned, puschitz.com is the place to go for installati

RE: for security patches - going to 9.2.0.4

Title: RE: for security patches - going to 9.2.0.4 Thanks so much.  This was very well explained and I appreciate the time you took to share it.  I will go through the Metalink and read this over and test.    Thanks Again, Paula -Original Message-From: [EMAIL PROTECTED] [mailt

Re: RE: connection pooling from an application server to oracle

nope. the application server watches the connections and transactions the main problem is it's very hard to do a 10046 trace on a session with connection pooling going on, as a user session may actually be several distinct database sessions. --- [EMAIL PROTECTED] wrote: > doesnt this force

Re: RE: connection pooling from an application server to oracle

doesnt this force you to commit after every single DML statement? > > From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Date: 2003/12/15 Mon AM 08:36:09 EST > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > CC: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: RE: connection pooling from an a

RE: connection pooling from an application server to oracle

Ryan, This is becoming for normal. There are a lot of software pieces that do connection pooling - basically, everybody is plaing in everbody else's space. I have a couple of projects where the app-server does the connection pooling. One using Dcom and the other IBM WebSphere. >From your point

blob on import and export

Hello everybody   I have the following questions:   How can I use a full export without blob?   Or   How can I use a full import without blob?   Regards, Mauricio Vélez Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing

Re: connection pooling from an application server to oracle

This is very normal in Application Server case. We use Tuxedo and in our case when server starts, it creates more than 30 connections to each Oracle database regardless of whether you any applications actually uses it or not. Client communicates with server through soap, each operation is considere

Re: FW: Sun sets Solaris x86 free

That's right, it is just another crap. I would rather use Linux instead of Solarix for x86. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 15, 2003 07:29 > > On 2003.12.15 07:09, "Boivin, Patrice J" wrote: > > Now if Oracle cou

RE: Changing Character Set from WE8ISO8859P1 to UTF8

Oracle has an internal utility to do this in place named csconv. You have to get this from Oracle consulting. In any event, there is a utility named csscan in your oracle home. Run it against your database and it will tell what data if any needs to be changed. Look for UTF8 conversion docs on m

Re: Code Conversion from MSSQL into Oracle

oracle provides migration toolkit for this - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, December 13, 2003 6:14 AM > > > Are there any TOOLs for converting Sample Code (like the following) from > MSSQL into Oracle? > > SAMPLE :- >

connection pooling from an application server to oracle

The software engineers here are using an application server with connection pooling to connect to our oracle instances. They are doing it with a dedicated connection to Oracle. No MTS. they compartmentalize stuff here, so Im having trouble figuring out exactly how this affects the database and

Re: Oracle's jdbc driver

What is with the spamming banner in your email >>> [EMAIL PROTECTED] 12/13/2003 1:19:26 AM >>> Hi All How can I findout what is the version of the jdbc driver installed with oracle client install. Thanks and Regards B S Pradhan -- Please see the official ORACLE-L FAQ: http://www.ora

Re: FW: Sun sets Solaris x86 free

On 2003.12.15 07:09, "Boivin, Patrice J" wrote: > Now if Oracle could release a version of its products for Solaris x86. Why would you use it? So that SUN can, at Scott McNealy's whim, start charging for it? What is needed is not yet another Unix for x86, support for already existing public doma

FW: Sun sets Solaris x86 free

Title: FW: Sun sets Solaris x86 free Now if Oracle could release a version of its products for Solaris x86. Patrice.  -Original Message- http://www.theregister.co.uk/content/61/34450.html Sun sets Solaris x86 free By Ashlee Vance in Chicago Posted: 10/1

Re: Re: 24 x 7 x 365

Jonathan, Thanks for this valuable information. However, I'm using regular commits, not "distributed" two-phased ones and I just have simple code to handle the situation where servers return different success/error codes. Tanel. > > There is a problem with this approach > that may only become ap

RE: for security patches - going to 9.2.0.4

Title: RE: for security patches - going to 9.2.0.4 Paula, I had also bad experience when we upgraded one of our applications from 8.1.7 to 9.2.0.1 There were some queries that executed significantly slower then on 8.1.7. What we have done was: 1. We gathered system statistics with dbms_sys

Re: Changing Character Set from WE8ISO8859P1 to UTF8

You can't change to UTF8 from WE8ISO8859P1, since the latter is not a subset of UTF8. If you were on US7ASCII, the story would be different. You have to go with export/import. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, Decemb

RE: RedHat Advanced Server v3.0, anyone?

  I have a system with RH AS 2.1 in production and is very very fast and reliable. The server is a Proliant with 8GB RAM and 2x Intel Xeon. Oracle installation was easy, only take care if you have big memory. Also remenber to update the kernel. The predetermined don´t let start database.  

Oracle application server 10g ...Where is it on otn

Title: RE: Re[2]: char is going away? Hi,      It was on otn download web site but now it is not.   any idea ?   aRslan.

Re: Re: 24 x 7 x 365

There is a problem with this approach that may only become apparent at high concurrency. Since you are operating with two-phase commits, you may come up against the case where "writers block readers". Your client issues a commit to both servers. Each server get the PREPARE message, and when both

Re: Windows clustering???

And the plans for this, I was informed from a manager at HP last week, are: - It's beta on VMS on Itanium now - It can run in a cluster with an Alpha box - Possible release in 3rd quarter of 2004 Mogens Tanel Poder wrote: Maybe you all already know that, but HP is planning to support OpenVMS on

Re: for security patches - going to 9.2.0.4

We've had to set the _optimizer_features_enabled or whatever back to 8.1.7 and/or _new_initial_join_order (which defaults to true in 9.2.0.4, at least) to false after seeing a lot of problems going from 8.1.7 to 9.2.0.4. It's happened a couple of times, but I'm not sure if it's a trend or not.