oracle dbcpu,Oracle DB CPU Utilization

Hi there,

We had raised a Customer Message with SAP for slow performance in our production system. The SAP came back to us citing problems with high CPU utilization of our Database server. They gave us a report which is similar to the one mentioned below.

I am not sure that from which transaction did SAP take out this report. Is it DB02 or ST04 ? But we are using ECC6 and these transactions are taking us to DBA_COCKPIT. Please let me how to navigate to this report in DBA COCKPIT.

Regrds

Arun Brelvi

TIMEFRAME

ASH_FG

ASH_BG

ASH_TOTAL

SYSSTAT

OS_USER

OS_SYS

OS_IDLE

OS_IO

OS_TOTAL

-

18.03.2009 06:30:38-18.03.2009 07:00:47

2.14

0.13

2.27

3.06

3.46

1.73

10.50

24.36

40.05

18.03.2009 06:00:27-18.03.2009 06:30:38

9.25

0.10

9.36

11.69

10.17

5.15

4.27

20.31

39.90

18.03.2009 05:30:56-18.03.2009 06:00:27

7.35

0.24

7.59

9.64

8.93

4.96

7.73

18.40

40.01

18.03.2009 05:00:10-18.03.2009 05:30:56

5.88

0.15

6.03

7.36

6.81

4.12

7.91

21.19

40.03

18.03.2009 04:30:16-18.03.2009 05:00:10

3.84

0.09

3.92

5.23

5.07

3.14

17.26

14.60

40.07

18.03.2009 04:00:09-18.03.2009 04:30:16

2.74

0.11

2.86

3.49

5.17

2.18

12.72

19.90

39.96

18.03.2009 03:30:44-18.03.2009 04:00:09

1.60

0.13

1.73

2.25

3.01

1.71

15.33

19.94

39.99

18.03.2009 03:00:22-18.03.2009 03:30:44

2.35

0.13

2.48

3.06

3.22

2.74

12.37

21.66

39.98

18.03.2009 02:30:52-18.03.2009 03:00:22

7.99

0.20

8.19

10.22

9.02

5.13

3.58

22.22

39.94

18.03.2009 02:00:38-18.03.2009 02:30:52

12.00

0.25

12.25

15.03

13.40

6.95

0.64

19.00

39.99

18.03.2009 01:30:30-18.03.2009 02:00:38

12.93

0.27

13.20

16.33

14.61

7.94

0.20

17.13

39.88

18.03.2009 01:00:24-18.03.2009 01:30:30

13.02

0.25

13.28

16.13

14.73

7.81

0.35

17.25

40.14

18.03.2009 00:30:13-18.03.2009 01:00:24

12.42

0.43

12.85

15.00

14.06

8.46

0.81

16.63

39.96

18.03.2009 00:00:53-18.03.2009 00:30:13

10.09

0.55

10.64

11.69

11.98

6.65

3.35

18.02

40.01

17.03.2009 23:30:46-18.03.2009 00:00:53

9.53

0.68

10.21

10.91

11.63

7.25

2.06

19.03

39.98

17.03.2009 23:00:27-17.03.2009 23:30:46

4.77

0.36

5.13

6.12

6.42

4.11

11.34

18.22

40.09

17.03.2009 22:30:50-17.03.2009 23:00:27

3.43

0.24

3.67

4.30

4.81

2.94

10.35

21.84

39.94

17.03.2009 22:00:19-17.03.2009 22:30:50

7.06

0.44

7.50

8.57

9.00

4.63

4.98

21.42

40.03

17.03.2009 21:30:19-17.03.2009 22:00:19

3.79

0.29

4.08

4.82

5.43

3.10

13.22

18.27

40.02

-