Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

How can I use the SilkPerformer Performance Explorer to monitor an Oracle 10g Database?

How can I use the SilkPerformer Performance Explorer to monitor an Oracle 10g Database?

SilkPerformer's Performance Explorer can be used to retrieve "v$systate" monitoring data from an Oracle 10g Database. This enables you to track various aspects of the Database"s Performance in Real-Time, which can help facilitate the identification of bottlenecks.

There are three prerequisites which need to be fulfilled in order to be able to monitor an Oracle 10G Database via the v$systate" table

  1. An Oracle client is installed on the same machine as the SilkPerformer Performance Explorer.
  2. You can successfully query the "v$systat" table from outside of Performance Explorer. This can be verified by using the SQLPlus executable provided by the Oracle client.
  3. You have a valid SilkPerformer SAM license.

To configure Performance Explorer to Monitor the "v$systate" measures on an Oracle 10g database, use the following steps:

1. Select "Monitor Server from the Performance Explorer toolbar

2. Choose "Select from Predefined Data Sources" in the Data Source Wizard

3. Select: Database System > Oracle (v$systate) > System Statistics (v$systate)

4. Enter the Hostname of machine Database resides on.

5. Provide Connection String, Username and Password required to connect to Oracle Databases's Table and retrieve System Statistics:

6. Select from the available System Statistics; those values that you wish to Monitor and save to tsd format:

7. Click Finish to complete configuration; a Monitor Graph will be generated in Performance Explorer, displaying real-time values provided by Oracle Database:

If you require any further support or information, please contact Borland Technical Support.

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Comments

Would it be possible to monitor the table v&session as well?

Sorry, I meant V$SESSION

Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:08
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.