The PS_OracleSQL agent runs and collects data. There does not seem to be very much data (it shows 8 SQL statements over the last 4 hours). The database being monitored has hundreds of SQL statements being executed every hour.
“Enable SQL Criteria Filter” property is set to true. If so, showing 8 SQL statements is normal behavior. When this property is set to true, only data satisfying the filter criteria is collected. The filter criteria is set by the “SQL Statement Hit Ratio” property and only PeopleSoft database users executing a SQL statement with a hit ratio less than the entered value are collected.
Limited data may be seen collected by the PS_OracleSQL agent because it is designed to provide a breakdown of database user activity and the statistics necessary to identify usage trends for the PeopleSoft database users and PeopleSoft application users.
The DB_Monitoring or the Enable_DB_Monitoring value in the psappsrv.cfg file to get domain and user data it set to zero (0).
If you want to see most of SQL statements leave the “Enable SQL Criteria Filter” property as false.
Reduce the sample frequency, such as to 60 seconds from 300 seconds, to see more SQL statements.
The DB_Monitoring or the Enable_DB_Monitoring value in the psappsrv.cfg file should be changed from 0 (zero) to 1 (one) to get domain and user data in the PS_OracleSQL, PS_MSSQL, and PS_DB2SQL agents’ UserData table.
These resolutions may be applicable for the PS_DB2SQL and PS_MSSQL agents on all platforms as well.