SAP BASIS Forum
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.
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
Ask Question From Our Experts