Please answer in 500 – 600 words words, APA format with references
Save the document as 70E
Must meet the requirements
Close to 500 words per question with at least 2 or 3 references for EACH question.
Question 1.
Based on the OS you are using various commands used to monitor Oracle. For example, ‘ps -ef | grep pmon’ can be used via a Unix/Linux system to determine if the process is running. Describe 2 commands and identify the scenarios in which these commands can be used.
Question 2 .
As a DBA you should keep statistics to analyze the database for bottlenecks and performance issues. Alapati mentions two types of statistics, cumulative statistics and database metrics. Explain what they mean to you. Describe two features found in the Oracle Diagnostics Pack and explain how they would help you monitor performance in Oracle Database 11g
Save the document as 70E
Must meet the requirements
Close to 500 words per question with at least 2 or 3 references for EACH question.
Question 1.
Based on the OS you are using various commands used to monitor Oracle. For example, ‘ps -ef | grep pmon’ can be used via a Unix/Linux system to determine if the process is running. Describe 2 commands and identify the scenarios in which these commands can be used.
Question 2 .
As a DBA you should keep statistics to analyze the database for bottlenecks and performance issues. Alapati mentions two types of statistics, cumulative statistics and database metrics. Explain what they mean to you. Describe two features found in the Oracle Diagnostics Pack and explain how they would help you monitor performance in Oracle Database 11g