Re: Why the difference?

Hi Tom,

I don't actually have access to the ALERT log (Oracle is installed on a drive to which I don't have rights-- I'm no the DBA), but I have had the Redo log size uppped to 8MB from the original 200K and execution times are now reasonable (2.5 minutes, compared with the original 2.5 hours).

Many thanks.

Jon
"Thomas Kyte" <tkyte_at_oracle.com> wrote in message news:a8kmvo016bn_at_drn.newsguy.com...
> 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
>
Received on Mon Apr 08 2002 - 06:56:49 CDT