Re: Simple SQL waiting on 'log file sync'
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: sharmakdeep_oracle@xxxxxxxxx
- Date: Fri, 18 Nov 2005 13:16:14 -0500
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
Other related posts:
