Hi All

Thanks for your time!!

Yes, I found the contention on the undo block is gradully incresing. My question is not just based on the number of users(sorry i didn't mention the contention!! ). Also I am experiencing waits in the rollback segments. Also, every week 20-25 new users adding to the system and may go up to 1500. One important thing is, if you are not setting the (oracle 7.3... May be I am the only one DBA struggling with 7.3 in the earth!!) parameter transactions_per_rollback_segment is found ( default value) 72. Don't understand, what is the logic setting the value as 72.

Any how my ultimate plan to create more rollback segments as compared with the 'Concurrent Transactions' and contention on the RBS blocks.

Thanks everybody for your replies..


Thomas