Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - Release Notes

Concurrency Metrics

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating