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