Re: V$SESSMETRIC

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 1 Jul 2019 10:22:20 -0400
Message-ID: <06af7102-6dd1-b0fc-524d-ec787a05651d_at_gmail.com>

Also, none of the statistics from v$sess_time_model are in v$statname:

SQL> select distinct stat_id from v$sess_time_model;

    STAT_ID

---

2748282437
1431595225
  372226525
2821698184
2643905994
2264996169
  908589701
2411117902
2799640666
4157170894
3138706091
2446918491
  294489758
3649082374
  290749718
1311180441
1159091985
4127043053
1824284809
4125607023
2266488992
4273067414

    STAT_ID

---

2451517896
1990024365
  268357648
  751169994
4092422623
2775283018
3780626361
2966986086
1226623006

31 rows selected.

I did several spot checks, to no avail:

SQL> select name from v$statname where stat_id=4157170894; no rows selected
SQL> What's going on? Our monitoring scripts are no longer welcome?

On 7/1/19 10:04 AM, Mladen Gogala wrote:
> Hi!
>
> I tried to write a brief monitoring script using V$SESSMETRIC.
> However, the table is empty. It's Oracle 12.2 on Oracle Linux 7.6.  Is
> there any parameter needed to populate the table? Oracle documentation
> doesn't provide any useful information:
>
> https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/V-SESSMETRIC.html#GUID-FFC5A6B9-9FBE-477A-91A8-0675C345725C
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 01 2019 - 16:22:20 CEST