What is the difference between this desktop capture and the data in the Spotlight user schema on the Oracle server?
The difference between this history data and data collected and placed in the Oracle schema: the data logged into the Oracle schema is Predictive Diagnostics raw data that is collected via Oracle/DBMS Scheduler jobs that are regularly scheduled. This data is collected irrespective of whether the Spotlight client is running ... it can then be processed and analysed via the Predictive Diagnostics drilldowns in Spotlight. It’s optional to collect this data: you choose whether to do Predictive Diagnostics when setting up the Oracle user in the User Wizard.