What query to do to see what procedures are loading the Oracle server at the moment? How to kill demanding procedures?
2 answers
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
|