This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,827 Users
  • 2,269,775 Discussions


how to set session level parameter for a single report


We are using OBIEE on Oracle database AIX Platform. We have more than 2000 reports developed in OBIEE. We have performance issues with few reports.We have identified a solution for this issue - We need to set a parameter at sessions level  before executing the report SQL.   e.g alter session set <<parameter_>> = <<value>> . We need this statement to be executed for our one report alone. We don't want to set this at connection pool level since it will affect all queries using that connection. Please let us know how we can achieve this (I am looking for a initialize sql statement solution for this single report )

This discussion has been closed.