3 Replies Latest reply on Sep 26, 2019 7:28 PM by thatJeffSmith-Oracle

    SQLDeveloper Real Time SQL Monitor

    3864923

      In SQLDeveloper 17.3 on Oracle 18c on Oracle Linux 7.6:  We have a website and wish to view the SQL generated by the website. The Schema used by the Website is called: ACT  and the ACT schema is in a Pluggable database called ACT_PDB.  What is the best way to view the SQL generated by the website?  I tried SQLDeveloper Real TIme SQL Monitor, but it does not seem to show SQL from the website.   I've connected to the SYS schema using the service for ACT_PDB, but the SQL does not seem to show up in Real Time SQL Monitor.

       

      What is the correct way to display real time sql in the database using Real Time SQL Monitor?

       

      Or is there a better way to view the SQL generated by the website?

       

       

      I have also tested this issue against the latest version of SQLDeveloper 19.2 and the same problem exists with this latest version.

       

      Thanks much