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: Does SELECT start a transaction?

Re: Does SELECT start a transaction?

From: Jonathan Knight <knightjck_work_at_yahoo.com>
Date: Mon, 9 Apr 2007 07:20:27 -0700 (PDT)
Message-ID: <538643.85821.qm@web60611.mail.yahoo.com>


Thanks everyone.

We have performed a few test loads that seem to work even with other sessions querying the table being loaded. We have some files coming for production so we'll convert a .CTL file to DIRECT and give it a shot. From our research, testing, and the comments here, it should be fine.

Thanks again,
Jon Knight

On 4/7/07, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote: my understanding of a 3 phase commit is: ...
 I could be mis-remembering it.

Theres an article on widipedia that seems to have a good explanation.

http://en.wikipedia.org/wiki/Three-phase_commit_protocol

--

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist  



No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started. http://mobile.yahoo.com/mail
--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 09 2007 - 09:20:27 CDT

Original text of this message

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