I am testing a database application. It works fine when only one user
uses the application, however, when there are concurrent users, I saw
rollbacks in event log.
Can experts in this group tell me what is going on?
Thanks,
jz
================================================== ==========
17081) Connection Event
Appl Handle: 1723
Appl Id: *LOCAL.ssmm22.060403193435
Appl Seq number: 0005
Record is the result of a flush: FALSE
Application Status: SQLM_UOWWAIT
Lock Statistics:
Lock Waits: 0
Total time waited on locks (milliseconds): 0
Deadlocks: 0
Lock escalations: 0
X lock escalations: 0
Lock timeouts: 0
Sort Statistics:
Sorts: 0
Total sort time (milliseconds): 0
Sort overflows: 0
Hash Statistics:
Hash Joins: 0
Hash Loops: 0
Hash Join Small Overflows: 0
Hash Join Overflows: 0
Buffer Pool Statistics:
Buffer pool logical data page reads: 0
Buffer pool physical data page reads: 0
Buffer pool data page writes: 0
Buffer pool logical index page reads: 0
Buffer pool physical index page reads: 0
Buffer pool index page writes: 0
Buffer pool read time (milliseconds): 0
Buffer pool write time (milliseconds): 0
Time spent waiting for a prefetch: 0 milliseconds
Unread prefetch pages: 0
Workspace Statistics:
Shared workspace high water mark: 0
Total shared workspace overflows: 0
Total shared workspace section lookups: 0
Total shared workspace section inserts: 0
Private workspace high water mark: 0
Total private workspace overflows: 0
Total private workspace section lookups: 0
Total private workspace section inserts: 0
Direct I/O Statistics:
Sectors read directly: 0
Sectors written directly: 0
Direct read requests: 0
Direct write requests: 0
Direct read time: 0
Direct write time: 0
SQL Statement counts
Commit SQL statements: 1
Rollback SQL statements: 2
Dynamic SQL statements: 1
Static SQL stmts: 3
Failed SQL statements: 0
Select SQL statements: 0
Data Definition Language SQL statements: 0
Update/Insert/Delete SQL statements: 0
Internal counts
Internal auto rebinds: 0
Internal rows deleted: 0
Internal rows updated: 0
Internal rows inserted: 0
Internal commits: 1
Internal rollbacks: 0
Internal rollbacks due to deadlock: 0
Row counts
Rows deleted: 0
Rows inserted: 0
Rows updated: 0
Rows selected: 0
Rows read: 0
Rows written: 0
Binds/Precompiles: 0
Rejected block cursor requests: 0
Accepted block cursor requests: 0
Package Cache Statistics
Package Cache Lookups: 1
Package Cache Inserts: 0
Section Lookups: 1
Section Inserts: 0
Catalog Cache Statistics
Catalog Cache Overflows: 0
Catalog Cache High Water Mark: 0
Catalog Cache Lookups: 3
Catalog Cache Inserts: 0
CPU times
User CPU time: 0.002388 seconds
System CPU time: 0.000058 seconds
Memory usage:
Memory Pool Type: Application Heap
Current size (bytes): 147456
High water mark (bytes): 147456
Configured size (bytes): 4423680
Disconnection Time: 04/05/2006 17:17:24.962793