Java Mailing List Archive

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

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

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

Alexei_Roudnev

2006-11-15

Replies:

First of all, use HugeTLB. You should not expect low system time, 32 GB of
ram and traditional pages all together.

----- Original Message -----
From: "Kostya Alexandrov" <kaleksandrov@(protected)>
To: "Andrew Edunov" <and@(protected)>
Cc: <suse-oracle@(protected)>
Sent: Wednesday, November 15, 2006 12:56 PM
Subject: Re: [suse-oracle] CPU utilization on system level


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


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