7 Monitoring Domain, Node, and Service Performance

Use the Oracle Enterprise Manager Web site to monitor domain, node, and service performance. You can use this information to get an overall picture of the domain's performance, or to determine whether the domain's configuration needs modification.

This chapter tells you how to use the Oracle Enterprise Manager Web site to perform these tasks. Topics include:

Monitoring Domain Performance
Monitoring Node Performance
Monitoring Service Performance
Viewing Log Files
Accessing Metrics and Monitoring Metric Alerts

Monitoring Domain Performance

From the Performance section on the Oracle Files Home page, click Domain Performance & Statistics. The Domain Performance & Statistics page appears.

Figure 7-1 Domain Performance & Statistics Page

Description of the illustration 1domperf.gif

From this page, you can access statistics, usage charts, tables, and summaries to evaluate system performance and guide you in making any necessary changes to your configuration. Table 7-1 lists the various charts, graphs, and tables and shows you which subtab and view names you should select to access the information.
Select one of the four subtabs:
- The General subtab provides general information such as information about document storage and user quota.
- The Documents subtab provides system-wide information about documents.
- The Sessions subtab allows you to view the connected sessions by server type.
- The Overall Usage subtab lets you monitor sessions, threads, and memory by node and host.
To refresh the information, click the refresh button on your browser, or click the Refresh Data icon in the upper right portion of the page.
To navigate between the table view and the chart view, make a selection from the Select a View list and click Go.

Table 7-1 Reference to Statistical Information about the Domain and Node

Chart, Graph, or Table Name	Statistics or Information Displayed	Subtab	Select a View Item
General Information	A tabular display listing: Database URL (connect string) for the database containing the Oracle Files schema where the statistics are calculated Schema name for the Oracle Files instance Total number of user accounts Total users who own documents in the system Quota allocated for all users Quota consumed by all users	General	N/A
Document Table	Document distribution and document space consumption.	Documents	Table
Document Distribution Chart	Document distribution displayed by MIME type (displays a bar chart comparing quantities of the different types of documents stored in the system).	Documents	Distribution Chart
Document Consumption Chart	Space consumed displayed by MIME type.	Documents	Consumption Chart
Session Table	Tabular display of the total number of connected sessions per protocol server or agent.	Sessions	Table
Session Chart	Pie chart of total number of connected sessions per protocol server or agent. The sessions for all the agents are displayed as a combined result.	Sessions	Chart
Overall Usage Table by Node	Total connected sessions, threads, and memory consumed by each node in the domain.	Overall Usage	Table by Node
Overall Usage Table by Host	Total connected sessions, threads, and memory consumed by each host in the domain.	Overall Usage	Table by Host
Overall Session Usage Chart by Node	Bar graph showing the total number of connected sessions and consumed threads by each node.	Overall Usage	Session Chart by Node
Overall Session Usage Chart by Host	Bar graph showing the total number of connected sessions and consumed threads by each host.	Overall Usage	Session Chart by Host
Overall Memory Usage Chart by Node	Bar graph showing the total amount of memory consumed by each node.	Overall Usage	Memory Chart by Node
Overall Memory Usage Chart by Host	Bar graph showing the total amount of memory consumed by each host.	Overall Usage	Memory Chart by Host

Monitoring Node Performance

From each Oracle Files Node page, click Node Performance & Statistics to display summary-level information about that node.

Figure 7-2 Node Performance & Statistics Page

Description of the illustration 2nodperf.gif

Monitoring Service Performance

You can view statistical information about the Committed Data Cache, the Read-Only Connection Pool, and the Writable Connection Pool for each service. You can also reset the statistics.

On the Oracle Files Home page, click the node whose service you want to monitor.
On the Node page, click the service (for example, IfsDefaultService).
On the Service page, scroll to the Performance section.
Click the link to the statistics you want to view: Committed Data Cache Statistics or Connection Pool Statistics.

Figure 7-3 Committed Data Cache Statistics

Description of the illustration data.gif

Figure 7-4 Connection Pool Statistics

Description of the illustration pool.gif
Click Reset Statistics in the Committed Data Cache, Read-Only Connection Pool, or Writeable Connection Pool areas to reset cache or connection pool statistics.

Viewing Log Files

Read the following sections for information on the Oracle Enterprise Manager Web site, Grid Control, and Oracle Files logs.

Oracle Enterprise Manager Web Site Logs and Grid Control Logs

The Oracle Enterprise Manager Web site and the Grid Control both generate log files.

Oracle Enterprise Manager Web site logs are located in:

$ORACLE_HOME/sysman/log: em-servlet.log, emd.log, em-application.log

If you are using the Grid Control, its logs are located in:
```
$ORACLE_HOME/sysman/log: emoms.log, emoms.trc
```

Oracle Files Logs

Log files are generated by the domain controller and by each node.

The domain controller log records major state transitions of its nodes (such as started, failed, or restarted) and provides centralized data on overall domain health. The location of the domain controller log cannot be changed. The domain controller log is located in:
```
$ORACLE_HOME/ifs/files/log/transferred_domain_name/DomainController.log
```
The regular node log records the same type of information for each node. This log is useful for troubleshooting protocol servers and agents. All errors are logged with stack traces. Log file properties, such as Log Level and Rotation Interval, are specified in the node configuration of the node being monitored. By default, the node log is located in:
```
$ORACLE_HOME/ifs/files/log/transferred_domain_name/node_name.log
```
The HTTP node log records the same type of information for each HTTP node. This log is useful for troubleshooting the Oracle Files application, the WebDAV server, and Oracle FileSync. All errors are logged with stack traces. By default, HTTP node log files are located in:
```
$ORACLE_HOME/j2ee/OC4J_iFS_files/application-deployments/files/OC4J_iFS_files_
default_island_1/application.log
```
and
```
$ORACLE_HOME/opmn/logs/OC4J_iFS_files.default_island.1
```
The ifsctl log is located in:
```
$ORACLE_HOME/ifs/files/log/ifsctl.log
```
The Oracle Files Configuration Assistant log is located in:
```
$ORACLE_HOME/ifs/files/log/FilesConfig.log
```

You can set various options for these log files, such as whether to overwrite the log each time the domain is started, through the domain and node configuration properties. See "Domain Properties" and "Node Configuration" for more information.

Accessing Metrics and Monitoring Metric Alerts

If you are using Oracle Enterprise Manager 10g Grid Control, you can access Oracle Files metrics from the Grid Control. The following sections provide information about how to access the metrics and how to set up metric collection:

The Grid Control Management Agent
Managing Oracle Files with the Grid Control
Accessing the Grid Control
Changing the Default Metric Collection Behavior
Viewing Oracle Files Metrics in the Grid Control
Metric Thresholds and Metric Collection Intervals

For more information about the metrics available for Oracle Files, click Help on any Grid Control Metrics page. For more information about the Grid Control, see Oracle Enterprise Manager Concepts.

The Grid Control Management Agent

Before you can use the Grid Control to view Oracle Files metrics, you must install a separate Oracle Management Agent in its own Oracle home, and configure it to connect to the Grid Control. To do this, choose the "Additional Management Agent" option in the Oracle Universal Installer. The metrics collected by the Grid Control Management Agent are uploaded to the Oracle Management Service (OMS).

The Management Agent that was installed in the Oracle9iAS Oracle home cannot be used by the Grid Control; instead, it is used by the Oracle Enterprise Manager Web site in that Oracle home. The metrics collected by the Oracle Enterprise Manager Web site Management Agent are consumed by the Oracle Enterprise Manager Web site and are not uploaded to the OMS.

Managing Oracle Files with the Grid Control

Metric collection is not set up automatically. You must configure Oracle Enterprise Manager to manage Oracle Files. For details on how to do this, see Oracle Enterprise Manager Managing Oracle Collaboration Suite on the Oracle Technology Network at:

http://otn.oracle.com

Accessing the Grid Control

To access the Grid Control, perform the following steps:

Use the following URL to access the Grid Control from a Web browser:
```
http://host_name:port/em
```
If the Management Service is running in non-secure mode, access the Grid Control using the Web Cache port. Using the Web Cache port is a prerequisite for self-monitoring. The default port is assigned in the range of 7777-7877. For example:
```
http://testcomputer.us.oracle.com:7777/em
```
If the Management Service is running in secure mode, access the Grid Control over HTTPS. The default port is assigned in the range of 4443-4543. For example:
```
https://testcomputer.us.oracle.com:4443/em
```
Log in as sysman, using the password you specified during Oracle Enterprise Manager installation. Or, log in as another Grid Control user with administrator privileges.

The base target type for Oracle Files is Internet File System.

Changing the Default Metric Collection Behavior

In some cases, you may want to enable or disable an Oracle Files metric for a middle-tier host after initial configuration. For example, you may want to enable the Load Balanced Application URL Timing metric on a middle tier because a load balancer has been recently added to the system, or you may want to disable the Application URL Timing metric on a middle tier because the HTTP node has been removed from that middle tier.

To change the default metric collection behavior, reconfigure the Oracle Files (oracle_ifs) targets for the given Oracle Files domain in the Grid Control.

Reconfiguring Oracle Files (oracle_ifs) Targets in the Grid Control

Follow these steps to change the default metric collection behavior of Oracle Files targets:

From the Grid Control Home page, click the Targets tab, then click the All Targets subtab. A list of all the discovered targets across the network appears.
Locate the Oracle Files target for the given middle tier. You can perform a quick search by entering the schema name in the Search field and clicking Go.
Select the Oracle Files target and click Configure. The target type for Oracle Files is Internet File System.
Set the following values to TRUE or FALSE to enable or disable metric collection. The values must be in upper case.
- Run Repos Metric?
  
  The default is TRUE.
- Run Response Time Metric?
  
  The default is TRUE. If you set this parameter to TRUE, specify a valid value for Application URL. If you sent this parameter to FALSE, enter NULL for Application URL.
- Run Load Balancer Response Time Metric?
  
  The default is FALSE. If you set this parameter to TRUE, specify a valid value for Load Balanced Application URL. If you sent this parameter to FALSE, enter NULL for Load Balanced Application URL.
Click OK.

Viewing Oracle Files Metrics in the Grid Control

After you have logged in to the Grid Control, there are several ways to navigate to the pages that show Oracle Files metrics. Two methods are described in the following sections.

Using the Groups Subtab

You can use this method to access Oracle Files metrics if you have followed the instructions for setting up groups in Oracle Enterprise Manager Managing Oracle Collaboration Suite.

From the Grid Control Home page, click the Targets tab.
Click the Groups subtab. A list of groups appears.
Select the OCS Group target. The OCS Group Home page appears.
Click Member Targets. A list of member targets appears.
Select the Oracle Files Group target. The Oracle Files Group Home page appears.
Click Member Targets. A list of member targets appears.
Click the name of your Oracle Files middle-tier instance from the list. The name appears in the following format:
```
app_server_host_iFS_db_host:port:service:schema
```
The Oracle Files Grid Control Home page appears. Since the target type for Oracle Files is Internet File System, you will see this notation at the top of the page.
Click All Metrics to see a list of Oracle Files metrics.

Using the Search Function

To use this method to access Oracle Files metrics, follow these steps:

Click the Targets tab.
Click the All Targets subtab. A list of targets appears.
Type the name of your Oracle Files host in the Search field and click Go.
Click the name of your Oracle Files instance. The target type is Internet File System.
Click All Metrics to see a list of Oracle Files metrics.

Metric Thresholds and Metric Collection Intervals

You can use the Grid Control to edit the thresholds for Grid Control metrics. When you edit the thresholds, a customized collection file will be created in the following directory:

$ADDITIONAL_AGENT_ORACLE_HOME/sysman/emd/collection

For more information, see Oracle Enterprise Manager Concepts.

Metric Collection Intervals

You cannot use the Grid Control to update the metric collection intervals. If you must change the default intervals, you can manually edit the customized collection file described in the previous section. Do not specify a collection rate higher than once every minute, or it will have a negative impact on the performance of your entire system.