Re: V$SESSMETRIC
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 1 Jul 2019 10:34:10 -0400
Message-ID: <f0b60f96-564d-819e-1440-dae54dac32d4_at_gmail.com>
Date: Mon, 1 Jul 2019 10:34:10 -0400
Message-ID: <f0b60f96-564d-819e-1440-dae54dac32d4_at_gmail.com>
Ah, the mystery is resolved! The table is populated on the CDB$ROOT level, not on container level.
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-lReceived on Mon Jul 01 2019 - 16:34:10 CEST