To run cmclean.sql in oracle applications we need to make sure the concurrent manager is down..any idea what happens if cmclean is run when concurrent manager is up?
If cmclean.sql is run when the concurrent managers are up and running ,the script will not be able to clean and remove the rows from the concurrent manager process and request tables as the ICM and other managers will be holding locks on these tables.
So its better to shutdown the concurrent manager cleanly and then run the cmclean.sql
Rohit S Nirkhe,Oracle/Apps DBA
Click Here to Expand Forum to Full Width