This content has been marked as final. Show 4 replies
Thank for your hint.
I checked tSince we set up our DB a few weeks ago, the runtime audit log tables are +/- empty (eg 31000 records in OWB$WB_RT_AUDIT_EXECUTIONS, in old system we have 690'000 records in WB_RT_AUDIT_EXECUTIONS).
I can't believe, that after a few weeks without housekeeping job, the performance is already out of expectation ...
I will give a try today with truncating the log tables.
As far as I understood, workflow puts next "waiting" tasks in an Advanced Queue.
We didn't change the init.ora-parameter aq_tm_processes, where the default is 0 on a 11.1 DB.
On our 10.2 DB we set this aq_tm_processes = 2
Could this cause the problem?
It look's like, that for each Activity in a Process Flow, the workspace is set again.
(I can see a lot of queries against ALL_IV_WORKSPACE/WORKSPACE_ASSIGNMENT views in v$sql_area).
On 10.2, the concept of workspaces was not yet in place.
Since the duration of wb_workspace_management.set_workspace is something about 5 seconds, there is no surprise, that each activity is also that slow.
Or am I totally wrong?