Welcome to Cisco Support Community. We would love to have your feedback.
For an introduction to the new site, click here. And see here for current known issues.
We are some serious issue with oracle DB target, its opening sessions and not closing properly DB sessions.
How can we avoid these situations in CPO. We are using CPO 3.0
For this kind of issue I think we need to involve TAC. Please open a case and give them instructions on how to reproduce the issue as well as detect the open sessions in your DB.