Re: Manage a database?

In article <7oc8ub$d45$1_at_nnrp1.deja.com>,   Brian Yan <by999_at_hotmail.com> wrote:
> Hi everyone,
>
> I am a newbie on Database admin. I was just assigned to manage two
> production instances. Could anyone tell me what kind of routine (admin
> works) I should perform regularly? (For example, space monitoring,
> performance monitoring? What kind of parameters I need to monitor
> for space and performance? What else I need to monitor regularly? )
>
> Thank you very much for your help!
>
> Brian
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

This is a HUGE question you have asked. Have you been to the Oracle Education Database Administration courses? If not, they are to be highly recommended and they will give you a good start. Of course, as you become more experienced, you will learn much more than the training can give you, but you have to start with the foundation.

Here are the things I closely monitor:

- invalid indexes (any found would have to be recreated)
- invalid objects (any found would have to be recompiled)
- I recommend rebuilding any bitmap indexes, daily
- check dbms_job queues for problems
- check available storage in tablespaces
- check the instance alert log for problems
- ensure that all backup and archiving processes have been successful

Hope this helps,
Tim

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 05 1999 - 13:03:49 CDT