Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

About single-task message wait event

user12100209Sep 23 2010 — edited Sep 23 2010

Hello

I have several active users, some of them from 2 an 3 days ago with single-task message wait event and their last_call was many time ago. One of users, blocked to other users just a little while ago and Concurrency grow up to 20 % and was on increase. i had to kill this user and all were well, concurrency dessapeared.

How could I avoid this behavior??

How could I kill these type of user by automatic way??

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2010

Added on Sep 23 2010

#general-database-discussions

1 comment

1,040 views