Lock Timeouts - Help needed
Posted in 1998
We have migrated from an Online 5.0 engine on a SPARC machine to
Online 7.02 on an Intel machine.
We ran the normal dbexport and dbimport and got the database up and
running. We then ran update statistics to optimise the system.
We are now getting masses of Lock Timeouts on tables across the
database. This is coupled with the following profile stats from
onmonitor :
Obviously the deadlocks and the lock requests are quite worrying. Any
help much appreciated.
Boot Time Thu Sep 3 04:06:05 1998
Current Time Thu Sep 3 12:42:19 1998
Disk Reads Buff. Reads %Cached Disk Writes Buff. Writes
%Cached
3265200 108585179 96.99 318445 4555218
93.01
Over Lock Over Userthread User Time Sys. Time Checkpoints
0 0 10161 873 71
ixda-RA idx-RA da-RA RA-pgsused Latch Waits
1052414 90303 1299919 2441498 91355
Buff. Waits Lock Waits Lock Req. Deadlocks DLTimeouts Check Waits
421701 628 63359204 24 0 285
CALLS: Open Start Read Write
685517 2533311 47777601 1619608
Total
Calls
Rewrite Delete Commit Rollback
61829102
8203 11175 15047 147