Popular White Paper On This Topic

If you want to change the session settings on oracle while running the reports.
You can specify the of commands for setting the parameters for that particular session.
1 Go Edit the data source ,
2 go into the Connection Tab.
3 Edit the Open Session Command
Examples of multiple commands:
<commandBlock>
<commands>
<sqlCommand>
<sql>alter session set optimizer_index_cost_adj=10</sql>
</sqlCommand>
<sqlCommand>
<sql>alter session set optimizer_index_caching=90</sql>
</sqlCommand>
</commands>
</commandBlock
We used the above approach to set the session level parameters from cognos.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.