Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Real Time SQL Monitoring -- HTML rendering error with db_version='12.*' ???

Bob BrylaJan 17 2016 — edited Jan 19 2016

Hello, I'm using latest version of SQL Developer (sqldeveloper-4.1.3.20.78-x64) with various 12c databases on many different platforms. The output from Real Time SQL Monitoring won't render on any browser unless I change db_version in this tag:

<report db_version="12.1.0.2.0" elapsed_time="0.14" cpu_time="0.08" cpu_cores="8"

to anything not beginning with "12". Nothing shows up in the browser window when opening the HTML file.

For this query I have attached original HTML output:

select /*+ monitor */ from dual;

Thanks. I'm stumped as to why db_version="12..." is causing issues.

Comments

Solomon Yakobson
Answer
select  to_char(trunc(entry_date,'MM'),'MM YYYY),
        sum(qty) qty
  from  your_table_name
  group by trunc(entry_date,'MM')
  order by trunc(entry_date,'MM')
/

SY.

Marked as Answer by SANPAT · Aug 9 2022
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 16 2016
Added on Jan 17 2016
4 comments
1,006 views