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.
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