How to troubleshoot a concurrent request which has no database session.
Our environment is EBS 12.2.10 on RHEL 8. There are only two nodes, one for database and one for the application tier. There is a concurrent request which is running very long. But it is not creating database session. How to see what it is doing, where is it stuck? How to troubleshoot it>