UNIX Commands/ Oracle Performance monitor
Question1
Command System activity report (sar)
The sar command is defined to have the general task of collecting, reporting or rather saving the information resulted from the system activities. The sar command initiates the writing onto the standard data/ information output the selected information regarding a cumulative activity counter performed in the operating system. The command is applicable in the sense of displaying the reports according to the duration that the system takes in writing the information. In the accounting system, the values can be outlined in count and the interval parameters and in this case the system will write the information depending on the intervals in seconds’ time. When the interval parameter is set at zero, then the sar command will only display the average statistics for the duration from the time the system was started. On the other hand the system interval parameter is defined and specified in absence of a count parameter then the sar command will generate reports continuously. Sar command is used for real time monitoring of the linux system performance in statistics (Prasad, 2014. The sar command is also applicable in collecting and storing information upon analysis bottlenecks are easily identified (Nataraj, 2011).
The Unix "Who" command
The who command is very useful for the display and printing of the information that related to the end users of the systems that are currently logged in the system. The who commands is executed for a duration of approximately 5 minutes and in the displays it displays the following information. the list of the users logged in the system, the time of the last boot, a list of dead processes, the list of login processes, counting of the login names and generally displaying the information of the logged on end users. The purpose of the who command is to display the end users logged on the systems. if person bypasses the server you can use the command to determined the persons that logged on your server (Gite, 2014).
Question 2A
Cumulative statistics
The cumulative statistics is described under cumulative probability and the cumulative frequency as well. The cumulative frequency defines the number of observations made that lies either above or below the particular value defined in the data set. And it is achieved or rather calculated by the use of the frequency distribution table.teh cumulative frequency is the same as the cumulative percentages though the percentage is advantaged with the power of easily comparing the sets of data. The cumulative probability is described as the probability that describes the value within a random variable will tend to fall within a specified value range.
Database metrics
Database metrics describes the activities undertaken about monitoring the performance of the database. The performance metrics are applied in the assessment of the health of the enterprise database. The metrics can focus on eth business transactions, the query performance, user and query conflicts, the capacity, configuration and the NoSQL databases (Habib, 2015). At times, the metrics are defined as long-term o average and they include the throughput, execution time, the concurrency and utilization.
Question 2B
Automatic workload capture feature
The workloads capture module s quite applicable in the monitoring of the external users activities and related transactions. The feature facilitates monitoring by recording the entire requests made by the database external users to the Oracle database. Once the feature is enabled, all the request done by the external users are redirected and stored in the capture files and this will facilitate the tracking of the transaction done by the external users. The capture files stores the information of SQL text, the bind values and the transaction information (Oracle, n.d).
Automatic performance diagnostic feature
The feature is applied when a problem is felt to have occurred within the database and thus the necessity of performing accurate and timely diagnosis of the developed problem before any measure of making changes.Teh automatic database diagnostic monitor undertakes an analysis of a top down series with the prior identification of the symptoms and then refining the symptoms until the cause of the performance problem is determined.
References
Gite, V. (2014). Linux / Unix: who Command Examples To List Users on The Systems.
Habib, O. (2015). Top 6 Database Performance Metrics to Monitor in Enterprise Applications.
Nataraj, R. (2011). 10 Useful Sar (Sysstat) Examples for UNIX / Linux Performance Monitoring.
Oracle, (n.d.). Database Real Application Testing User's Guide.
Prasad, D. (2014). Tutorial for monitoring Tools SAR and KSAR with examples in Linux.
Sherry Roberts is the author of this paper. A senior editor at MeldaResearch.Com in research paper services if you need a similar paper you can place your order for professional research proposal writing services.