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;
