As a dba you should keep statistics to analyze the database


Question: Please answer in 500 - 600 words words, APA format with references.

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.

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.

Solution Preview :

Prepared by a verified Expert
Dissertation: As a dba you should keep statistics to analyze the database
Reference No:- TGS02832988

Now Priced at $20 (50% Discount)

Recommended (96%)

Rated (4.8/5)