Alert monitoring-->Alert tree-->optimizer-->update statist shows red color

[Former Member]

hi Experts ,

can you please clarify me about these things

1) in my system Ora_space >Alerts>Alerts monitor>Alert tree>Performance-->optimizer& buffer shows red color

in optimizer shows last update statistics----

---

55 days >30 days -55 >30 2 since last successful update statistic

in buffers it shows Redo log buffer -

---

2500 < 3000 -2500 redo entries per redo space request

plz tel me the process of update statistic and also why buffer shows this message

Edited by: swathimatta on Jul 8, 2010 3:12 PM

[JPReyes · Accepted solution]

Check the "Update Statistics" job is scheduled to run at least once a week in DB13

Regards

Juan

[Former Member · Accepted solution]

yes

thanks for helping me both of you here i finished my optimizer update with successful

thanks & regards

[Former Member]

Are you running the statistics on a regular basis? Check db14 -> brconnec

Kind regards,

Mark