Response Execution Time (ResponseExecTime)
The ResponseExecTime
parameter reports the time it takes to execute the response.sql file located in the $PATROL_HOME/oracle/sql (Windows NT) or the $PATROL_ROOT/UNIX/oracle/sql (Unix) directory. Timing includes logging into Server Manager, running the SQL and then logging out of Server Manager.
The annotation for this parameter reports the sort data for the interval.
You can modify the response.sql file to any SQL statements you choose by editing the file. The default response.sql file contains the query "select * from v$parameter;"
BMC PATROL properties
Attribute | Default value |
---|---|
Application class | ORACLE_PERFORMANCE |
Command type | Not applicable |
Platform | All |
Icon style | Graph |
Unit | Seconds |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling(poll time) | Poll time of collector |
Active at installation | Yes |
Parameter type | Consumer |
Value set by | CollResponse |
BMC ProactiveNet Performance Management properties
Property | Default value |
---|---|
Monitor type | Oracle Database Performance |
Key Performance Indicator | No |
Monitor for abnormalities | Yes |
Graph by default | No |
Availability | No |
Response time | Yes |
Normal distribution | No |
Statistical | Yes |
Comments
Log in or register to comment.