Wednesday, February 2, 2022

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.

No comments:

Post a Comment

Featured Post

OIC - Using Dynamic Paths for OCI Object Storage in OIC Integrations | Handling “Subfolders” in OCI Object Storage bucket

Use Case In Oracle Integration Cloud (OIC), when working with Oracle Object Storage, “folders” inside a bucket are not real directories . T...