You want to examine how much Smart Scan activity is occurring.

To determine the amount of Smart Scan activity on an Exadata Database Machine, you can access two specific commands:

CELLCLI Command: Using the list activerequest command within CELLCLI on all storage cells will show the number of Smart Scans being processed. CELLCLI is an interface specific to Exadata Storage Servers for management and monitoring, and it provides real-time visibility into ongoing Smart Scan operations .

EXACLI Command: Similarly, the list ACTIVEREQUEST command using EXACLI on all storage cells also lists the Smart Scans executed across the storage servers. EXACLI is a remote command-line utility that can be run from a database server to manage storage cells, offering convenient access to similar Smart Scan information .