GeekInterview.com
Series: Subject: Topic:
Question: 5 of 252

daily tasks for an oracle dba

What are key tasks for an oracle dba on daily basis?
Asked by: chandandba | Member Since Mar-2012 | Asked on: Mar 13th, 2012

View all questions by chandandba

Showing Answers 1 - 3 of 3 Answers
bhaskar

Answered On : Mar 15th, 2012

Backups,performance tuning,

  
Login to rate this answer.
Ankur Kaushik

Answered On : Mar 15th, 2012

1.Connectivity: Make sure each database is available and accessible both by logging in via user applications, as well as running test scripts.

2.Backups: Check database and log backups, archiving and offsite storage.

3.Events: check all database logs, application logs and system logs, Agent history, device logs, NIC logs etc. Investigate any job failures

4.Processes: Check that all required processes on the server are running, including Replication

5.Integrity: Perform all database and server integrity checks; look for objects that break rules

6.Indexes: Check on indexes to see if they are being used, need re-creating, or if any are missing

7.Volumetrics: Check resources on the server such as files sizes and disk space, and monitor growth

8.Performance: Check application performance, and performance statistics, using the Perfmon tool; research and resolve any issues.
9.Procedures: Check all Disaster Recovery Plans

10.Security: Look for security policy violations

  
Login to rate this answer.
doc123

Answered On : Mar 22nd, 2012

View all answers by doc123

Daily Tasks of DBA are following.

1. Disk Space checking for all databases, tablespaces, archive log destinations, dump destinations, and backup destinations.
2. All backup successfully finished or not.
3. Backup validation (to restore at testing database).
4. Alert.log checking for any critical errors.
5. Server load monitoring.
6. Network load monitoring.
7. Security auditing.
8. Scheduled process checking.
9. Scheduling database statistics.
10. Maintaining proper documentation.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.