DBA Home

Simple Administration Concepts :

1. Introduction to Oracle Database
2. Managing Tablespaces and Datafiles
3. Managing REDO LOGFILES
4. Managing Control Files
5. Managing the UNDO TABLESPACE
6. SQL Loader
7. Export and Import
8. DATA PUMP Utility
9. Flash Back Query Features
10. BACKUP AND RECOVERY
11. Log Miner

SQL scripts for DBA work easy

1. General Database Information
2. Disk I/O, Events, Waits
3. Table space Information
4. Session Statistics
5. Hit/Miss Ratios
6. User Information
7. Rollback Segments
8. Full Table Scans
9. Contention/Locking
10. Redo Log Buffer
11. Data Dictionary Info
12. Miscellaneous Reports
13. Shared Pool Information
14. Cursor/SQL Processing
15. Database Objects
16. Tables/Indexes

DBA Interview Questions

1. Most Important SQL statements for the interview
2. Unix related Oracle DBA Interview Questions
3. Backup & Recovery Questions for an Oracle DBA
4. DBA Interview Questions Technical