DX Unified Infrastructure Management

  • 1.  Monitoring Oracle Database - Redo_Logs

    Posted Aug 30, 2017 10:19 AM

    Dear CA Guys,

     

    We are monitoring several Oracle Database Servers, but we are not able to collect metrics from REDO_LOGS checkpoint.

     

    We are monitoring following checkpoints:

    check_dbalive
    database_size
    datafile_status
    index_status
    invalid_objects
    lock_waits
    tablespace_free
    tablespace_status
    buf_cachehit_ratio
    buf_cachehit_ratio_users
    database_size
    dbfile_io
    enqueue_timeouts
    gc_blocks_corrupt
    lib_cachehit_ratio
    memory_usage
    redo_logs
    session_waits
    sga_memory
    sga_memory_free
    sort_ratio
    system_stastics
    tablespace_size
    tablespace_temp_free

     

    We use the following script to create a monitoring user:

     

    create user monitoring identified by monitoring default tablespace USERS temporary tablespace TEMP account unlock;
    grant create session, connect, select_catalog_role , select any dictionary, select any table to monitoring;
    grant select on gv_$sort_segment to monitoring;
    grant select on sys.ts$ to monitoring;

     

    I do not know why we do not get metrics from Redo_Logs ? Has anyone had this problem?

     

    Best Regards,

    John M



  • 2.  Re: Monitoring Oracle Database - Redo_Logs

    Posted Aug 31, 2017 08:18 AM

    Hi Jean!

     

    Here is an example to show you to know if you did it:

     

    With the nimsoft account set up in the following way: 

     

    CREATE USER "NIMSOFT" PROFILE "DEFAULT" 
    IDENTIFIED BY "<password>" DEFAULT TABLESPACE "USERS" 
    TEMPORARY TABLESPACE "TEMP" 
    ACCOUNT UNLOCK; 
    GRANT SELECT ON "SYS"."DBA_DATA_FILES" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."DBA_FREE_SPACE" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."DBA_TEMP_FILES" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$ARCHIVE_DEST" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$ARCHIVE_DEST_STATUS" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$DATAFILE" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$DATAFILE_HEADER" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$FILESTAT" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$INSTANCE" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$LATCH" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$LIBRARYCACHE" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$LOG" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$PARAMETER" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$QUEUE" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$RECOVERY_FILE_DEST" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$RESOURCE_LIMIT" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$ROLLSTAT" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$ROWCACHE" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$SESSION" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$SESSION_EVENT" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$SESSTAT" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$SGASTAT" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$SORT_SEGMENT" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$SQLAREA" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$SYSSTAT" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$SYSTEM_EVENT" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$TABLESPACE" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$TEMP_SPACE_HEADER" TO "NIMSOFT" 
    GRANT SELECT ON "SYS"."V_$WAITSTAT" TO "NIMSOFT" 
    GRANT "CONNECT" TO "NIMSOFT"; 

     

    After set all this permissions, do you still have no metrics from Redo_logs?



  • 3.  Re: Monitoring Oracle Database - Redo_Logs
    Best Answer

    Broadcom Employee
    Posted Aug 31, 2017 09:15 AM

    Hi

    The current design of the probe does not create QOS on the Redo_logs checkpoint it only allows for Alarms

     

    Please do raise an idea to have the probe create this Qos

     

    You might also want to look at creating a custom checkpoint

    oracle IM Configuration - CA Unified Infrastructure Management Probes - CA Technologies Documentation 

    regards

    Rich



  • 4.  Re: Monitoring Oracle Database - Redo_Logs

    Posted Aug 31, 2017 10:45 AM

    Richard,

     

    Thank you very much for this information. 

     

    Best Regards



  • 5.  Re: Monitoring Oracle Database - Redo_Logs

    Posted Aug 31, 2017 10:46 AM

    Richards,

     

    Do you know where I can find this information in CA Documentation? 

    I do not find this information about redol_logs. 

     

    Thanks!