Spotlight on Oracle 4.5.0 and 4.5.1 with OS on Solaris 2.9 does not display CPU usage.
Spotlight does get reliable data back from any of the queries that are using "vmstat"
It's a bug in Solaris 2.9. There are other bug reports on the web regarding this.
Contact Sun Support and / or upgrade to Solaris 10
Instruct Spotlight to use "iostat" command instead of "vmstat" to get the CPU values.
To install the workaround:
1. Shut down Spotlight
2. With Windows Explorer, go to C:\Program Files\Quest Software\Spotlight\Plug-ins\Datasource\UNIX
3. Rename the file UNIX.XML to UNIX.xml.save
4. Copy the attached UNIX_SUPPORT.xml into this directory
5. Now run Spotlight and try the connection
Note: This will return the CPU usage, but not the memory and run-queue data.