Hi guys,
We want to disable the housekeeper in Zabbix and do it manually. We would like to know which criterions are required to execute the housekeeper, because the (AWR)Report is generated in Oracle 11g as shown below.
> select count(*) from history_log
> delete from history_log where itemid=:"SYS_B_0" and clock<:"SYS_B_1"
What is SYS_B_0 and SYS_B_1?
Does exist another way to delete (history_log)?
Regards
Beza
We want to disable the housekeeper in Zabbix and do it manually. We would like to know which criterions are required to execute the housekeeper, because the (AWR)Report is generated in Oracle 11g as shown below.
> select count(*) from history_log
> delete from history_log where itemid=:"SYS_B_0" and clock<:"SYS_B_1"
What is SYS_B_0 and SYS_B_1?
Does exist another way to delete (history_log)?
Regards
Beza