Archival job fails on Oracle
On Oracle, the archival job fails with the following error message: ORA-04031: unable to allocate bytes of shared memory
Solution: On the data warehouse, run the following command as a SYS user:
alter system flush shared_pool
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*