From the Spotlight Browser select All connectionsAll connections | Spotlight on Oracle
Select the database.
Click Set timed statistics now if you are prompted to do so. You see this prompt when for the Spotlight user the timed_statistics parameter is set to false in the init.ora file. Spotlight requires this parameter be true for the Spotlight user to accurately monitor the database. Clicking Set timed statistics now corrects the problem only if the Spotlight user has Alter System privileges. Ensure the Spotlight user has sufficient privileges. Oracle User Wizard
If Spotlight takes too long to open the Oracle connection then Fast Initialize could be on. Oracle Initialization
Add an Oracle database to the list of connections
Create a Spotlight user with sufficient privileges to diagnose the Oracle database. Oracle User Wizard
Ensure the UNIX or Windows server on which the Oracle database is installed is accessible to Spotlight.