Chat now with support
Chat with Support

Foglight for PeopleSoft 5.6.11 - User and Reference Guide

Using Foglight for PeopleSoft
Exploring the PeopleSoft Dashboards Foglight for PeopleSoft Agents PS_AppMonitor Agent PS_AppServer Agent PS_DB2SQL Agent PS_MSSQL Agent PS_OracleSQL Agent PS_PPM Agent PS_SchedMonitor Agent PS_SchedServer Agent PS_Scheduler Agent Manual Agent Naming Deployment Scenario Procedures
Foglight for PeopleSoft Reference
Views
PS_AppServer Views PS_DB2SQL Views PS_MSSQL Views PS_OracleSQL Views PS_PPM Views PS_SchedServer Views PS_Scheduler Views
Data

Setting the PS_OracleSQL Connection Details

The PS_OracleSQL Agent must be configured with specific database information before the agent can connect to the database to collect user transactions within the PeopleSoft database.
The Connection Details agent properties allow you to specify the environment variable the agent uses to connect to the PeopleSoft database. The connection information consists of a Database Name, Database Login ID and Password, Database Home Directory, and Database Type.
To set the connection details:
1
Go to the Connection Details set of properties.
2
Enter the path to the TNSNAMES.ORA file in the SQL*Net Configuration File box.
3
Enter the database name in the Database Name box.
4
Enter the database user ID who accesses the PeopleSoft database in the Database Login Name box.
 
* 
NOTE: This user must have select authority to access Oracle V$Session and V$SQLAREA and PeopleSoft tables.
5
Enter the password for database login in the Database Login Password box.
6
Enter the Oracle home directory in the Oracle Home box.
7
Select the Oracle Database version from the list for the Select Oracle Version box.
•
Oracle80
•
Oracle81
•
Oracle90
•
Oracle 10G
•
Oracle 11G
* 
NOTE: The above choices are for the Database Client Installations connecting to the Databases. For all Oracle 9.x databases, choose Oracle90 as the agent property value.
8
Click Save.
The PS_OracleSQL attempts to run on the Foglight Console. If successful, the agent status is listed as running
Once the PeopleSoft Connection Details agent properties are properly configured, the Management Server gathers data from the PeopleSoft agent.
 
* 
NOTE: For help configuring the other agent properties, see the Foglight online help.
9
Go to the Setting the PS_MSSQL Data Management Parameters section.

Setting the PS_OracleSQL Data Management Parameters

Use the Data Management agent properties to set the sample frequency.
To set the data management properties:
1
Go to the Data Management set of properties.
2
Choose the list from the Edit Table Sample Frequencies list that you want to update.
The collection rate, or sample frequency, is the number of seconds between the end of a collection period and the start of the next. The sample frequency can either be controlled at the agent level or set for each table. Table level sampling is the preferred method.
 
* 
IMPORTANT: Use Add or Delete only when directed to by Dell Support.
 
* 
NOTE: A single table is used for this agent.
3
Click Edit.
A secondary property list appears.
4
Add an entry to the list by clicking Add Row.
Fill in the dialog box fields.
 
* 
NOTE: Through default template (PS_OracleSQL_samplefreq_template) a default sample frequency list (PS_OracleSQL_samplefreq_list) is available, as described above. This default list has to be selected for use with this version of PS_OracleSQL Agent. Note that earlier default list (PS_OracleSQL_SampleFreq) is no longer valid with the current update, and should no longer be used.
5
Click Save Changes.
6
Ignore the Purge All Data After box. This field is not functional.
7
Click Save.
 
* 
NOTE: For help configuring the other agent properties, see the Foglight online help.
8
Go to the Setting the PS_MSSQL Server Filter Parameters section.

Setting the PS_OracleSQL Server Database Parameters

Use the SQL Oracle Criteria properties to set the SQL Server Filter properties.
To set the server filter parameters:
1
Go to the Oracle SQL Criteria set of properties.
2
Click the Enable SQL Criteria Filters radio button, True or False, to turn on the data filtering. When this field is set to true, only data satisfying the filter criteria is collected in the UserData table. This criteria can be used to identify and collect I/O intensive SQL statements that are executed by the PeopleSoft application users.
3
Enter a value for the SQL Statement Hit Ratio in percentage. If the Enable SQL Criteria Filter option is set to true, enter a value to determine an I/O-intensive SQL statement.
Only PeopleSoft database users executing a SQL statement with a hit ratio less than the entered value are collected for the collection interval.
The default value is 80 percent.
4
Click the Log SQL Output to Log File radio button, True or False, to output the SQL statement or stored procedure to a log file for review, and to view the entire select statement that the PeopleSoft application user is executing.
5
If the Log SQL Output to Log File option is set to True, enter the path and log file name to which you want the SQL statement or stored procedure written in the Log File Name (full path) box.
6
Click Save.

Investigating Database Usage and PeopleSoft User Intensive SQL Statements

The PS_OracleSQL Agent provides database usage statistics by measuring the number of active and inactive database users and identifies resource intensive SQL statements executed by PeopleSoft users.
The PS_OracleSQL Agent also monitors SQL activity for PeopleSoft users who execute a SQL statement during a sampling period. These statistics let you isolate problem SQL statements based on hit ratio, buffer gets, disk reads, or rows processed. The PS_OracleSQL Agent also lets you output the problem SQL statement to a log file. From there, you can perform additional access path and index analysis using a SQL analysis solution such as the Quest SQLabVision. Using the Data Browser, you can also review SQL activity for each PeopleSoft user.
To start your investigation with the PS_Ora_PID_Overview graph view:
•
Go to the PS_Ora_PID_Overview graph view which displays the hit ratios by the PeopleSoft application server process PID (system Process ID). This graph provides an indication of which PIDs are the most resource intensive.
To view more detailed information:
Drill down on the HitRatio to view the details about the Oracle session corresponding to the PeopleSoft application server process PID including the associated PeopleSoft Application user and SQL metrics, with the PS_Ora_PID_Detail table view.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating