How to configure different tablespaces for Foglight data? (4258625)

Is it possible to configure a tablespace for Foglight observation data and configuration data?

Is it possible to separate data for different tablespaces?

It is possible to set up different tablespaces for separate data, but it does not help from the performance point of view. From the Performance Tuning Field Guide, page 43 + 44:

"There is no benefit to separating configuration data from observation data (that is, in setting up multiple destinations for the different types of data, potentially on different physical

Quest does not recommend any tablespace separation for data, index, and LOB. Quest does not expect such separation to have any impact on real performance. Your DBA can decide how to configure such things based on his or her own specific requirements about where to store data, index and LOB. This is typically done according to database administration conventions."

However, it is possible to set up different tablespaces for different data by doing the following when configuring the Oracle database:

1. When the step to configure the tablespaces for data and indexes is reached, click on the "Advanced" button

2. A small window will come up to enter the tablespaces for configuration and observation data (data, indexes and LOBs)

Even if there is a way to enter more than one tablespace for data or indexes or LOBs (see screen shot), it is not recommended to do so. The table which is there to enter the observation tablespace, is there for historical reason (no specific feature behind it).