Oracle Database 12.2.0
RHEL 7.4
Hello Team,
Most data warehouses have infrequent update activity in comparison with OLTP workloads. Some data warehouses are loaded periodically from operational data and are never modified between loads; these configurations have insignificant logging requirements. Other strategies involve regular maintenance of data that requires inserts and deletes from the database.
Data warehouse update and maintenance strategy:
Frequency of updates
Volume of changing data per cycle
Data recovery requirements
Update cycles between log backups
Transactional characteristics of the workload
How will I implement the above strategies? I have some scripts which perform DML and DDL on tables. Is there some tools to measure the volumes?
Thanks,
Joe