Re: Why the difference?

From: Jon Waterhouse <jonwaterhouse_at_mail.gov.nf.ca>
Date: 5 Apr 2002 06:02:35 -0800
Message-ID: <39206c8b.0204050602.6d0bf95f@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:02:35 CST