Simple SQL waiting on 'log file sync'
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Nov 2005 09:48:54 -0800 (PST)
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
Other related posts:
