Skip to Main Content

Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to set session level parameter for a single report

User508999-OCOct 3 2014

Hi

We are using OBIEE 11.1.1.6.5 on Oracle 11.2.0.2 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 )

Comments

Paulzip

You only have to worry about objects that reference the invalid objects (directly or through other dependencies), not objects that the invalid objects reference (caveated that they are not referenced by another invalid object).

E.g. Dropping PLAP/TEMP_DIS_CONSTR/PROCEDURE, won't affect SYS/ALL_CONS_COLUMNS/VIEW

BEDE

That depends...

Some of those invalid packages/procedures/functions/views may need to have their code changed so that they may be used later on. So, I don't think it is the case to rush into such spring cleaning. First use dbms_utility.compile_schema(x_schema,false) to see what can recompile, then send all the developers you know to be working on that database a list of the invalid objects, eventually including also the errors, with the warning that, if in within two weeks they won't fix them, then they will be dropped.

Yet, if your concern is space, tables are those that take most of the space.

4089142

Thanks so much! That's exactly what I did. First I tried to see what invalid objects I could recompile (except I used @utlrp.sql). Then, I sent all the developers a list of the invalid objects with each error included so that they can look through and fix the code if need be.

4089142

Thanks for the clear and concise answer Paulzip! This is exactly what I needed to know!

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 31 2014
Added on Oct 3 2014
0 comments
913 views