Re: License for V$ACTIVE_SESSION_HISTORY
From: joel garry <joel-garry_at_home.com>
Date: Sun, 2 Oct 2011 16:57:15 -0700 (PDT)
Message-ID: <c106ad7f-f9f5-40bf-aa01-5e6f59fff858_at_g33g2000yqc.googlegroups.com>
On Oct 1, 12:53 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Sat, 01 Oct 2011 18:44:10 +0000, Mladen Gogala wrote:
> > Do I need a license to use V$ACTIVE_SESSION_HISTORY? It's an amazingly
> > useful table but there is a license issue.
>
> OK, I should have read the documentation. Yes, the diagnostic pack
> license is required. I should have known, the retention is regulated by
> DBMS_WORKLOAD_REPOSITORY package.
>
> --http://mgogala.byethost5.com
Date: Sun, 2 Oct 2011 16:57:15 -0700 (PDT)
Message-ID: <c106ad7f-f9f5-40bf-aa01-5e6f59fff858_at_g33g2000yqc.googlegroups.com>
On Oct 1, 12:53 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Sat, 01 Oct 2011 18:44:10 +0000, Mladen Gogala wrote:
> > Do I need a license to use V$ACTIVE_SESSION_HISTORY? It's an amazingly
> > useful table but there is a license issue.
>
> OK, I should have read the documentation. Yes, the diagnostic pack
> license is required. I should have known, the retention is regulated by
> DBMS_WORKLOAD_REPOSITORY package.
>
> --http://mgogala.byethost5.com
You probably already know about s-ash, but in case anyone didn't, worth a look at http://ashmasters.com/ash-simulation/
Funny how there is a different oracle product named sash.
jg
-- _at_home.com is bogus. http://www.v3.co.uk/v3-uk/news/2113703/oracle-openworld-live-coverage-larry-ellison-keynoteReceived on Sun Oct 02 2011 - 18:57:15 CDT