AnsweredAssumed Answered

Monitoring Oracle Database - Redo_Logs

Question asked by Jean Gomes on Aug 30, 2017
Latest reply on Aug 31, 2017 by Jean Gomes

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

Outcomes