How can I categorize Resource Statistics?
The resource statistics can be categorized as:
- Connection use time: Represents the total connection use time, and the minimum, maximum, and average time required to get a connection.
- Waiting threads: Represents the number of threads waiting on a connection.
- Pool: Represents the total size of pool including the minimum, maximum, and average number of objects requested. It also informs about the number of objects available in the free pool at a particular time.
- CacheHitRatio: Prepared Statements improve the performance of a Web application as the statements are cached and do not require re-compiling every time a query needs to be executed.
- Statement execution time: Number of times a cached prepared statement is executed and the statistics of response as the maximum, minimum, and average time taken to run the statement.
You can view information about the Resource statistics using the:
- UI: Log on to the Console and select Monitor > Resources and click the name of the datasource to be monitored.
- Command shell: At the Server command prompt, type:
j2eeadmin@default> status resource.
