Re: Oracle Stats

From: ddf <oratune_at_msn.com>
Date: Sun, 17 May 2009 15:08:08 -0700 (PDT)
Message-ID: <c0373c27-fa76-44ab-9ed0-d62e5c2dd96f_at_g19g2000vbi.googlegroups.com>

On May 17, 12:51 am, Ind-dba <oraclear..._at_googlemail.com> wrote:
> On May 16, 2:30 am, "stevedhow..._at_gmail.com" <stevedhow..._at_gmail.com>
> wrote:
>
>
>
>
>
> > On May 15, 11:47 am, a..._at_unsu.com wrote:
>
> > > Statistic                                       Total
> > > -------------------------------- --------------------
> > > BUSY_TIME                                  14,954,028
> > > IDLE_TIME                                 121,666,971
> > > NICE_TIME                                           0
> > > SYS_TIME                                    6,017,299
> > > USER_TIME                                   8,936,729
> > > LOAD                                                3
> > > RSRC_MGR_CPU_WAIT_TIME                              0
> > >>>>>>>>>>>> PHYSICAL_MEMORY_BYTES                          77,192   <<<<<<<<<<
> > > NUM_CPUS                                           16
> > > NUM_CPU_SOCKETS                                     4
>
> > This section is puzzling.  How much RAM do you have?
>
> There is an issue with PHYSICAL_MEMORY_BYTES column in v$osstat view.
> This is well explained in following link.http://phlonx.com/blog/fred/index.php/2009/03/20/vosstat-anomaly/- Hide quoted text -
>
> - Show quoted text -

One person found this problem in one installation of Oracle, on Linux RHEL 4 64-bit. One person. No mention of this on Metalink. One instance of a condition doesn't constitute an 'issue'.

You should really do more research before you post such things.

David Fitzjarrell Received on Sun May 17 2009 - 17:08:08 CDT