Problem with result cache on 18c for logging by client id

Open piotry opened this issue 6 years ago • 1 comments

We got strange issue for 18c (Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production)

We created a functionality for user to be able to log on client_id in APEX application.

This way we can check stuff on prod systems.

But! :)

On 18c it is not working. When one user is turning ON the logging only for his client id (USER:SESSION) it is turning this on for everybody.

Having a lot of logging in application we are not able to use it in there.

I was investigating and found out that this is happening when we got RESULT_CACHE in get_pref function. Removing that is making all good.

Also we got the same solution on 12c (Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production) and it works.

I checked in documentation what is different in result cache between those two. Nothing found ...

I can provide links to application where this can be changed.

Jun 05 '19 07:06 piotry

Followup on this one :) This list explains the difference between SE2 and EE: http://bicarait.com/2016/12/06/1154/

Difference is that in SE2 result cache is not available hence it's not used.

I'll disable this in EE server for now. But i think i would like to use result cache in EE for separate client id ones - how?

Jun 05 '19 07:06 piotry