my front users are locking the rollback segemnts.
Database size= 70 gb on unix.
oracle 8.0.6
since transaction_per_rollback_seg = 4
rollback numbers are 55
initial extents = 6m
next = 6m
minextents=15
optimal = 120m
no of sessions = 190
no of transaction= 10
Thing is that users are locking the rollback segments and the system is hanging not the server the clients machine
[Edited by shashikumar on 07-02-2001 at 04:11 AM]