Hi All,
We have oracle 19c on Redhat.
When monitor long running sql, we usually use v$session where status='ACTIVE' and last_call_et , then we use the column last_activity_time in v$sql , whether it is moving or not.
then we use v$session_longops to find remaining time but some time v$session_longops, not showing approximate completion time.
How to find approximate completion time of the sql.
How to find a session in not moving/hanging.So. it can be killed.
How to find how much time is taken each operation in a sql as per the execution plan
How to monitor parallel query execution
Thanks