Page History

This section includes the following topics:•    Defining

• Defining the server upon which the FocalPoint is to be installed

...

• Sampling Alerts custom metrics from the monitored instance

...

• Collapsing statements with different constants into a single statement with bind variables

...

• Saving Oracle session information for a specified period of time

...

• Associating Oracle activity with network statistics

...

• Specifying additional Oracle Listener ports

...

• Defining schema specific configuration parameters

...

• Monitoring RAC installations

...

• Monitoring ERP

...

• Manually installing Precise for Oracle database schemas

Defining the server upon which the FocalPoint is to be installed

The default location for the FocalPoint installation is on the same server as the Precise Framework. The General tab allows you to define a different server as the location for the FocalPoint installation.

...

3.    Click the drop-down menu and select the server which the FocalPoint should be installed upon.

4.    Click OK.

Sampling Alerts custom metrics from the monitored instance

To enable sampling of Alerts custom metrics for this instance

...

3.    Mark the box “Enable sampling of custom metrics for this instance”.

4.    Click OK.

Collapsing statements with different constants into a single statement with bind variables

This option will handle all statements that have the same text but different literals as the same statement. The data will not include literals but the first value used for each literal.

...

4.    Click OK. NEXT SECTION

Saving Oracle session information for a specified period of time

Precise for Oracle saves historical files that contain performance information. These files are parsed and loaded into the PMDB. When session information is viewed, Precise for Oracle accesses these files. You can specify the retention period that the session information is saved.

...

3.    Click the drop-down menu and select the desired time for saving information from the last Oracle session.

4.    Click OK.

Associating Oracle activity with network statistics

This is the network time experienced by Oracle entities, provided you install the Insight Savvy for Network on this server.

...

3.    Check the box “Associate Oracle activity with network statistics”.

4.    Click OK.

Specifying additional Oracle Listener ports

This option is relevant if you have installed the Insight Savvy for Network on the Oracle server. You can add TCP/IP ports that are used by SQL*Net Listeners to have network traffic on those ports monitored. See Configuring a Listener to listen to a different port on page 47 for details.

...

5.    If the port number is new, click Add and enter the new Listener port number.

6.    Click OK.

To remove an Oracle Listener port

...

2.    Click Remove to delete the port number from the list.

3.    Click OK.

Defining schema-specific configuration parameters

To define schema specific configuration parameters

...

NOTE    This is the folder where you want to keep the datafiles for the new tablespace and/or the new temporary tablespace. By default, this is the Oracle home folder. You can type a different folder path or click browse (...).

6.    Click OK.

Monitoring RAC installations

NOTE    The RAC tab will only appear on the advanced screen if the system detected that you are installing an instance that is part of a cluster.

...

1.    Enter the cluster name for the RAC database.

2.    Click OK.

Monitoring ERP

Use the ERP Tab to define the SAP Interpoint.

...

NOTE    The Oracle Tier Collectors can display correlated information of the activities and resource consumption of your PeopleSoft application components in your Oracle instance. Select this option to correlate PeopleSoft information with Oracle resource consumption.

Manually installing Precise for Oracle database schemas

The Precise for Oracle installation process automatically installs schemas on the Oracle database. This process must be performed for each Oracle instance installed. If you install Oracle instance schemas only, FocalPoint schemas need not be previously installed. To manually install Oracle instance schemas only

...

-name manual-install-oracle-schema

-value true 

2.    Manually install the Precise for Oracle database schemas.

...

-name manual-install-oracle-schema

-value false

Precise. Performance intelligence from click to storage. Learn more > >

...