How to resolve long running queries in Oracle 19c (2026)

How to resolve long running queries in Oracle 19c (2026)