Oracle SQLDeveloper Command-Line (SQLcl) version: 4.2.0.17.097.0719
oracle database is 12.2.0.1
sqlcl is installed on a windows 7 laptop, database runs on Linux 7
sqlcl, and sql developer ignore setting numformat. This works fine in sqlplus, sql client is 12.2
SET LINES 200
SET NUMF 999.99
SELECT metric_name
,VALUE
FROM sys.v_$sysmetric
WHERE metric_name IN ('Database CPU Time Ratio', 'Database Wait Time Ratio')
AND intsize_csec = (SELECT MAX(intsize_csec) FROM sys.v_$sysmetric);
METRIC_NAME VALUE
Database Wait Time Ratio 0
Database CPU Time Ratio 110.486838198273