l: [EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 15, 2002 10:23 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: export with "first rows"
The export views created by the catexp script
are totally screwed if you have FIRST_ROWS
as your optimizer
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 <[EMAIL PROTECTED]> wrote: > Hello,
> We have the optimizer mode set to "first rows"
> on our (25gb) database to meet a ven
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 co
Ed,
FIRST_ROWS optimizes for 'best response', and the default CHOOSE would have
used 'ALL_ROWS' for 'best throughput'. I have never run a Db in 'FIRST_ROWS'
- probably because it would always favor NLs over HJs and have a host of
other issues. You should _never_ analyze SYS objects - you will fi
From:
Ed Lewis
To: Multiple recipients of list ORACLE-L
Sent: Thursday, August 15, 2002 3:13
PM
Subject: export with "first rows"
Hello,
We have the optimizer mode set
to "first rows"
on our (25gb) database to meet a vendor
requirement.
It
looks like you have very high water marks and/or high fragmented
segments
Waleed
-Original Message-From: Ed Lewis
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 15, 2002 5:14
PMTo: Multiple recipients of list ORACLE-LSubject:
export with "first rows&quo
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