V$SYSSTAT versus V$SERVICE_STATS
From: Chitale, Hemant K <Hemant-K.Chitale_at_sc.com>
Date: Thu, 26 Jun 2014 13:53:58 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB601EA99FF_at_HKJUMXMB103B.zone1.scb.net>
Date: Thu, 26 Jun 2014 13:53:58 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB601EA99FF_at_HKJUMXMB103B.zone1.scb.net>
I am unhappy with the fact that we have only a few statistics reported at the Service level :
select name
from v$sysstat
minus
select stat_name
from v$service_stats
where service_name = 'MY_SERVICE';
The difference is about 600 statistics counters in 11.2.0.3
Is this improved in 12c ?
Hemant K Chitale
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 26 2014 - 07:53:58 CEST