Hi Database Experts,
As part of code deployment, we also execute Database DML and DDL. Recently a cursor statement (select / update) badly affected our PPTE environment. Since we have less data in lower environment. we actually couldnt catch this. however it took 3+ hrs in PPTE.
Is there any automated way to check this poor coding when executing in lower environment please?
- Can we add custom sql (as part of post sql on every deployment) to generate profile or gather stats when executing in lower env? So we check this report every time
- Anything with non-sys or non-system user. Basically with the user account who executes SQLs.
- SonarQ profile