Skip to Content
avatar image
Former Member

dbacockpit (tablespace statistics, growth/day)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 31, 2007 at 02:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Sep 25, 2007 at 01:24 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded