Home » Other » General » postponed commits possible?
postponed commits possible? [message #216571] Mon, 29 January 2007 07:58 Go to next message
piet.heyn
Messages: 3
Registered: January 2007
Junior Member
Hello,

Would there be a situation possible where Oracle can decide to postpone a commit given by a user?

We have a problem where a user inserts some rows in a table, commits the inserts, but other users don't see the new rows. Only when the 1st user shuts down the application, the rows are visible to other users.

Maybe, when there is a heavy workload on the server, Oracle decides to postpone the commit?

Thanks in advance for your time!
Re: postponed commits possible? [message #216587 is a reply to message #216571] Mon, 29 January 2007 10:18 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Are you sure you actually commit to the database? Not post?
Could it be the Citrix layer you mentioned earlier?
I can't think of a reason why a commit would be 'postponed', since a commit does not do very much
Re: postponed commits possible? [message #216614 is a reply to message #216587] Mon, 29 January 2007 12:47 Go to previous messageGo to next message
piet.heyn
Messages: 3
Registered: January 2007
Junior Member
I am sure the commit is done. I also wouldn't know why the commit is postponed, but if there is a possibility that it could be somehow, I would like to know.
Re: postponed commits possible? [message #216624 is a reply to message #216571] Mon, 29 January 2007 14:29 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Sounds like an application refresh issue to me.
Previous Topic: Connectivity of Oracle 8.0i with VB 6.0
Next Topic: copying all of the objects in one schema over to another schema
Goto Forum:
  


Current Time: Sun Apr 28 12:36:17 CDT 2024