OraFAQ Forum: Performance Tuning » DBMS_SQLTUNE.REPORT_SQL

Home » RDBMS Server » Performance Tuning » DBMS_SQLTUNE.REPORT_SQL_DETAIL: html report issue (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBMS_SQLTUNE.REPORT_SQL_DETAIL: html report issue [message #682300]

Thu, 15 October 2020 09:08

piripicchio
Messages: 20
Registered: April 2018
Location: Rome

Junior Member

Hi all,
I wonder if anyone has encountered this problem before.
As a premise: I've always used the DBMS_SQLTUNE.REPORT_SQL_MONITOR procedure to spool an active (Flash) html report and it's always done what it is supposed to do; here is the call to the procedure:

Code: [Select all] [Show/ hide]

SELECT SYS.DBMS_SQLTUNE.REPORT_SQL_MONITOR(SQL_ID => '&SQL_ID', TYPE => 'ACTIVE', SQL_EXEC_ID => '&SQL_EXEC_ID') REPORT_SQL_MONITOR FROM DUAL;

This morning I tried for the first time the DBMS_SQLTUNE.REPORT_SQL_DETAIL procedure, here is the call:

Code: [Select all] [Show/ hide]

SELECT SYS.DBMS_SQLTUNE.REPORT_SQL_DETAIL(SQL_ID => '&SQL_ID', TYPE => 'ACTIVE') REPORT_SQL_MONITOR FROM DUAL;

It spools correctly an html page with Flash content, but when I open it with a browser, it keeps reloading forever; if I look in the browser console, I can see that it keeps dowloading an .swf file over and over again; the file is emSqlDetails.swf, which is obviously retrieved from the Oracle site (I can't write the whole url here as it is my first post).

I've googled but I haven't find anything useful: is this a know issue or has anyone seen this before?

Thank you in advance.

[Updated on: Thu, 15 October 2020 09:53]

Report message to a moderator

Previous Topic:	Application Performance Issue
Next Topic:	SQL_Text on SQL Profile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 06:04:20 CDT 2025