Problem solve Get help with specific problems with your technologies, process and projects.

What should monitoring reports identify

What should standard Oracle production database daily/weekly monitoring reports have?

On a daily basis, I check for the following, normally first thing in the morning:

1. Is the database up and running?
2. Is the listener up and running?
3. Are there any errors in the Alert Log that need my attention?
4. Is there plenty of disk space available for my Archived Redo Logs?

On a weekly basis, I check the following:

1. How has my instance been performing this week? I might look at Statspack reports.
2. Do I have enough room for my tables to allocate their next extent(s)?
3. Are my segments close to maxextents?

On a monthly basis, I check the following:

1. What are my trends for capacity planning?

Those are the basic things I check for. Each instance is a little different so I may modify my list for that specific case.

This was last published in October 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.