Re: Re: RE: Re: Convert sql monitor output to a single HTML file
Date: Tue, 22 Jan 2019 17:07:54 +0100 (CET)
Message-ID: <346677345.34402.1548173274950.JavaMail.webmail_at_bluewin.ch>
Thanks Franck,
Mathias´s solutiuon is too easy. You are no wizzard any more if you do it.
Regards
Lothar
----Ursprüngliche Nachricht----
Von : franck_at_pachot.net
Datum : 22/01/2019 - 16:49 (MN)
An : l.flatz_at_bluewin.ch
Cc : Mathias.Zarick_at_trivadis.com, contact_at_soocs.de, Oracle-L_at_freelists.org
Betreff : Re: RE: Re: Convert sql monitor output to a single HTML file
Hi,
Here is the script I used to decode base64 zlib before knowing that: search for
decode-sqlmon.zip in
https://blog.dbi-services.com/oracle-sql-monitoring-reports-in-flash-html-text
Thanks a lot Mathias, that's amazing. Now I'll control-click everywhere to find some more gems ;)
Regards,
Franck.
On Tue, Jan 22, 2019 at 1:51 PM
l.flatz_at_bluewin.ch <
l.flatz_at_bluewin.ch> wrote:
Hi Mathias,
damn. That works.
Thanks
Lothar
----Ursprüngliche Nachricht----
Von :
Mathias.Zarick_at_trivadis.com
Datum : 22/01/2019 - 13:40 (MN)
An :
l.flatz_at_bluewin.ch,
contact_at_soocs.de
Cc :
Oracle-L_at_freelists.org
Betreff : RE: Re: Convert sql monitor output to a single HTML file
Hi there,
there is another way.
- open the report in browser
- press CRTL and click the sql id, the debug window of flash opens
- toggle the combo box to "active report (uncompressed)"
HTH Mathias
-----Original Message-----
From:
oracle-l-bounce_at_freelists.org <
oracle-l-bounce_at_freelists.org> On Behalf Of
l.flatz_at_bluewin.ch
Sent: Dienstag, 22. Jänner 2019 12:42
To:
contact_at_soocs.de
Cc:
Oracle-L_at_freelists.org
Subject: Re: Re: Convert sql monitor output to a single HTML file
Hi Stefan,
thanks. I will watch the whole session. :)
Regards
Lothar
----Ursprüngliche Nachricht----
Von :
contact_at_soocs.de
Datum : 22/01/2019 - 12:40 (MN)
An :
l.flatz_at_bluewin.ch,
Oracle-L_at_freelists.org Betreff : Re: Convert sql monitor output to a single HTML file
Hello Lothar,
Sure. Please check out Tanel's SQL Monitoring Hacking Session on YouTube - starting at 1:20:00 - https://youtu.be/O5bwdUF0HMk?t=4800
Have fun :)
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website:
http://www.soocs.de
Twitter: _at_OracleSK
> "
l.flatz_at_bluewin.ch" <
l.flatz_at_bluewin.ch> hat am 22. Januar 2019 um 10:37 geschrieben:
>
> Hi,
>
> I am developing some training material. For that purpose I use sql_monitor outputs from real cases.
> I have to edit the files to change tablenames, servernames etc to anonymize the output.
> Years ago that would have been easy since the sql monitor output used to be a html file.
> On the downside it was huge.
> Right now the basis is javascript and the input is CDATA is some converted/ compressed format where you cannot not guess the meaning.
> Does anybody know how to convert the output to html?
> These are monitors from the past I can not regenerate, in case somebody wants to suggest that.
>
> Regards
>
> Lothar
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
-- Franck Pachot Rue des Fossés Dessous 27 CH-1170 AUBONNE - Suisse Tél: +41 79 963 27 22 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 22 2019 - 17:07:54 CET