Marc Kelderman wrote a helpful article on this topic:
http://orasoa.blogspot.com/2007/03/delete-bpel-instances.html
And one of the users there also notes:
Note there is a patch to 10.1.3.3 to purge old data (6372741). Its a fairly dumb one that deletes everything older than a given date. Trying to do something more elaborate we have noticed that if you use the script […]

I don’t really like what Oracle did with BAM user/roles and authentication.
I think they took Microsoft tables and just slapped them into Oracle (having to put quotes around tables and columns). I assume this process will change in the upcoming releases, but here is a quick SQL statement you can use to get a […]

Our friends at Oracle give us a nice list of requirements for their Application Server and Portal products, to help us define to our customers what is needed to run these mammoths of ability and power. But can you make it run on less? And if so, how much less?
NOTE […]

Wow, first day. Always a bit apprehensive when starting something new, and potentially life altering. I sat at my desk, wondering and thinking of all the things that might come up in in my phone conversation with the new bosses.
After brief introductions, the discussion began, and rather quickly swayed my apprehension and piqued my interests. Referencing […]

If you have used the email notification activity in Oracle BPEL (up through the latest version at the time of this writing, 10.1.3.3.1), you might have found that you always get an attachment for your email body, even if you don’t want one.  There is a solution:
Once in the scope of the email notification activity, […]