| upgrade from 11.1.0.7 to 11.2.0.3 taking long time [message #584670] |
Thu, 16 May 2013 12:49  |
cakeday
Messages: 31
Registered: May 2010
|
Member |
|
|
i am upgrade oracle database from version 11.1.0.7 to 11.2.0.3;
the following step is taking a long time.
It has been at this step for about 20+ minutes now. Any idea's why and what i can do to improve this in the prod environment ?
= = =
I have ran all the prereqs. gathered stats and all.
The size of the dataabse is about 400 GB, single intance.
SQL> begin
2 if initjvmaux.registrystatus = 'UPGRADING' and
3 initjvmaux.startstep('FIX_DEPENDENCY_TIMESTAMPS') then
4 initjvmaux.rollbacksetup;
5 commit;
6 initjvmaux.rollbackset;
7 execute immediate 'update dependency$ set p_timestamp=(select stime from obj$ where obj#=p_obj#) where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and (select type# from obj$ where obj#=p_obj#)=29 and (select owner# from obj$ where obj#=p_obj#)=0';
8 commit;
9 initjvmaux.rollbackcleanup;
10 initjvmaux.endstep;
11 end if;
12 end;
13 /
Thank You bunches!
[Updated on: Fri, 17 May 2013 10:12] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
