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