What query to do to see what procedures are loading the Oracle server at the moment? How to kill demanding procedures?

    2 answers 2

    What orakl? starting from version 10, a default web server on the server is being built on the basis of which the EM works (the enterprise manager) rises to port 1158 by default: https: //localhost.localdomain: 1158 / em There you can see the download schedules and what specifically loads it.

      You can try TOAD for Oracle , there seems to be a PL / SQL profiler.

      • Or DBMS_PROFILER. - null