How do I clear out the Top SQL queries in Spotlight on Oracle?
A Spotlight user with ALTER SYSTEM privileges can flush data manually from the shared pool. To do so, from the main Spotlight page, right-click on the Shared Pool or Shared Pool Used component, and choose Flush from the shortcut menu. (This option exists only for Oracle versions where manual flushing is supported.)
Note: Flushing the shared pool may adversely affect the performance of the database in the short term.