Patch 3007067: Script okcupcstd.sql Runs for a Very Long Time
Opened by VPC member on behalf of a customer.
Patch 3007067 was being applied to resolve a performance issue in Contract. But a worker failed after 13.5 hr on the admin/CM node:
-------------- patch log -----------
Assigned: file okcupcstd.sql on worker 1 for product okc username OKC.
Time is: Sat Jun 09 2012 06:39:52
FAILED: file okcupcstd.sql on worker 1 for product okc username OKC.
Time is: Sat Jun 09 2012 20:08:19
ORA-01555: snapshot too old: rollback segment number 62 with name "_SYSSMU62$" too small
-------------- Worker log -----------
Start time for file is: Sat Jun 09 2012 06:39:52
sqlplus -s APPS/***** @/apps/applprg/appl/okc/11.5.0/patch/115/sql/okcupcstd.sql
DECLARE
Tagged:
0