Re: DBA_HIST_SQLSTAT/SQLTEXT View and Function I created

From: Peter Gram Miracle A/S <pgr_at_miracleas.dk>
Date: Sat, 1 Dec 2012 10:46:22 +0100
Message-ID: <CAP=Qj1_Kk_MJLCemq-jmGZ960k_XJf=MVpdQMC_+F4yKrgBGyw_at_mail.gmail.com>

Hi Christostopher
I think you should put a warning / information in the script that they require that the Oracle Diagnostic pack has been licensed. And if you use this script Oracle License Management Services (LMS) will detect the use and charge you for Oracle Diagnostic pack.

/Gram

Best Regards / Venlig Hilsen

Peter Gram

Miracle Consulting <http://www.miracleas.dk> Borupvang 2c, 2750 Ballerup, Denmark
Cell: (+45) 53747107 Home: (+45) 38745696 Office Phone: (+45) 44668855 Office Fax: (+45) 44668856 Mail: peter.gram_at_miracleas.dk
OakTable member <http://www.oaktable.net> <http://www.oaktable.com/>

---

On 1 December 2012 02:08, <Christopher.Taylor2_at_parallon.net> wrote:

> Guys/Gals,
> Here are a couple of scripts (very rough probably - but hey, I'm proud of
> them).
>
> The first is a pretty standard view - it limits the query time range to a
> specific window of 12am to 5am (because that is the period I most
> interested in usually)
> 1. http://codepaste.net/2a9o83
>
> The second script is a Pipelined function I wrote to use the above view
> but enabled to pass in a specific start time and end time interval. This
> interval needs to encompass your AWR snapshot intervals. So if your
> snapshot interval is one hour, then the start datetime/end datetime will
> need to be at least an hour apart.
> 2. http://codepaste.net/pdcfo5
>
> I thought these might be useful to someone besides me. (Caveat: The
> hints I used in the SQL may or may not be useful but seemed to give a bit
> of better performance overall though I didn't actually test whether that
> was true).
>
>
>
> Chris Taylor
> Oracle DBA
> Parallon IT&S
> christopher.taylor2_at_parallon.net<mailto:christopher.taylor2_at_parallon.net>
> www.parallon.net
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Dec 01 2012 - 10:46:22 CET