User Defined Collections (UDCs)

User Defined Collections are a feature by which Oracle resource consumption can be analyzed over selected domains and filters across different time periods. This tab provides the following options:

• New... Launch the User Defined Collections creation wizard.

• Stop/Start – Pause/Recommence data collection for the User Defined Collections on the selected collection.

• Delete - Delete the selected collection.

• Clear - Erase the selected collection contents.

To view and configure existing User Defined Collections

• Double click the User Defined Collections pane listing of interest to display the defining set-up tabs:

Identification tab

Displays the UDC name (read only) and description.

Oracle Dimensions tab

(For viewing only) Displays those dimensions which are enabled in this collection.

Activity Filter tab

(For viewing only) - Activity filters are a means to focus on and limit collections of occurrences of activities of interest. Activities are defined by their corresponding dimension values.

Collection Settings tab

Fine tune SQL Collection Settings and Wait and Lock event granularity rules, and rule exceptions.

Time Pyramid tab

Optimize storage and performance and gain rapid access to the data of interest through the Time Pyramid settings.

Scheduling tab

Scheduling (for viewing only) - Displays the exact date and time at which the collection takes place.

Space Allocation Override tab

Use this option to manually override the system-determined UDC disk space requirement by specifying an alternative disk allocation.