Simple SQL waiting on 'log file sync'

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Fri, 18 Nov 2005 09:48:54 -0800 (PST)
Message-ID: <20051118174854.68243.qmail@web52804.mail.yahoo.com>

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

Received on Fri Nov 18 2005 - 12:52:07 CST