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.
Use Case: In many enterprise applications and data integrations (like Oracle ERP, SAP, or banking systems), date fields often come in legacy...
No comments:
Post a Comment