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: 185
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: 25037
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: 64110
Registered: March 2007
Location: Nanterre, France, http://...
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: Mon Dec 05 10:56:31 CST 2016

Total time taken to generate the page: 0.12632 seconds