2 Replies Latest reply on Oct 11, 2013 5:14 AM by user2302799

    Report specific connection pool, is it possible?


      I have 2 connections pools in the physical layer of the database. One connecting to a database which host the data load part and the other pointing to a standby database (replica of the primary database). For a few marketing segmentation cache related queries in the BI Apps warehouse, there is a need to point a specific report to use the connection pool to the active server, instead of standby. Is there a specific configuration setting that can be done at the report level to use a separate connection pool, instead of the what is is used by default for all the reporting queries?