APEX

Hi experts,

We're using Apex 24.1.8 and Ords 24.2.3.r2011847 and the database schemas get locked in our Dev instance every few days, so we get this error. Unlocking the accounts solves the issue, but after few days we got it again.

We'd like to find the root cause of that.

SELECT u.username
     ,account_status
     ,lock_date
     ,profile
 FROM dba_users u
WHERE u.username LIKE '%APEX%';

SELECT *
 FROM dba_profiles
WHERE profile = 'APPUSR_DEFAULT';

Any ideas?

Thanks,
Jose.