Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
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.