I have one more question, we have DB user (wilymgr5) which not in use now, can we cleanup/remove that particular user/ID data from DB server ? if yes, what is the procedure ?
Release : 10.7.0
Component : APM Agents
APM DB has a users table in ts_user. APM itself stores users in users.xml, EEM, or LDAP. The user can be removed from these data stores.
Oracle has a DROP User command. https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9008.htm