Spotlight on Oracle
Within the Top Sessions, while viewing session waits, session locks, or basically any other information on the user, Spotlight hangs for a good 10 minutes (though it will eventually come back). This only happens on the Oracle 18.104.22.168 databases.
1. This patch fixes an issue that causes Spotlight on Oracle to hang in various Session detail sub-drilldowns when connected to an Oracle 22.214.171.124 database.
2. Software requirements - Spotlight On Oracle 3.0
3. Installing the patch.
To install the patch, perform the following steps:
a. Shut down the Spotlight console, if it is currently running.
b. Copy the file sql9014.dat file into the following directory. By default, Spotlight is installed under
Program Files\Quest Software\Quest Central for Oracle. File sql9014 should be placed in the following
directory in this tree: Spotlight\Plug-ins\SoO. Therefore, the default full directory location is:
Program Files\Quest Software\Quest Central for Oracle\Spotlight\Plug-ins\SoO
Note that this is a new file - it does not overwrite an existing file of the same name.
4. Start up Spotlight on Oracle.
Will be fixed in future release.
On Oracle 126.96.36.199 version