Re: awr
Date: Wed, 19 Aug 2015 00:08:31 -0600
Message-ID: <CAAaXtLDrMV4HKTMS41_Zk2X0xCOpmiJQN+idFgeBfn7o0RE9nA_at_mail.gmail.com>
Lots of vendors will ask for an AWR report, either out of ignorance for the fact that AWR reports are a separately licensed feature or (sometimes) as a lazy short-hand for "An AWR report or a StatsPack report." (I suspect that I have occasionally been guilty of the latter, myself.)
For many (most?) porposes, StatsPack reports still provide *almost* as much information as AWR reports -- the data is just not gathered (anywhere near) as efficiently, nor is it packaged as nicely.
If you have a production database (regardless of edition) for which Diagnostics Pack is not licensed (that still seems to be the majority of databases) it is probably a VERY good idea to install StatsPack, and gather snapshots at regular intervals. When a vendor (or Oracle Support) asks for an AWR report, just give them a StataPack report instead, and explain (if necessary) that this is all they are going to get. A StatsPack report will usually give your vendor what they are looking for.
Note that Oracle Support will occasionally do the same thing. They might even tell you (as they have told *me* in the past) that it is "okay" to run an AWR report for them when they request it. That is incorrect; the OLSA contains no language to support that claim. NEVER run an AWR report unless you are licensed to do so.
--- By the way, AWR is *always* installed. To the best of my knowledge, it still cannot be removed. On Mon, Aug 17, 2015 at 10:21 AM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:Received on Wed Aug 19 2015 - 08:08:31 CEST
> The vendor keeps asking for information from awr. I know we didn’t pay
> for it but how do I tell if it’s been installed?
>
> We do have 11g enterprise edition.
>
>
>
>
>
> Brian
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
-- http://www.freelists.org/webpage/oracle-l