Redo log space request count too high
877396Jul 22 2011 — edited Jul 22 2011Hi folks,
I am receiving an alert from the monitoring system: "Redo log space request count (20.00) too high for ORCL".
-I only have one redolog switch per day.
-This is my configuration:
SQL> show parameter log_buffer
log_buffer
63065088
SQL> select GROUP#, BYTES/1024/1024, MEMBERS, STATUS from v$log;
GROUP# BYTES/1024/1024 MEMBERS STATUS
---------- --------------- ---------- ----------
4 100 2 CURRENT
5 100 2 INACTIVE
6 100 2 INACTIVE
-This is my alert:
Tue Jul 19 22:00:11 2011
GATHER_STATS_JOB encountered errors. Check the trace file.
Tue Jul 19 22:00:11 2011
Errors in file /u01/app/oracle/admin/ORCL/bdump/orcl_j000_31380.trc:
ORA-20000: Unable to analyze TABLE "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY", insufficient privileges or does not exist
Tue Jul 19 22:00:17 2011
Errors in file /u01/app/oracle/admin/ORCL/bdump/orcl_j000_31380.trc:
ORA-25153: Temporary Tablespace is Empty
I don´t see why I receive this alert, because I have few log switchs and they are big enough. Could the errors in the alert have something to do?
Thanks for your help.
Best regards!