RE: Simple SQL waiting on 'log file sync'

  • From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • To: "Deepak Sharma" <sharmakdeep_oracle@xxxxxxxxx>
  • Date: Fri, 18 Nov 2005 10:23:50 -0800

 
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
>>>
--
//www.freelists.org/webpage/oracle-l


Other related posts: