hi guys

Just had this doubt and wanted to ask u . because i am not a dba , but was keen to know this has been in my mind for a long time .

objective - To find out Role of dba - Day to Day - lets assume 8 hours minimum or more

Assumption

- U have Database installed and created in the best available hardware in an operating system with good memory, high disk space ,security reasons,in built recovery features etc.
machine is up and running smoothly. absolutely no problem.

- U have all the scripts for automating tasks including backups.
(export, import, archive, noarchive backups)
Backups are taking place and tested also , absolutely no problem in this area.

- u have all database objects created , and application is running fine and The SGA size is ok , init.ora parameters are set properly in accordence to O/S.

- when u created tablespaces u have taken care of storage parameters, and tablespace created with huge size, so u donot have to worry about tablespace getting full.
- u have created the database users and given appropriate privelages and role. so that also is working fine and no problems with the security .

- every thing here is been taken care, every thing is running smoothly in ALL INSTANCES !!! so in day to day work situation what work he will be doing ? Just Monitoring !!!
how is he accountable.?

-- Gayatri