Have you defined CLIENT_ID in OBIEE yet?

Have you defined CLIENT_ID in your OBIEE RPD yet?
You really ought to.

As well as helping track down users of troublesome queries, it also tags dump files with the OBIEE user of an offending query should the worst occur:

And the culprit is ...

For details, see:

• Identify your OBIEE users by setting Client ID in Oracle connection
• Instrumenting OBIEE for tracing Oracle DB calls

Advertisement