Re: Oracle Stats
Date: Sun, 17 May 2009 21:11:08 -0700 (PDT)
Message-ID: <8f846e02-c58a-45d2-a107-227dd8d6e22c_at_j9g2000prh.googlegroups.com>
On May 18, 3:08 am, ddf <orat..._at_msn.com> wrote:
> 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
Well - I'm not sure you tried this on your environment. Add one more to the affected list.
[sachina_at_ad4-stg1db-101]~% uname -a
Linux ac4-stg1addb-101.ysm.ac4.yahoo.com 2.6.9-78.ELsmp #1 SMP Wed Jul
9 15:46:26 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
SYSTEM: acsc11s1> select * from v$osstat;
STAT_NAME
VALUE OSSTAT_ID
- ---------- NUM_CPUS 8 0 IDLE_TIME 2146267397 1 BUSY_TIME 423026835 2 USER_TIME 291269459 3 SYS_TIME 101684996 4 IOWAIT_TIME 23031595 5 NICE_TIME 2072511 6 RSRC_MGR_CPU_WAIT_TIME 0 14 LOAD 2.66992188 15 NUM_CPU_SOCKETS 4 17 PHYSICAL_MEMORY_BYTES 1891052 1008
top - 21:01:39 up 88 days, 22:30, 2 users, load average: 2.80, 3.11,
2.62
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 Received on Sun May 17 2009 - 23:11:08 CDT