Those BG logs are rather full of errors "
Did not get exactly one rowset with 0 or 1 row back" (I'm sure you would have seen that!)
So I rather think that your Oracle session problems are a
symptom of an underlying problem with your BG/processes - I think you need to concentrate on fixing that first rather than clearing the DB end.
Are CA Support getting you to look at anything specific (and if you have not raised this with support, you really should do!)
--
EDIT : I can only find one reference to that error message on the message boards;
Error in NSA Log file bg-niku.log and that thread isn't very useful (apart from suggesting that you have a corrupt running process/action items somewhere).
I would perhaps try to work out why the data associated with this;
DBResultSet: 0 No of rows: 3
Row: 0 No of columns: 3
Column Name: status_code Value: BPM_AIS_RUNNING
Column Name: id Value: 6783439
Column Name: step_action_id Value: 5155229
Row: 1 No of columns: 3
Column Name: status_code Value: BPM_AIS_RUNNING
Column Name: id Value: 6783445
Column Name: step_action_id Value: 5155229
Row: 2 No of columns: 3
Column Name: status_code Value: BPM_AIS_RUNNING
Column Name: id Value: 6783450
Column Name: step_action_id Value: 5155229
is "broken" since it is the same data repeated over and over in the logs.... :wacko:
--
EDIT2 : There is something in the "fixed bugs" lists that looks like the same problem;
CLRT-46861 (S2) - Action items for the Idea’s Approver doesn’t always work. - the release notes contains the same BG error that you are having. I can't find a detailed description of the bug though.
But if you search for that CLRT ref in the KB (i.e. the Support site) you will find it "fixed" in 12.0.6 I think - you say you are 12.0.5 ?
** Contact support and see if they have a workaround for CLRT-46861 then! **