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 (EXCEPT the HFM DB) 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;
------------------/

List the status of the databases in SQL:
------------------/
SELECT name
, s.snapshot_isolation_state
, snapshot_isolation_state_desc
, is_read_committed_snapshot_on
FROM sys.databases s
------------------/
Comments