Return
-
Title
Spotlight tables QUEST_PPCM_SQL_TEXT and QUEST_PPCM_SQL_SNAPSHOT growing in size. -
Description
Spotlight tables QUEST_PPCM_SQL_TEXT and QUEST_PPCM_SQL_SNAPSHOT continue to grow. How to shrink and truncate these tables? -
Resolution
There are options available within Spotlight to restrict the amount of data retained by the Predictive Diagnostics module objects.1. In Spotlight connect to Oracle instance containing QUEST_PPCM tables.2. Select View | Option menu option.3. Go under Predictive Diagnostics section and select Impending Bottlenecks Oracle option.4. For each three fields here, reduce the Data Retention Period.**Note less data means PPCM will obviously have less data to use for predictions but this will keep table sto smaller size.These changes will automatically shrink the size of these tables.