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

Report message to a moderator

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)

Report message to a moderator

Previous Topic: REBUILD INDEXES
Next Topic: Strange Performance Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 05:27:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.