Enabling and Disabling Data Collector
Data Collector is on by default and retains information for all sessions. If performance issues arise, a superuser can disable Data Collector at any time.
To disable the Data Collector:
=> ALTER DATABASE mydb SET EnableDataCollector = 0;
To re-enable the Data Collector:
=> ALTER DATABASE mydb SET EnableDataCollector = 1;