User Defined Collections (UDC) are a very flexible and straight forward method to enable the users to create their own collections plus the advantages of the Db cartridge, such as adding a Baseline to the UDC.
UDC requires a user configuration. This user will SQL to the Monitored Instance and will perform the SQL.
This user can be either a UDC dedicated user or the same DB user that the Agent works with.
In any case the UDC user needs to be first configured and initialized by the user.
Below is some more infornation regarding the UDC mechanism & limitations:
Please refer to KB 262094 for a video on adding user defined collections to database agents.
Use the User-defined Collections view in the Databases Administration dashboard to add user-defined collections to all of the currently selected agents, in order to provide for queries not included in Foglight for Oracle.
Please refer to KB 232102 for details on opening the Databases Administration Dashboard.
To add user-defined collections: