F9i Users Test
This test reports general statistics pertaining to the database users.
Target of the test : An Oracle Forms Server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every Oracle Forms server monitored.
| Parameter | Description |
|---|---|
|
Test period |
How often should the test be executed. |
|
Host |
The host for which the test is to be configured. |
|
Port |
The port number at which the specified Host listens to. |
|
FormworkDir |
The path to the install directory of the Oracle Forms 9i server. Typically, this will be the <ORAHOMEDIR>/Forms90/. |
|
FormsRuntime |
The value, "ifweb90.exe", is displayed here. This is the Forms server runtime executable. |
|
OraHomeDir |
The install directory of the Oracle 9i server. This specification becomes more important when more than one Oracle 9i AS installation exists on a host. |
|
TrcCleanupTime |
For Oracle 9i Forms monitoring, eG requires tracing to be enabled for the server. The trace files corresponding to completed sessions are automatically cleaned by the eG agent. The frequency with which these files are to be cleared from the server is to be specified in the TrcCleanupTime textbox. The default value displayed in the TrcCleanupTime text box is 30 minutes. |
| Measurement | Description | Measurement Unit | Interpretation |
|---|---|---|---|
|
Forms request rate |
Indicates the rate of requests received by a Forms server for a specific user during the last measurement period. |
Reqs/Sec |
A comparison of this measure across users can be used to determine which user(s) are heavily using the Forms server. |
|
Database request rate |
Indicates the rate of requests to the database issued by the Forms server for a specific user during the last measurement period. |
Reqs/Sec |
A comparison of this measure across users can indicate the top users of the Forms database. |
|
Client/network response time |
Indicates the response time of the client and network for this database user. |
Secs |
A sudden increase in response time could be indicative of heavy network traffic. |
|
Forms server response time |
Indicates the response time of the Forms server for a particular database user. |
Secs |
A sudden increase in response time is indicative of a potential performance bottleneck in the Forms server. |
|
Database response time |
Indicates the response time of the database for a particular database user. |
Secs |
A sudden increase in response time is indicative of a potential performance bottleneck on the database server. |
|
Sessions |
Indicates the total number of Forms sessions running for a particular database user. |
Number |
A high value may indicate that there is a high load on the server. |
|
Avg session duration |
Indicates the average duration of the Forms sessions running for a particular database user. |
Mins |
|
|
Memory usage |
Indicates the percentage of memory utilized by the Forms processes corresponding to a particular database user. |
Percent |
A sudden increase in memory utilization for a process may be indicative of memory leaks in the application. |
|
CPU usage |
Indicates the percentage of CPU time utilized by the Forms processes corresponding to a particular database user. |
Percent |
A very high value could indicate that the processes are consuming excessive CPU resources. |
