Patch 6678700 : Rel 11i to 12.1.1 Upgrade : Script ocmupgcf.sql performance issue
(Thread created by Oracle Support on behalf of Customer)
Hi there
We are in the process of test-applying the upgrade from Rel 11i to 12.1.1 (Patch #6678700)
but are finding that script 'ocmupgcf.sql' is taking a long time.
The script basically consists of two update statements, each of which is taking 1.5 hours
to complete :
UPDATE ar_cmgt_cf_dtls
SET case_folder_detail_id = ar_cmgt_cf_dtls_s.nextval
WHERE case_folder_detail_id IS NULL;
COMMIT;
UPDATE ar_cmgt_cf_dtls
SET sequence_number = 1
where sequence_number IS NULL;
COMMIT;
We can see that both columns are new and therefore empty on every row in the table.
Hi there
We are in the process of test-applying the upgrade from Rel 11i to 12.1.1 (Patch #6678700)
but are finding that script 'ocmupgcf.sql' is taking a long time.
The script basically consists of two update statements, each of which is taking 1.5 hours
to complete :
UPDATE ar_cmgt_cf_dtls
SET case_folder_detail_id = ar_cmgt_cf_dtls_s.nextval
WHERE case_folder_detail_id IS NULL;
COMMIT;
UPDATE ar_cmgt_cf_dtls
SET sequence_number = 1
where sequence_number IS NULL;
COMMIT;
We can see that both columns are new and therefore empty on every row in the table.
Tagged:
0