Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
CPU utilization on system level

CPU utilization on system level

2006-11-16       - By Ivo.Libal@(protected)

 Back
Reply:     1     2  

Hi!
do you have 29GB file cache? Do you use directIO?
Does your database write a lot to disks?
Regards
Ivo




"Andrew Edunov" <and@(protected)>
16.11.2006 10:52

An
"'Tom Sightler'" <tsightler@(protected)>
Kopie
<suse-oracle@(protected)>
Thema
RE: [suse-oracle] CPU utilization on system level






Hi again!

Some news:

sunset:~ # cat /proc/meminfo
MemTotal:     33277372 kB
MemFree:        571576 kB
Buffers:         50596 kB
Cached:       29135348 kB
SwapCached:          4 kB
Active:        9099044 kB
Inactive:     21225556 kB
HighTotal:    32636632 kB
HighFree:       200196 kB
LowTotal:       640740 kB
LowFree:        371380 kB
SwapTotal:    33559776 kB
SwapFree:     33559772 kB
Dirty:             212 kB
Writeback:           0 kB
Mapped:        1177320 kB
Slab:           202236 kB
Committed_AS:  1656032 kB
PageTables:      43936 kB
VmallocTotal:   112632 kB
VmallocUsed:     19836 kB
VmallocChunk:    92668 kB
HugePages_Total:  1024
HugePages_Free:    150
Hugepagesize:     2048 kB


sunset:~ # sar
Linux 2.6.5-7.282-bigsmp (sunset)       11/16/06
10:30:01          all     45.62      0.00     24.20      6.13     24.06
10:40:01          all     61.94      0.00     34.22      0.48      3.35
10:50:01          all     65.69      0.00     34.18      0.06      0.07
11:00:04          all     55.89      0.00     32.69      0.63     10.79
11:10:01          all     59.31      0.00     31.46      0.72      8.51
11:20:01          all     62.78      0.00     33.33      1.73      2.16
11:30:01          all     55.71      0.00     28.24      0.47     15.58
11:40:01          all     47.62      0.00     26.79      0.85     24.74
11:50:01          all     36.36      0.00     20.58      3.65     39.41

11:50:01          CPU     %user     %nice   %system   %iowait     %idle
12:00:01          all     40.71      0.00     22.98      2.24     34.07
12:10:01          all     48.73      0.00     28.34      3.66     19.26
12:20:01          all     55.78      0.00     29.35      2.37     12.50
12:30:03          all     64.31      0.00     31.16      0.20      4.33
12:40:01          all     60.99      0.00     30.78      0.71      7.52
Average:          all     39.68      0.00     24.09      3.64     32.59

sunset:~ # vmstat 5
procs -- ---- ---memory-- ---- -- ---swap-- -- --io---- --system--
----cpu----
r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy
id
wa
1  1      4 466144  51712 29146568    0    0   188   116  316    84 39 24
34  4
3  0      4 470476  51796 29146484    0    0     2  7247 2667  1965 36 22
32  9
1  0      4 557028  51876 29146404    0    0     8  3554 3045  2565 28 17
50  5
2  0      4 548612  52020 29146260    0    0   152   178 3597  2944 20 11
67  2
2  0      4 544504  52100 29147208    0    0    91   448 3517  2905 37 17
45  1
1  0      4 541272  52148 29147160    0    0     0   604 3624  2962 28 13
59  0
1  0      4 540420  52276 29147032    0    0    54   270 2731  2013 20 11
66  3
3  0      4 540908  52368 29146940    0    0     2   186 1123   173 27 15
57  0
6  1      4 519348  52496 29147840    0    0   312   231 1245   315 50 28
18  3
3  0      4 524788  52600 29147736    0    0    34   185 1087   135 49 25
26  0
3  0      4 529244  52680 29148684    0    0     5   452 1160   181 41 27
32  0
2  0      4 528284  52760 29149632    0    0     0   482 1141   139 51 29
20  0
2  0      4 508692  52864 29149528    0    0     2   373 1175   122 44 27
28  1
3  0      4 503592  52952 29149440    0    0    56   136 1081   117 36 24
39  2
2  0      4 524292  53040 29150380    0    0    37   244 1090   123 34 20
45  1
3  0      4 510652  53124 29151324    0    0   154   228 1257   272 34 20
46  1

Still 20-30% takes kernel. Any ideas?

Best regards,
  Andrew Edunov.


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