This discussion is archived
2 Replies Latest reply: Oct 10, 2013 10:14 PM by user2302799 RSS

Report specific connection pool, is it possible?

user2302799 Newbie
Currently Being Moderated

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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points