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

• Original Message ---- From: Jared Still <jkstill_at_gmail.com> To: ryan_gaffuri_at_comcast.net Cc: Mark.Bobak_at_il.proquest.com; oracle-l_at_freelists.org Sent: Saturday, April 7, 2007 10:41:22 AM Subject: Re: Does SELECT start a transaction?

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