• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Phantom Read

 
Shrinivas Mujumdar
Ranch Hand
Posts: 328
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Friends,
It would be great if you can share the answer of the following query:

What is Phantom Read in Database? Why it should be prevented?

Regards,
Shriniwas
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Shrinivas Mujumdar:
Hello Friends,
It would be great if you can share the answer of the following query:

What is Phantom Read in Database? Why it should be prevented?

Regards,
Shriniwas


http://www.orafaq.com/node/37
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.vti.doc/vti83.htm

It should be prevented when it gives you a wrong answer and should not be prevented when it doesn't. Whether a phantom read is a problem or not depends solely on your application. Many applications are organized such that phantom reads don't happen to occur; to get a phantom read, you have to operate (read/update/etc.) over the same data twice, which is often not efficient.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic