OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P22: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | Using EM Support Workbench 981 Gathering Additional Diagnostic Information On the Problem Details screen under the Investigate and Resolve section you have various options. On the Self Service tab you have links available to gather more information about the problem. If you prefer self-service you can run more checks on the database diagnose the current problem or resolve the issue by running the SQL Repair Advisor if the error is caused by a SQL Statement . The following are your options on the Self Service tab Assess Damage Run Checkers Run the database health check again to find more issues. Database Instance Health Show the database health screen which shows the number of incidents and problems by hour for the last 24 hours. Diagnose Alert Log Shows the alert log entries related to the incident. Related Problems Across Topology Shows any other incidents that may be related to the current problem. Diagnostic Dumps for Last Incident Shows the dump and trace files associated with the incident. Go to Metalink and Research Metalink is Oracle s support site where you can search and find solutions to the issue. Resolve SQL Repair Advisor Since the problem is caused by a SQL statement you can run the SQL Repair Advisor to fix the SQL issue. You can use the tools under Diagnose to gather more information about the incident and problem. If you have identified the SQL causing the problem and you find an issue with the SQL you can resolve the problem by yourself. You may also get an answer by searching Oracle s support website Metalink. Contacting Metalink is discussed later in the chapter. After self-service if you could not resolve the problem or could not find more information about the problem of symptoms you can contact Oracle Support. EM Support Workbench makes contacting Oracle Support easy without having to remember the URL or phone number and gathers all the information that would be of help to the support analyst. Let s go through the next steps of Support .
