PL/SQL (MOSC)

MOSC Banner

SQL Developer line chart report not working

edited May 7, 2021 1:52PM in PL/SQL (MOSC) 1 commentAnswered

Hi

I'm not sure if I'm in the right group for my question:

I'd like to create a user defined report in SQL Developer 19.1. Database version ist 12.1. (But actually I tried also with SQL Developer 19.4 without success).

My query is:

SELECT b.wait_class wait_class

   , TO_CHAR(TRUNC(a.end_time,'MI'),'HH24:MI') end_time

   , ROUND((SUM(a.time_waited) / 10),2) sample_count

 FROM gv$waitclassmetric_history a

 JOIN gv$system_wait_class b

  ON a.wait_class# = b.wait_class#

  AND a.inst_id = b.inst_id

 WHERE b.wait_class = 'System I/O' 

 GROUP BY TRUNC(a.end_time,'MI')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center