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@xxxxxxxxx> 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 > -- > //www.freelists.org/webpage/oracle-l > > > -- Christo Kutrovsky Database/System Administrator The Pythian Group -- //www.freelists.org/webpage/oracle-l