Database concurrency is a measure of the number of users connected to the database at the same time. Predictive Diagnostics allows you to choose one of these metrics to represent database concurrency.
| Option | Description |
|---|---|
|
Connected sessions |
The average number of user sessions connected to the database at the time. |
|
Active sessions |
The average number of user sessions that are performing some database activity at the time. Note: High values for Active sessions can be generated by a single session performing SQL queries in parallel OR by many sessions performing many SQL queries of short duration. Because of this, Active sessions also may be considered a measure of the total amount of work performed (throughput). |
|
Customized SQL |
Use a customized concurrency metric defined in the Database Throughput And Concurrency page for database throughput and concurrency. |
