We want to run the purge of reporter DB. We have some question pertaining to that mentioned below
Release : 6.x
Component : Dollar Universe
Sub-Component: Reporter Server
As per document Purge for Reporter the below data will be removed
If the purge running for the first time or on large data size, it will only impact the extractions from running in case if the purge is going to take long time to complete depending on data size. It is recommended to run purge in non-peak hours. To increase the performance of the purge the retention count can be increased from default of 180 days to 360/720 or higher and slowly reduced. It will make sure that the data to be processed under purge is reduced.
In most common configuration of Database the auto-shrink is turned off and auto-extend is turned on. Henceforth, the DBA will need to shrink the Tablespace post removal of purge records which may require rebuilding of indexes.
This is very specific to Oracle Database. Please refer the document Oracle Managing Redo Log
The most common activity is to shrink Tablespace and re-indexing.