Application upgrade process took too long

Hi

Our DB is 12.2 enterprise.  We recently upgrade from 11.2  to 12.2. No invalided objects. we did update stats on the DB(exec dbms_stats.gather_database_stats(); before appllication upgrade to new version   . Upgrade process is took long time.  I uploaded the AWRs here. according to sql id 2xhp4yk9s6xdk the table is the large table with in DB 100GB. other  are  >100GB.  2xhp4yk9s6xdk  the table FSD008 sql statement as follows.

update FSD008 set  col6_IND = 'X' where col6_IND = ' ' and LINE_NO = ' '

the col6_IND column got index where as LINE_NO  no indexes. total records  over 300 million  and  I run following  to see carnality