dbacockpit (tablespace statistics, growth/day)

[Former Member]

We use new dbacockpit according to note 1028624 and have implemented the corrections of note 1042725, 1046668, 1052909, 1076147, 1081265, 1066044.

In difference to the old DB02 (DB02OLD) , I don't see detailed information about the tablespace growth per day:

In new DB02: tablespaces -> Overview, Summary History I see only one line per tablespace with

Begin date End date Tablespace name Size(MB) Chg.size/day Free(MB) Chg.free/day Used(%) Chg.Used/day(%/day) Autoextend Total size(MB), etc.....

but I can't see detailed growth for EACH day like in DB02OLD, when double-clicking on the specific tablespace:

DB02OLD:

29.08.2007 4.608.000 1462.272 1.398.240 3.209.760 138.240 69 28- 242 0 910 12

28.08.2007 3.145.728 0 74.208 3.071.520 927.120 97 29 242 0 898 39

27.08.2007 3.145.728 1048.576 1.001.328 2.144.400 102.200 68 29- 242 0 859 6

26.08.2007 2.097.152 0 54.952 2.042.200 186.880 97 9 242 0 853 13

Is this normally ? Sometimes it's very important to know , when the growth exactly took place and not see the average growth per day....

Kind regards,

Uta

[Former Member · Accepted solution]

Its slightly different now in the way you view growth.

Now to view growth by Day, Month etc you go:

DB02 - Tablespaces -> Detailed Analysis -> Enter the "Equal To" in the drop down and then Tablespace Name in the following drop Down and Continue.

That brings up the Tablespace but the Main Data is still blank in the below section. Double click on the tablespace name and this populates the Main Data section below. Click on the History tab and you can view your data growth by Day, Week or Month.

Hope this helps.

Regards,

Chengappa Ballachanda

[Former Member · Accepted solution]

Thanks a lot. The handling of the new db02 is not very intuitive...

Unfortunately the new DB02 doesn't supply the same functions than the old db02.

I hope, that the functionality of the new DB02 will be better with the next supportpackages....

I see following disadvantages:

1) you have to SELECT the tablespaces explicitly (also * possible ) to see history data

2) no sort of tablespaces by changes/month possible, because thes data is only on the detail screen and history tab available, but not in the overview of selected tablespaces

3) if different tablespaces selected, the last selected tab is not memorized. To see the detailed history for several tablespaces, you have to click 3 times (name of tablespace, history tab, months tab)

Perhaps the developpers also read this forum.....;-)

Regards,

Uta

[Former Member]

see please the SAP Note 1002840

You should check if your monitored database is contained in table. ORA_MON_DBCON

ORA_MON_DBCON and table DB02_COLL_PLAN shouldn't be empty.

[Former Member]

Possibly you have to execute the report RSORACUP according to the sap note 1002840. Read please this note very carefully.

After applying this note you should plan the job SAP_COLLECTOR_FOR_PERFMONITOR and update in the transaction dbacockpit dbacockpit Platz- Space Overview

[Former Member]

did you check if the ORA_MON_DBCON and table DB02_COLL_PLAN aren't empty? ORA_MON_DBCON should contain at least one database connection.