Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] CPU utilization on system level

Kostya Alexandrov

2006-11-15

Replies:

About elevator - kernel logic for optimize io. Default for 2.6 kernels
is CFQ, Oracle strongly recommend to use deadline.
If you need details - how it works, ask google ;) lot of useful
documents exists.
Also, as far as I understand you use x86 os and 32G of RAM, isn't
possible to use x86-64 OS and Oracle?

See example:

db0:/opt/oracle # cat /boot/grub/menu.lst
...skipped...
title Linux
  kernel (hd0,0)/vmlinuz root=/dev/sda5 vga=0x317 selinux=0
splash=silent console=tty0 resume=/dev/sda2 elevator=deadline showopts
  initrd (hd0,0)/initrd
...skipped...

Andrew Edunov wrote:
> sunset:~ # cat /proc/meminfo
> MemTotal:   33277372 kB
> MemFree:     365756 kB
> Buffers:      36832 kB
> Cached:     30371704 kB
> SwapCached:     5872 kB
> Active:     11600160 kB
> Inactive:   20353716 kB
> HighTotal:   32636632 kB
> HighFree:      4092 kB
> LowTotal:     640740 kB
> LowFree:     361664 kB
> SwapTotal:   33559776 kB
> SwapFree:   33448668 kB
> Dirty:         248 kB
> Writeback:      120 kB
> Mapped:     3205364 kB
> Slab:       225092 kB
> Committed_AS: 3955652 kB
> PageTables:   691956 kB
> VmallocTotal:  112632 kB
> VmallocUsed:   20112 kB
> VmallocChunk:   92320 kB
> HugePages_Total:   0
> HugePages_Free:    0
> Hugepagesize:   2048 kB
>
>
> SQL> show sga;
>
> Total System Global Area 1862270976 bytes
> Fixed Size            1261476 bytes
> Variable Size         788529244 bytes
> Database Buffers      1056964608 bytes
> Redo Buffers          15515648 bytes
>
>
> About 20 connection per minute.
>
> I don't understand your question about elevator.
>
>  
>> In this case so high sys time is strange.
>> According your vmstat output, cs (Context switch) very low, and problem
>> not in task switch.
>> please try to play with filesystem options, none or directio. I see in
>> vmstat wa (IO wait) is always near 0, but
>> can see blocked process.
>>
>> Also I see up to 19M output io. which elevator used?
>>
>> About listener. How many sessions per minute?
>>
>> Give me please output of sqlplus show sga and cat /proc/meminfo
>>  
>
>
>
>  

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.