R12.2 Apps DBA. Powered by Blogger.

R12.2 patch is taking way too much time, almost 24h

No comments :
60 2220972027 SYSTEM 14840 SELECT RIDX.OWNER OWNER , RIDX.INDEX_NAME REVISED_INDEX , RIDX.TABLE_OWNER TABLE_OWNER , RIDX.TABLE_NAME TABLE_NAME , OIDX.INDEX_NAME ORIGINAL_INDEX , CON.CONSTRAINT_NAME CONSTRAINT_NAME FROM DBA_INDE
select sql_text from v$sqltext where hash_value=2220972027 order by piece asc;
EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

No comments :

Post a Comment

Note: only a member of this blog may post a comment.