Notes in-line
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
April 2004 Iceland http://www.index.is/oracleday.php
June 2004 UK - Optimising Oracle Seminar
"Mark" <simmons_mark_at_yahoo.com> wrote in message
news:5366fb41.0404010853.22cdbcf8_at_posting.google.com...
> If your problem is the 'free block' anomoly, you could force a direct
> path load as a quick test. (Keeping in mind that you would have to do
> a backup.)
>
It's not the APPEND that requires a backup,
it's the fact that most people think of APPEND
and NOLOGGING tables as going together -
and it's the nologging bit which requires the
backup.
> insert /*+ append parallel(xxx) */ into xxx
commit;
-- I don't think I'd bother with the parallel insert
-- for the purposes of testing. You'd also get
-- some benefit from the special optimisation for
-- the associated index updates.
> select /*+ parallel(xxx2) */ * from xxx2;
>
> Mark Simmons
> Sr. Oracle DBA
> Sabre-Holdings, Southlake, TX
>
Received on Thu Apr 01 2004 - 11:01:32 CST
