RE: Simple SQL waiting on 'log file sync'

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Fri, 18 Nov 2005 10:17:10 -0800 (PST)
Message-ID: <20051118181710.63288.qmail@web52811.mail.yahoo.com>

I am in the process of debugging an application that uses a PL/SQL procedure that ha sa statement similar to this. In my testing, I do have a step to commit, but that is 'after' this insert..select statement. What I am noticing is that if I run a trace, there are 'log file sync' messages.

Step1:
insert.. select statement <<- generated trace has the log file sync message

Step 2:
commit <<- I'm not even there yet

Thanks,
Deepak

• Kevin Closson <kevinc_at_polyserve.com> wrote:

> >>>
> >>>INSERT INTO A1 SELECT * FROM B1;
> >>>
> >>>1) Isn't 'log file sync' related to commits? In
> above I am
> >>>not even commiting.
>
> um, if you are not committing, what is the purpose
> of this
> select ?
>
>
                

---

Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 18 2005 - 13:21:17 CST