2 Replies Latest reply: Apr 30, 2014 7:47 AM by JohnWatson RSS

    Monitoring database service load.

    ma365

      Hi,

       

      I'm working on a 7 node RAC cluster (11.2.0.3 on RHEL 6.4 x86_64) which has a 50+ services registered which different business appications use to connect to the database.

       

      Can anyone suggest a method to establish which of these services are the busiest and generating the most load on their respective instances?

       

      I'd like to able to distribute the services across the available instances so that the busiest services do not clash with each other on an instance.

       

      Is it possible to easily identifed what the top services are by number of connections and workload performed?

       

      Thanks in advance,