0 Replies Latest reply on Sep 29, 2016 12:22 AM by ramya3250

    FND_CONCURRENT_REQUESTS gets recompiled

    ramya3250

      FND_CONCURRENT_REQUESTS gets recompiled which is owned by APPLSYS user.

       

      last_ddl_time updated in dba_objects table. any reason why ?

       

      purge concurrent request and/or manager data not ran during this time

      no update made on this table

       

      If we run gather schema statistics on ALL schema will that recompile this object.

      i see last_analyzed on this table matching the gather stats concurrent request timing.