Workflow instance monitor have three separate tables. One for logging workflow run (workflow instance), second for its steps execution to log (workflow steps) and third for logging the values of each process property value against each step of workflow (workflow process properties). If you increase the Workflow Monitoring level over the time tables space and DB load will be increase and sometimes instance monitor will be stopped working (Check Siebel Workflow Instance Monitor not working to fix this issue). Its a good practice to delete the old workflow instance monitor records.
Below are the queries for deleting the data. Its better to delete only old data and Year is perfect condition.
Workflow Instance
select count(*) from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022'
--delete from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022'
Workflow Instance Steps
select count(*) from S_WFA_INSTP_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022'
--delete from S_WFA_INSTP_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022'
Workflow Step Process Properties
select count(*) from S_WFA_STPRP_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022'
--delete from S_WFA_STPRP_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022'
After running the queries make sure to commit the changes.
