Analytics Software

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!

ODI repo query : SELECT SESS.SESS_NO FROM SNP_SESSION SESS WHERE SESS.SESS_MESS=:1

XavierGrosfilsMay 20 2020 — edited May 25 2020

Hello,

we had trouble ODI repo undo space in our production environement.

The issue came from following query :

DELETE FROM SNP_SESS_TASK_LOG WHERE SESS_NO IN ( SELECT SESS.SESS_NO FROM SNP_SESSION SESS WHERE SESS.SESS_MESS=:1 )

The issue never occured before (or at least the volume of log never caused issue).

Do you have any idea what is issuing this kind of query? And anything we coudl do about this? (We have no idea what was the binded value).

Thanks for insight,

Xavier

This post has been answered by SH_INT on May 20 2020

Jump to Answer

Added on May 20 2020

#business-intelligence-applications, #data-integrator, #system-management-and-integration

6 comments

790 views