I'd definitely start as Tom suggests by looking at the size of the redo
logs - if they have been left at the default then they'll be woefully
inadequate for 800k records.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Jon Waterhouse" <jonwaterhouse_at_mail.gov.nf.ca> wrote in message
news:39206c8b.0204050602.6d0bf95f_at_posting.google.com...
> Thomas Kyte <tkyte_at_oracle.com> wrote in message > >Any ideas on what
causes the difference?
> >
> > what size are your logs? are you in archivelog mode?
> >
> > insert into select -- logged.
> > CTAS -- not logged in noarchivelog mode.
>
> Database is running in noarchivelog mode
> >
> > look in your alert for "checkpoint not complete, cannot allocate new
log"
> >
> > is the insert inserting into an indexed table -- if so, the index
maintainence
> > will add tons too.
>
> No index on the destination table.
>
> I'll have a look at the execution plans.
>
> Thanks,
>
> Jon
Received on Fri Apr 05 2002 - 08:33:41 CST
