Oracle DB CPU Utilization

[Former Member]

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

-

---

[Former Member]

Hi Arun,

You can get this information from the rsorastt reports.

You can check Note 1299493 - Loadable SAP Support Monitors in the DBA Cockpit (and download report itself). Unfortunatly there luck of information regarding this report.

You should unzip two files from the reports (rsorastt.txt and rsorastt.xls) and place to the root of the disk (for example, c:\). Tnen start report RSORASTT and run report under DB Time Overview -> CPU time -> CPU Time History. You should get the same result as you was given by SAP.

Best regards,

Denis

[Former Member]

Hi Arun,

Since you are using ECC6, try the ST06N tx code.. You are also saying that saposcol is not running on the DB server. But ideally there has to be a SAPOSCOL running on the DB server as well. This was confirmed with SAP MAx Attention team when they were analysing our systems.

This will help you a lot to analyse the CPU utilization..

regards,

Anup

[markus_doehr2]

What operating system are you using? All supported OS'ses have tools to measure and log performance data.

Saposcol can also be installed without having a SAP instance running.

Markus

[Former Member]

Use top command for hpux, for aix use topas to view cpu consumption for individual processes thereby identify the process id which are consuming high cpu.

Regards

Kausik

[Former Member]

Hello Mark,

This is the report from the Database Server. But we dont have a SAP instance running on that server. Hence there is no saposcol running there.

Regards

Arun

[Former Member]

Looks like output of saposcol. Check the options of saposcol (http://help.sap.com/saphelp_nw70ehp1/helpdata/en/c4/3a6c19505211d189550000e829fbbd/frameset.htm), you can check for example only the cpu usage with certain parameters (check option -d).

Or it might be a Unix command like stat or sar. On what platform are you running?

Kind regards,

Mark