Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Simple SQL waiting on 'log file sync'

RE: Simple SQL waiting on 'log file sync'

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Fri, 18 Nov 2005 10:23:50 -0800
Message-ID: <B9782AD410794F4687F2B5B4A6FF3501021D519E@ex1.ms.polyserve.com>

 

gotta be recursive then...what does it do if you alter the table to allocate a large extent (larger than the insert amount) before running this ?

>>>Step1:
>>>insert.. select statement <<- generated trace has the log
>>>file sync message
>>>
>>>Step 2:
>>>commit <<- I'm not even there yet
>>>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 18 2005 - 13:27:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US