DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: cmclean

  1. #1
    Join Date
    Nov 2002
    Posts
    7

    cmclean

    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?

    thanks,

    Arul

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    Re: cmclean

    Hi,
    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

    Regards
    Rohit S Nirkhe,Oracle/Apps DBA
    OCP 8i,9i
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width