Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

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*