Re: License for V$ACTIVE_SESSION_HISTORY
From: joel garry <joel-garry_at_home.com>
Date: Tue, 4 Oct 2011 09:18:15 -0700 (PDT)
Message-ID: <d2813b8a-304e-4610-9609-df3dbe084832_at_db5g2000vbb.googlegroups.com>
On Oct 4, 5:47 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On Oct 2, 7:57 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
> > 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 athttp://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...
>
> "Funny how there is a different oracle product named sash" Sash is
> not an Oracle product, but is Kyle's offering as a poor man
> substitute. If like us, you or your customer cannot afford the EM
> Diagnostic/Performance Pack licenses then this code provides pretty
> much the same information without having to pay a fee.
>
> HTH -- Mark D Powell --
Date: Tue, 4 Oct 2011 09:18:15 -0700 (PDT)
Message-ID: <d2813b8a-304e-4610-9609-df3dbe084832_at_db5g2000vbb.googlegroups.com>
On Oct 4, 5:47 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On Oct 2, 7:57 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
> > 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 athttp://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...
>
> "Funny how there is a different oracle product named sash" Sash is
> not an Oracle product, but is Kyle's offering as a poor man
> substitute. If like us, you or your customer cannot afford the EM
> Diagnostic/Performance Pack licenses then this code provides pretty
> much the same information without having to pay a fee.
>
> HTH -- Mark D Powell --
Google was not my friend :-)
Googling oracle sash gets things like
http://download.oracle.com/docs/cd/E17645_01/doc.50/e17647/cnf_provisioning.htm
Kyle's offering is called s-ash, but google removes the - unless you quote it. http://lmgtfy.com/?q=oracle+%22s-ash%22 Sometimes, maybe, it's hard to know with mysterious context sensitive searches google allegedly has, that of course cannot distinguish between oracle as a product provider and oracle referenced by a non-oracle product. So we just scream in our best Pee-Wee Herman voice "namespace collision!" and go on our merry way.
jg
-- _at_home.com is bogus. Who Is The Doctor And Why Is He Referencing Pee-Wee's Playhouse? http://ponywithafez.tumblr.com/post/10921971354/mecca-lecca-hi-mecca-hiney-whoReceived on Tue Oct 04 2011 - 11:18:15 CDT