Re: Simple SQL waiting on 'log file sync'
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: Arul Ramachandran <contactarul@xxxxxxxxx>
- Date: Fri, 18 Nov 2005 10:42:35 -0800 (PST)
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
Other related posts:
