Procedure dbms_cdc_publish.create_change_set is taking long time. I left it ran for 18 hours, it is still running? Has anybody has any clue why it is taking long time?
Thanks in Advance.
You can also get information regarding About SAP
I am not really sure why it is taking so much of time and it is difficult
to make pin point the exact problem area without looking into the
query.Anyways,in order to make sure that you procedure is optimized you
might have to check the following:
1. You have unique clustered index on the primary key of the table.
2. Try to create temporary table with the required filter in the where
clause instead of cte's or view's.
3. Check the SQL trace output and determine which statement is taking
longer time to execute.
Sign up for STechies
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.