1. If needed, export the server configuration file from the Spotfire database. Use the graphical configuration tool or the command line configuration tool as shown below:
$ cd <TIBCO Spotfire Server>/tomcat/bin
$ config export-config
A file called configuration.xml will be created in the current directory
2. Open configuration.xml in a text editor and locate the "<oracle>" tag
3. Add the tag <use-faster-schema-listing>true</use-faster-schema-listing> inside <oracle> and </oracle>:
<configuration ...>
...
<information-services>
...
<jdbc>
...
<oracle>
...
<use-faster-schema-listing>true</use-faster-schema-listing>
...
</oracle>
...
</jdbc>
...
</information-services>
...
</configuration>
4. Save configuration.xml
5. Import the configuration.xml file back into the Spotfire server database. Example using the command line:
$ config import-config -c="Enabled oracle use-faster-schema-listing"
6. Restart TIBCO Spotfire Server
Note: This applies only to data sources that use the Oracle Thin driver (oracle.jdbc.OracleDriver) and not Oracle DataDirect (tibcosoftwareinc.jdbc.oracle.OracleDriver).