Home » RDBMS Server » Performance Tuning » commit takes a long time
commit takes a long time [message #65167] Wed, 26 May 2004 17:47 Go to next message
mark collings
Messages: 1
Registered: May 2004
Junior Member
Hi,

I am on oracle 9.2.0.1 on win 2k server.

The select operations are fast, but when I commit, even single record inserted or updated takes about 30 mins.

Any suggestions on what to look for.

Thanks,

Mark
Re: commit takes a long time [message #65172 is a reply to message #65167] Mon, 31 May 2004 04:38 Go to previous message
ora9iDBA
Messages: 31
Registered: March 2003
Member
send the trace of your session (which is trying to commit)
Previous Topic: REBUILD INDEXES
Next Topic: Strange Performance Problem
Goto Forum:
  


Current Time: Sun Mar 03 22:50:15 CST 2024