1. A DBA should have good awareness of physical database design.
2. He should have the best knowledge of the operating system.
3. He should be excellent in all Oracle utilities and tools.
4. He must be able to deliver a planned database direction to the enterprise.
5. His personality must possess a sharp aptitude to execute the best performance of operating system and Oracle database.
6. He must have excellent and up-to-date knowledge of various scenarios of Oracle backup and recovery.
7. A professional DBA must acquire knowledge of Oracle security management up to maximum level.
8. It is essential for a DBA to execute his role to get knowledge of Oracle applications.
9. He must know the methods hoe Oracle manages and acquires its resources.
10. He should …show more content…
Ans: In Oracle, troubleshooting is a state-of-the-art concept. It defines directions to perform an appropriate process of resolving Oracle performance issues. Oracle is one of the world's largest database. A steep density has turned Oracle into a difficult database hard to troubleshoot.
Q.2: What are the major objectives of Oracle troubleshooting?
Ans: The major objectives of Oracle troubleshooting include:
1. To learn latest troubleshooting methods for optimizing and monitoring the memory usage.
2. To learn an accurate methodology to be used for investigating the Oracle database.
3. To get knowledge how to locate and decide Input / Output storage points, database, and object level.
4. To acquire knowledge of using multiple scripts used to expose session related bottlenecks.
5. To fully understand the techniques that are used to locate and fix SQL issues.
6. To comprehend bottleneck and ratio-based troubleshooting examination.
Q.3: What is the best time to increase copy latches? Mention parameter used to control copy