Re: graphs in SQL*Plus
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Mon, 24 Dec 2012 12:45:33 +0000
Message-ID: <CAGdek=wDibawk7PtUc4cjw9Ds-c5G1kxkAY=PPjbLRoqmLpLdQ_at_mail.gmail.com>
On Fri, Dec 21, 2012 at 6:23 PM, kyle Hailey <kylelf_at_gmail.com> wrote:
> cool stuff. You mentioned in this blog post that you'd be interested in OEM
> performance graphs in SQL*Plus. For OEM performance page in SQL*PLUs see
> http://dboptimizer.com/2011/02/09/aas-on-awr/
>
> also on github at
>
> https://github.com/khailey/ashmasters
>
> on github see the queries that start with "ash_graph"
>
>
>
>
Date: Mon, 24 Dec 2012 12:45:33 +0000
Message-ID: <CAGdek=wDibawk7PtUc4cjw9Ds-c5G1kxkAY=PPjbLRoqmLpLdQ_at_mail.gmail.com>
On Fri, Dec 21, 2012 at 6:23 PM, kyle Hailey <kylelf_at_gmail.com> wrote:
> cool stuff. You mentioned in this blog post that you'd be interested in OEM
> performance graphs in SQL*Plus. For OEM performance page in SQL*PLUs see
> http://dboptimizer.com/2011/02/09/aas-on-awr/
>
> also on github at
>
> https://github.com/khailey/ashmasters
>
> on github see the queries that start with "ash_graph"
>
>
>
>
Hi Jed,
If you are interesting in displaying graphs in SQL*Plus you should take a
look on
MOATS -
http://blog.tanelpoder.com/2011/03/29/moats-the-mother-of-all-tuning-scripts/
Based on MOATS idea and Tanel's snapper I create my own version of AAS
graph from OEM
in SQL*Plus
http://oracleprof.blogspot.ie/2012/07/average-active-session-in-sqlplus-with.html
regards,
-- Marcin Przepiorowski http://oracleprof.blogspot.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 24 2012 - 13:45:33 CET