Db CPU 99% du DB time, mais SQL execute seulement 40% , ou est la CPU ?
Bonjour
suite a une migration de 11 vers 19 , avec changement d'OS et d'hyperviseur , on a constaté un rallongement le temps des traitements:
j'analyse la partie Base de données et je constate quelquechose d'anormal, mon DB time est a 99% du CPU , mais le sql execute represente seulement 40% du db time, je me demande ou est passé ma CPU ? de plus, y a un grand décalage entre le DB CPU et le CPU time
voici un extrait de mon statpack
Top 5
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
CPU time 388 60.9
db file sequential read 232,199 174 1 27.2
log file parallel write 27,351 29 1 4.5
log file sync 19,213 24 1 3.7
control file sequential read 18,622 10 1 1.6
-------------------------------------------------------------
Host CPU (CPUs: 2 Cores: 2 Sockets: 1)
~~~~~~~~ Load Average
Begin End User System Idle WIO WCPU
------- ------- ------- ------- ------- ------- --------
2.19 0.80 18.62 7.66 70.45 1.75 |
Time model
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| -> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % DB time
----------------------------------- -------------------- ---------
DB CPU 1,482.2 98.9
sql execute elapsed time 680.8 45.4
parse time elapsed 10.5 .7
hard parse elapsed time 1.4 .1
connection management call elapsed 1.1 .1
hard parse (sharing criteria) elaps 1.0 .1
PL/SQL execution elapsed time 0.4 .0
repeated bind elapsed time 0.0 .0
sequence load elapsed time 0.0 .0
DB time 1,498.9
background elapsed time 85.3
background cpu time 33.1
------------------------------------------------------------- |
