Re: Oracle Stats

From: <stevedhoward_at_gmail.com>
Date: Mon, 18 May 2009 12:55:17 -0700 (PDT)
Message-ID: <f0a8a415-d226-4c75-addf-f49c24762214_at_q2g2000vbr.googlegroups.com>

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> Received on Mon May 18 2009 - 14:55:17 CDT