Re: Simple SQL waiting on 'log file sync'

You are not commiting, but Oracle is.

It's probably the extent allocation.

Christo Kutrovsky
Database/System Administrator
The Pythian Group

On 11/18/05, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com> wrote:
> I have a SQL statement as follows:
>
> INSERT INTO A1 SELECT * FROM B1;
>
> Table A1 has about 900K rows, 1 PK and has 4 Bitmap
> indexes.
>
> When I run the above from SQL*Plus with a 10046 trace,
> I see a lot of mesages as follows related to 'log file
> sync' :
>
> WAIT #1: nam='log file sync' ela= 59250 p1=9313 p2=0
> p3=0
>
> This statement usually completes in < 5 mins, but for
> last 2 days it's running continuously for several
> hours, and the only wait event I see is 'log file
> sync'.
>
> My question is:
>
> 1) Isn't 'log file sync' related to commits? In above
> I am not even commiting.
> 2) System-wide we are not seeing this wait event, but
> just for this session.
>
> Thanks,
> Deepak
>
>
>
> __________________________________
> Yahoo! FareChase: Search multiple travel sites in one click.
> http://farechase.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l