oracle学习11g性能调优官方PPTless_02.pptVIP

Oracle Database 11g: Performance Tuning 2 - * Accessing the Database Home Page You can access EM Database Control by opening your Web browser and entering the following URL: https://host name:port number/em. Host name is the name or address of your computer. Port number is the EM Database Control HTTP port number that is specified during installation. The default port is 1158. You can find the value for your UNIX system in the $ORACLE_HOME/install/portlist.ini file. For Windows you can find the file in the %ORACLE_HOME%\install directory. The Enterprise Manager Database Home page is your starting point to monitor and administer your database. Use the Database Home page to: Determine the current status of the database by viewing a series of metrics Start or stop the database Access the performance, administration, and maintenance of the database environment via tabs with each tabbed page displaying subsections Oracle Database 11g: Performance Tuning 2 - * Enterprise Manager Performance Pages The Database Home page is the starting point. General database health and performance information is presented on the Home page with links and drilldowns to detailed information. Metrics are presented on the Database Home page in the following categories: General: This category provides a quick view of the status of the database and provides basic information about the database. The status can be Up, Down, Under Blackout, Unmonitored, or Unknown. From this section, you can access other pages for more details such as the Properties page, the Host Home page, the Listener Home page, or the ASM Home page. Host CPU: This category displays a bar chart showing relative CPU utilization of the Oracle database host. The 100% (on the chart) represents the total CPU that the host system can provide. Two values appear in the bar chart. The darker color bar at the bottom represents how much of the CPU this instance is consuming. The upper, lighter color represents all other processes. Thes