Re: export with "first rows"

From: Nuno Pinto do Souto <nsouto_at_optushome.com.au>
Date: Thu, 15 Aug 2002 17:23:21 -0800
Message-ID: <F001.004B730C.20020815172321@fatcity.com>

('binary' encoding is not supported, stored as-is)
The export views created by the catexp script are totally screwed if you have FIRST_ROWS as your optimizer setting.
Either use CHOOSE or edit the views to include a RULE hint on all SELECT statements
and you'll be fine.

And if you tell Oracle support I recommended you did this, I'll personally come around and snip your doolies off.

Cheers
Nuno Souto
nsouto_at_optushome.com.au

> 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nuno Pinto do Souto
  INET: nsouto_at_optushome.com.au

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 Thu Aug 15 2002 - 20:23:21 CDT