Is there a drill-down for parallelism SQL usage in Spotlight? (4232728)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Is there a drill-down for parallelism SQL usage in Spotlight?
Description

Looking for data that shows the parallelism SQL usage targeting a given database within Spotlight; is that available and where can that be accessed?
Resolution

In Spotlight 12.0 and above, go to Monitor | SQL Activity | Query Execution Statistics. Click the display options drop-down menu and select "Show Query Execution Statistics using parallelism".
In Spotlight 11.7.1 and below, go to Monitor | SQL Activity | Top SQL. Click the display options drop-down menu and select "Show Query Execution Statistics using parallelism".