1 Reply Latest reply on Jul 12, 2017 7:55 AM by Syed Hamd Salman

    Isolation level in OBIEE RPD connection pool

    1877648

      Hi !

       

      There are four types of Isolation levels namely Dirty,Committed,Repeated, and Serializable.

      We have gone through the help section of OBIEE RPD, however found it difficult to understand.

      Can anyone help understand those levels with some example ?

       

      Secondly there is a Default level also. Which one is this amongst the four mentioned above ?

       

      Thirdly does it impact  OBIEE report (in terms of speed) ?

       

      We use SQL Server 2008, and presently it is set to Default in our connection pool. Do you suggest any other value ?

       

      Regards

      AM