Re: Any Oracle9i Enterprise Edition success?

You cannot compare costs between execution plans especially between server releases. While it would seem to make sense ; the "cost" is an arbitrary number and not comparable.
Jim

"Mike Doherty" <mdoherty_at_atroad.com> wrote in message news:8b565c44.0106121813.39cbf22d_at_posting.google.com...
> Had no problem with the install and had no problem with the upgrade.
> But to my suprise when i compared execution plans from 8.1.6 to the
> exact database on 9 the 9 db had 5% greater cost for identical
> queries. Again this is keeping the exact init params for the two
> systems.
>
>
> Dirk Kiehne <dirk_at_liberate.com> wrote in message
 news:<3B266DCF.FC3D4861_at_liberate.com>...
> > Mike wrote:
> > >
> > > I've downloaded Oracle9i Enterprise Edition for Solaris, and here's
 what
> > > I've experienced:
> > >
> > > - 3 CDs are required. I NFS-shared them so that they're accessible
 from the
> > > database server.
> > > - The database server is an antique Sparc Ultra-1.
> > > - It takes over 3 hours (!) to install the software. If I had a more
 modern
> > > machine, things would be easier.
> > > - The installer croaked while linking the "oracle" executable. After
 some
> > > digging, I found that more swap space was required. Not a problem.
> > > - Got all the software running OK. Went to SQL*Plus and did a connect
 as
> > > sysdba. (Yes, INTERNAL has finally been put out of its misery). A
 STARTUP
> > > NOMOUNT results in hang.
> > > - Investigating (with "truss"), I found a single background process in
 what
> > > appeared to be a perma wait state. I don't remember all the gory
 details at
> > > this time, but yes I can reproduce the error.
> > >
> > > Yes, I know that folks on the bleeding edge sometimes get cut...and I
> > > shouldn't be surprised with version 9.0.1. Has anyone out there got
 9iEE up
> > > & running?
> > >
> > > -Mike
> > > (to reply: longtermmemoryloss at hotmail dot com)
> >
> > I got my 9i install to work fine. When I created the DB though, with
> > dbca, I
> > wanted to save to a script so I could use raw partitions, but the option
> > didn't exist yet (the "help" button say it will be there). I got
> > everything
> > going and tried to install our software against the database and got the
> > big
> > ORA-0600 error with our jdbc connection - sigh.
> >
> > Your troubles may come from not installing all the patches that the
> > release
> > notes suggest. With Solaris 8, I put MU_4 on the machine and the latest
> > Recommended patch. The release note and quick install instructions say
> > you'll
> > need to install two other patches (108434-01 and 108435-01). They also
> > have a
> > table that has lists for previous and other OSs. I also found a note
> > that
> > required a bumping up of two values in /etc/system:(semmsl and semmns)
> > which
> > have changed minimums from previous Oracle versions.
> >
> > -Dirk
Received on Tue Jun 12 2001 - 21:33:11 CDT