Submit Search

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.

Configurable parameters for the test
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.

Measurements made by the test
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.