Re: WRH$_SESSMETRIC_HISTORY is empty

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Sun, 11 Jan 2009 06:23:37 -0800 (PST)
Message-ID: <712d0209-6172-4d7a-b16b-886e4eb0f2f0_at_g39g2000pri.googlegroups.com>



On Jan 11, 1:09 am, patrick boulay <boul..._at_free.fr> wrote:

snip

> >> I have an issue with this table
> >> It is empty and should contain session level metrics ...
> >> anyone around who have the same issue
> >> patrick
>
> > Might be more people volunteering info if you would give your oracle
> > release and patchset info along with operating system details and
> > things like ( 64 bit / 32 bit ).  Enterprise edition or what?  Oracle
> > option packs licensed or what?
>
> > Did you take a look at metalink?  Normally one might look at DBA views
> > of tables like this.
>
> > I don't get any rows from my 11.1.0.7 64 bit OEL 5.1 system when
> > selecting ( select * from dba_hist_sessmetric_history ).  Give us an
> > example of exactly what you are expecting to see please.
>
> found this linkhttp://www.4tm.com.ar/4tmsite/wordpress/?p=23#comment-5418
> and posted a question about this on this blog

Interesting ... manual technique as pointed out on that site looks like a possible way to drive this inquiry. Received on Sun Jan 11 2009 - 08:23:37 CST

Original text of this message