RE: Simple SQL waiting on 'log file sync'
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: <sharmakdeep_oracle@xxxxxxxxx>, "Arul Ramachandran" <contactarul@xxxxxxxxx>
- Date: Fri, 18 Nov 2005 15:18:29 -0600
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
Other related posts:
