Performance Hub is also available in another mode, namely Top Activity Lite. This mode is a simplified view of Performance Hub and focuses on fast response time to monitor the performance of database systems in real time.

You can explore these tabs and options to monitor a selected database and analyze its performance, which includes but is not limited to:

• How much is a database waiting for a resource, such as CPU or disk I/O

• Whether database performance degraded over a given time period, and what is the primary reason

• Which specific modules are causing a load on the system, and where most of the time a database spends on the modules

• Which SQL statements are the key contributors to changes in database performance, and which executions are causing them

• Which user sessions are causing performance bottlenecks

• Which sessions are currently blocking, and if outstanding requests exist for a lock

• Whether any databases are interfering with the current database

• Which databases, disks, and cells are causing high I/O load, and if the load is for Backup, Rebalance, or User I/O

• What cells are CPU bound, and how to determine the cell offload

• What a database's configuration is, including software version and disk status