Skip to Main Content
Forums

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 12c: SQL query to retrieve Session info like shown in the Operator view

User_O3PAFJul 23 2014 — edited Jul 29 2014


Hi,

I need to query the Session info like the information shown in the Operator view for ODI 12c.

I googled and found some scripts that work with 11g and before, but when I run those I do not get any info when running those on our 12c installation.

I need the following information:

  • For Session = Session ID
  • and Step = step number
    • The number of inserts
    • The number of Updates
    • The number of Deletes
    • The number of Errors
    • The number of Rows
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2014
Added on Jul 23 2014
#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration
4 comments
5,635 views