Oracle‎ > ‎Misc‎ > ‎

EPMA / EPM SQL Database Script

Against the EPMA SQL Database in 11.1.1.2.1 versions and against all EPM MS SQL DBs in EPM 11.1.2.2 and greater:
------------------/
alter database epma_prod set single_user with rollback immediate;
alter database epma_prod set READ_COMMITTED_SNAPSHOT ON;
alter database epma_prod SET ALLOW_SNAPSHOT_ISOLATION ON;
alter database epma_prod SET MULTI_USER WITH NO_WAIT;
------------------/
Comments