Skip to Main Content
Forums

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!

too many background processes running, should I kill P001 etc...

490768May 4 2008 — edited May 4 2008
Looks like a rollback occurred when cancelling a table insert.
Now several processes are running under TOP ACTIVITY, not using much CPU or Memory but 12 are running (P000, P009, P004 etc...).
They are wating for undo for undo record under session activity.

They have been running for several hours.

Should I kill them or let them finish??

Thanks for the help!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2008
Added on May 4 2008
#general-database-discussions
2 comments
1,436 views