Re: AWR report limited to a specific PROGRAM?

From: Taral Desai <taral.desai_at_gmail.com>
Date: Thu, 27 Sep 2012 10:18:06 -0500
Message-ID: <CAO4+9HX8+Z=AGKCZLebaqcdGoZQZU3kb8-Koe6wqHLu=axTwxQ_at_mail.gmail.com>

I think it's ash report where you can provide module or service or some other parameter
FUNCTION ASH_REPORT_TEXT RETURNS AWRRPT_TEXT_TYPE_TABLE

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 L_DBID                         NUMBER                  IN
 L_INST_NUM                     NUMBER                  IN
 L_BTIME                        DATE                    IN
 L_ETIME                        DATE                    IN
 L_OPTIONS                      NUMBER                  IN     DEFAULT
 L_SLOT_WIDTH                   NUMBER                  IN     DEFAULT
 L_SID                          NUMBER                  IN     DEFAULT
 L_SQL_ID                       VARCHAR2                IN     DEFAULT
 L_WAIT_CLASS                   VARCHAR2                IN     DEFAULT
 L_SERVICE_HASH                 NUMBER                  IN     DEFAULT
 L_MODULE                       VARCHAR2                IN     DEFAULT
 L_ACTION                       VARCHAR2                IN     DEFAULT
 L_CLIENT_ID                    VARCHAR2                IN     DEFAULT
 L_PLSQL_ENTRY                  VARCHAR2                IN     DEFAULT
 L_DATA_SRC                     NUMBER                  IN     DEFAULT

On Thu, Sep 27, 2012 at 9:53 AM, <Christopher.Taylor2_at_parallon.net> wrote:

> Anyone know (off the top of your head) how to generate an AWR report that
> is limited to a set of snapshots and for a SPECIFIC program?
> I've considered wiping the AWR information of all extraneous information
> (keeping the info I'm interested in) but before I go too far down that
> road, I thought I'd ask if anyone knew a way to do this.
>
> Regards,
>
> Chris
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Thanks & Regards,
Taral Desai


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

Received on Thu Sep 27 2012 - 10:18:06 CDT