Oracle MDM HUB server services taking long time to come up while bounce

Whenever Oracle MDM HUB server takes long time to come up while bounce. Then do the below tasks on HUB schemas to reduce the HUB services start up time,

select count(*) from C_REPOS_MET_VALID_MSG;
select count(*) from C_REPOS_MQ_DATA_CHANGE;
select count(*) from C_REPOS_AUDIT;
SELECT count(*) FROM user_tables WHERE table_name LIKE 'T$%';

Take all counts delete based on date or truncate the table & drop the 'T$' tables as per functional people instruction using below commands,

TRUNCATE TABLE c_repos_audit;
TRUNCATE TABLE c_repos_mq_data_change;
TRUNCATE TABLE c_repos_met_valid_msg;

DECLARE
BEGIN
FOR rec IN
(SELECT table_name FROM user_tables WHERE table_name LIKE 'T$%'
)
LOOP
EXECUTE immediate 'DROP TABLE '||rec.table_name;
END LOOP;
END;

No comments:

Post a Comment