ODI - DB Query to check sessions status if active

Query:

Select sid,serial#,program,module,status,username,schemaname from gv$session where status ='ACTIVE'

This query is very useful to see all the active processes even we can see the ODI sessions here.