Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle - blocking reads

 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In our Oracle 9 application, the read only (JDBC) queries block when we are updating the database. The updates occur within entity beans in a transaction with an isolation level of committed.

Is it possible to get the queries to retrieve the last committed data rather than block?
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
By saying updating database, you mean updating some particular rows of a particular table, right??

if it is like that then the behaviour is wiered.

Because in oracle, while updating rows, the previous committed rows, that are being changed, is written to a rollback segment. And when some other user executes query on that table then he/she doesn't get the uncommitted changed rows, but committed old rows from rollback segment.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Adeel,
Yes, I mean updating some rows in a database.

Thanks for confirming my understanding of this at least. I guess I'll experiment with transaction settings to see if I am somehow supressing this behavior.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic