Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Simple SQL waiting on 'log file sync'
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-lReceived on Fri Nov 18 2005 - 13:27:24 CST
![]() |
![]() |