0 Replies Latest reply on Oct 27, 2015 2:47 PM by rsmdba

    Generating graphic using custom alert in DPA

    rsmdba

      Hi All,

      I created a custom alert in DPA five months ago using a SQL connecting to Oracle database.

      I need now a graphic that has the same information of the alert.

      I think DPA stores alert data in repository and maybe I can collect these information in the graphic I need, but I do not know if it's possible.

      Can someone confirm if is it possible to generate the graphic using custom alert information ?

       

      Resultset of Oracle query is:

      Tablespace               Total (Mb)      Free (Mb)     Used %

      ------------------------------    ----------          ----------           ----------

      PRD11_TBS               428074           12146            97,16

      PRD12_TBS                25064              1055           95,79

      PRD15_TBS               209315            10506           94,98

      SYSAUX                        4030               259           93,57

      USERS                            512                43            91,67

      AUD11_TBS                 152204          43560            71,38

      PRD16_TBS                      100                52            48

      UNDOTBS1                    86003           71347          17,04

      SYSTEM                         96003           90435           5,8

      DPA                                   200               199             ,53

      PRD19_TBS                      4096             4087             ,23

       

      I need that the graphic has database growth by months and how many space it used in each month , which information is available in column TOTAL(MB).

      If it's not possible to use above information, is there a default graphic in DPA that informs Oracle database growth in months ?

       

      Thanks in advance.