- Web Load Testing Oracle Monitoring

Oracle Database Monitoring

These monitors collect the main performance statistics for Oracle® database servers. The data collected will help you evaluate the performance of your database during the load test and pinpoint any problems related either to the application's development or to the various server parameter settings.

An application server's default settings for accessing databases, and the default settings of the databases themselves (connection pools, dedicated memory allocation, table indexation...), are not always suited to the application itself and often need to be adjusted. The load test, coupled with the Oracle server monitoring, allows you to tweak these settings and observe any subsequent improvement or deterioration in performance.

Database monitoring is supported for Oracle versions 8i, 9i and 10g. Monitoring is carried out non-intrusively; therefore, no special configuration is required for the server.

Performance Counters

Monitors are classified by category, each category providing several performance counters for memory, call speed, cache use ratios etc.

The monitor categories are:

• Sessions.  Shows the number of open, system and idle sessions for the database.

• Call Rates.  Shows the number of calls per second to your server . Specific counters are provided according to the operations carried out: parse , execute , commit or rollback .

• Miss Rates.  Shows the percentage of calls to the database that did not use a cache. When using a standard application, the processing of calls to the database is speeded up by the use of database caches. These performance counters will show the caches' efficiency.

• Indexed Queries.  Shows the percentage of SQL requests using indexes.

• Logical IO.  Shows the number of blocks per second for each of the logical accesses.

• Physical IO.  Shows the number of blocks per second for each of the physical accesses .

• Event Waits.  Shows the wait time in seconds for a particular event .

• SGA Memory.  Shows the SGA (System Global Area) memory allocated to the various pools and buffers, in Kb

• Miscellaneous.  Provides various ratios to help optimize database settings for the requests made to it.