Hi Experts,
Could you please provide queries to monitor oracle sessions in terms of performance monitoring.
Basically I want to know what are all sessions running, which sessions are taking time , any locked sessions, any waiting sessions and which SQLs are running for long time.
Thanks in advance.