Support Migration Notice: To update migrated JIRA cases click here to open a new case use www.vmware.com/go/sr | vFabric Hyperic 5.7.0 is Now Available

Hyperic HQ

Oracle session metrics

Details

  • Type: Improvement Improvement
  • Status: Open Open
  • Priority: Trivial Trivial
  • Resolution: Unresolved
  • Affects Version/s: 4.4
  • Fix Version/s: None
  • Component/s: Plugins
  • Case Links:
    none
  • Regression:
    No
  • Tags:

Description

Request is to add additional metrics to the Oracle plugin for session metrics. 3 in particular:

1. NB LOCKED SESSIONS:

select count from v$session where event = 'enq: TX - row lock contention';

2. NB KILLED SESSIONS:

with a as (select count(status) cnt,status,service_name from v$session group by status,service_Name)
select a3.cnt "CNT_KILLED"
from (select nvl(sum(a.cnt),0) cnt from a where status='ACTIVE' and nvl(service_name,'-') <> 'SYS$BACKGROUND') a1,
(select nvl(sum(a.cnt),0) cnt from a where status='INACTIVE') a2,
(select nvl(sum(a.cnt),0) cnt from a where status='KILLED') a3,
(select nvl(sum(a.cnt),0) cnt from a ) a4;

3. % WAITING SESSIONS:

select ((select count from v$session_wait where state = 'WAITING') * 100)/( select count from v$session) "Percentage_sess_inwait" from dual

Activity

There are no comments yet on this issue.

People

Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Last comment:
    3 years, 26 weeks, 4 days ago