Home » SQL & PL/SQL » SQL & PL/SQL » Critical question (Oracle 9i)
Critical question [message #320222] Wed, 14 May 2008 06:07 Go to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
Dear sir

Suppose I have one table and one user.Suppose I fired an insert statement from a machine and at the same time I have fired select statement of the particular user from different machine .Will the table be locked or the record that I have inserted be locked.?

Regards
Re: Critical question [message #320223 is a reply to message #320222] Wed, 14 May 2008 06:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>.Will the table be locked or the record that I have inserted be locked.?
NO

With Oracle readers do not block writers & writers do not block readers.
Re: Critical question [message #320224 is a reply to message #320222] Wed, 14 May 2008 06:10 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Suppose you have internet access check this link

http://tahiti.oracle.com

Look for database concepts. Also search for this keyword ACID (Atomicity, Concurrency, Isolation and Durability)

Briefly, in Oracle readers never block writers and writers never block readers.

To be more precise read this chapter.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/consist.htm#i13945

Regards

Raj

[Updated on: Wed, 14 May 2008 06:13]

Report message to a moderator

Re: Critical question [message #320226 is a reply to message #320222] Wed, 14 May 2008 06:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Database Concepts
Chapter 13 Data Concurrency and Consistency

T.Kyte "On Transaction Isolation Levels"

Regards
Michel

[Edit: Sorry Raj, first link is the same as yours]

[Updated on: Wed, 14 May 2008 06:26]

Report message to a moderator

Re: Critical question [message #320241 is a reply to message #320226] Wed, 14 May 2008 07:19 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
You don't need to apologize. Your links are always spot on.

Regards

Raj
Previous Topic: deadlock
Next Topic: compare columns between tables
Goto Forum:
  


Current Time: Tue Feb 11 03:41:03 CST 2025