Re: Why the difference?

In article <39206c8b.0204050602.6d0bf95f_at_posting.google.com>, jonwaterhouse_at_mail.gov.nf.ca says...
>
>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

so, the insert into -- logged.
CTAS not logged (in noarchivelog mode)

>>
>> look in your alert for "checkpoint not complete, cannot allocate new log"
>>

any of those?

>>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

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp