Re: Oracle Stats

From: joel garry <joel-garry_at_home.com>
Date: Mon, 18 May 2009 14:01:15 -0700 (PDT)
Message-ID: <72190769-45cd-43e1-86a4-9962a628d611_at_g3g2000pra.googlegroups.com>



On May 18, 12:55 pm, "stevedhow..._at_gmail.com" <stevedhow..._at_gmail.com> wrote:
> On May 18, 12:11 am, Ind-dba <oraclear..._at_googlemail.com> wrote:
>
>
>
> > Tasks: 222 total,   8 running, 211 sleeping,   3 stopped,   0 zombie
> > Cpu(s):  9.8% us,  3.9% sy,  0.0% ni, 83.1% id,  2.0% wa,  0.1% hi,
> > 1.0% si
> > Mem:  49299496k total, 47409412k used,  1890084k free,   355404k
> > buffers
> > Swap: 12578884k total,      204k used, 12578680k free, 10569544k
> > cached
>
> > See, the difference b/w free memory from "top" command and
> > "PHYSICAL_MEMORY_BYTES" value.
> > They seem very close.
>
> > BTW - One case of H1N1 virus issue in any country in the world is
> > matter of issue :)
>
> >   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
> >  3022 oracle    16   0 27.6g  27g  27g R 21.6 58.6
>
> Add me to the list.  Thanks for the tip!
>
> SQL> select value from v$osstat where stat_name =
> 'PHYSICAL_MEMORY_BYTES';
>
>      VALUE
> ----------
>    7575792
>
> SQL> !free -m
>              total       used       free     shared    buffers
> cached
> Mem:         32335      24952       7382          0        492
> 19307
> -/+ buffers/cache:       5152      27182
> Swap:         6000          0       6000
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
> PL/SQL Release 10.2.0.3.0 - Production
> CORE    10.2.0.3.0      Production
> TNS for Linux: Version 10.2.0.3.0 - Production
> NLSRTL Version 10.2.0.3.0 - Production
>
> SQL>
Of course, this made me look. No problem on 10.2.0.4 hp-ux itanium. But there is a bug listed to make the view look the same on all OS's, maybe.

Getting back to the OP, notice that searching all sources on metalink for AWR comes up with many interesting things, including descriptions of how to use it and an unsupported script useful for demonstrating problems with the report ( metalink doc id 785730.1), and there's some mods to Note: 430473.1 scripts and...

jg

--
_at_home.com is bogus.
Hi Jake! http://xebidy.com/2009/05/100-interest-kiwibank-and-search-engines/
Received on Mon May 18 2009 - 16:01:15 CDT

Original text of this message