One more reason to reorg index regularly? -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Deepak Sharma Sent: Friday, November 18, 2005 12:43 PM To: Arul Ramachandran Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Simple SQL waiting on 'log file sync' As I just explained in my other email, it was not the Bitmap Indexes (we were suspecting that too), but the 5-column concatenated index that was causing it. Once I rebuilt it the loading went ok (at least in my tests). I have asked the application user to confirm it by running his job again. Thanks, Deepak --- Arul Ramachandran <contactarul@xxxxxxxxx> wrote: > You may want to drop those bit map indexes and > create it after the load to > see if there is a difference. > and you may want to consider doing this for every > run. > ~Arul > > 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 > > > > > > > __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com -- //www.freelists.org/webpage/oracle-l For technical support please email tech_support@xxxxxxxxxxx or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@xxxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l