Re: Poor performance after moving Extempore database from 7.3.4

JLew...now that is funny! Thanks Mladen!

on 8/11/03 1:04 PM, Mladen Gogala at mladen_at_wangtrading.com wrote:

> RBO, CBO, the old story. If you plan to continue using 8.1.7 for a
> While, then set the parameter OPTIMIZER_MODE to RULE. Your performance
> will be normal again and programmers will be able to override the parameter
> By specifying any hint except /*+ RULE */. Before switching to CBO, please
> read the article about the intelligent life in the optimizer. The article
> itself is a good one (thanks, Tim) but reading the book from JL (Jonathan
> Lewis, not Jeniffer Lopez) wouldn't hurt, either.
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> -----Original Message-----
> Smith, Ron L.
> Sent: Monday, August 11, 2003 3:14 PM
> To: Multiple recipients of list ORACLE-L
> 8.1.7
>
>
>
> We recently upgraded an application (Extempore) database from Oracle 7.3.4
> to 8.1.7. The clients say the test database, still on Oracle 7.3.4 is much
> faster than the production database, now on 8.1.7. The server is newer and
> faster on the production database. The Oracle init parameters are pretty
> much identical.
>
> When I access the database through SQL*PLUS or TOAD, the response is
> instantaneous. The app uses an ODBC connection which is also 8.1.7. I have
> tried attaching the tables in MS Access through ODBC. This too is
> instantaneous.
>
> Any ideas?
>
> Ron Smith

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).