Re: export with "first rows"

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Fri, 16 Aug 2002 00:43:24 -0800
Message-ID: <F001.004B75B7.20020816004324@fatcity.com>

One option is to create a special user for exports, and create a logon trigger for that user which does

alter session set optimizer_mode = ...

hth
connor

• Ed Lewis <eglewis_at_hotmail.com> wrote: > Hello,
  > We have the optimizer mode set to "first rows"
  > on our (25gb) database to meet a vendor requirement.
  >
  > When I do an "direct" export, it runs for 6-7 hours.
  >
  > When I change the optimizer mode to "choose" it
  > runs in around an hour.
  > It also runs in an hour when I set the the optimizer
  > mode to "first rows", and run stats on the "sys"
  > schema.
  >
  > I'm curious why this occurs. Has anyone experienced
  > this ? Any ideas why this happens ? Is this normal
  > behavior ?
  > I could not find anything on metalink. thanks.
  >
  > Oracle 8.1.7.2, aix 4.3.3.
  >
  > ed
  >
  

  ---

Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Remember amateurs built the ark - Professionals built the Titanic"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Fri Aug 16 2002 - 03:43:24 CDT