Categories
Is it expected to have value 0 for metric in gv$con_sysmetric ?
Hello,
Can you help me to confirm if it Is expected to have value 0 for metric "Database Wait Time Ratio" and "Database CPU Time Ratio" in gv$con_sysmetric in 19c.
Note : Its a 4 node , multitenant environment - (on-prem).
Sample output:
select * from gv$con_sysmetric where metric_id in (18047,18048) order by inst_id,metric_id ;
INST_ID BEGIN_TIME END_TIME INTSIZE_CSEC GROUP_ID METRIC_ID METRIC_NAME VALUE METRIC_UNIT CON_ID
---------- ---------------- ---------------- ------------ ---------- ---------- ------------------------------ ---------- -------------------- ----------
1 09/07/2022 11:32 09/07/2022 11:33 6036 18 18047 Database Wait Time Ratio 0 % Wait/DB_Time 3
1 09/07/2022 11:32 09/07/2022 11:33 6036 18 18048 Database CPU Time Ratio 0 % Cpu/DB_Time 3
2 09/07/2022 11:33 09/07/2022 11:34 6024 18 18047 Database Wait Time Ratio 0 % Wait/DB_Time 3
2 09/07/2022 11:33 09/07/2022 11:34 6024 18 18048 Database CPU Time Ratio 0 % Cpu/DB_Time 3
3 09/07/2022 11:33 09/07/2022 11:34 6029 18 18047 Database Wait Time Ratio 37,2444412 % Wait/DB_Time 3
3 09/07/2022 11:33 09/07/2022 11:34 6029 18 18048 Database CPU Time Ratio 62,7555588 % Cpu/DB_Time 3
4 09/07/2022 11:33 09/07/2022 11:34 6031 18 18047 Database Wait Time Ratio 89,4805797 % Wait/DB_Time 3
4 09/07/2022 11:33 09/07/2022 11:34 6031 18 18048 Database CPU Time Ratio 10,5194203 % Cpu/DB_Time 3