4 Replies Latest reply on Mar 8, 2018 1:54 PM by Steffen Gruebler

    An advice about collecting Oracle AWR data from Oracle RAC DB

    Ahmed Badr

      Hello Everyone,

       

      Currently, we are having a custom ETL solution to collect Oracle AWR Statistics from Oracle DBs (some DBs are on Vertias Cluster (active/passive)).

       

      However, we tried the same solution on a DB that on an ORACLE RAC (Active\ active) and the following Datasets configured came empty :

       

      [14] DBSTAT - Database statistics

      [17] DBEVENT - Database events

      [18] DBRES - Database resources

      [19] DBMEM - Database memory configuration

       

      The following Datasets were ok :

       

      [15] DBSTOR - Database Data storage

      [16] DBCNF - Database configuration data

      [20] DBFSSTOR - Database file system configuration

       

      According to the solution, the following tables/views should contain data :

       

      SYS.DBA_HIST_SYSSTAT

      SYS.DBA_HIST_SNAPSHOT

      SYS.DBA_HIST_DATABASE_INSTANCE

      SYS.DBA_HIST_SYSTEM_EVENT

      SYS.DBA_HIST_RESOURCE_LIMIT

      SYS.DBA_HIST_PGASTAT

      SYS.DBA_HIST_SGA

      SYS.DBA_HIST_OSSTAT

       

      but these ones are having data and the rest is empty :

       

      SYS.DBA_HIST_SNAPSHOT

      SYS.DBA_HIST_DATABASE_INSTANCE

       

      Also, when we  run the ETL Task, 2 nodes were discovered but only 1 had performance metrics and the other had only configration data which is not true as both nodes are active according to the Oracle RAC conifguration.

       

      I would like to know if there is a special ETL configured to collect AWR statistics, or if we could modify this ETL task to handle ORacle RAC