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