Multi-Tenant

Do not set job_queue_processes at PDB level in 12.1.0.2

1 Comment / 12c, 12cR1, Multi-Tenant / By

MOS Doc ID 2175443.1 goes into more detail, including the following quote: It is possible to set job_queue_processes at pdb level on 12.1.0.2 multitenant database, but it does not work correctly. I have managed to reproduce the actual behavior. Of particular concern is that this allows a local user on one PDB to disrupt things …

Do not set job_queue_processes at PDB level in 12.1.0.2 Read More »

Adaptive Dynamic Sampling and the Result Cache: RC Latch

1 Comment / 12c, Adaptive Optimizer Features, Dynamic Statistics, Multi-Tenant / By

After we migrated one of our instances from Oracle 11.2.0.4 to 12.1.0.2 we ran into some serious latch contention that basically took down the instance.  From online research, and discussion with other DBAs I don’t think we are the only customer that has run into this problem, so I wanted to share my investigation and …

Adaptive Dynamic Sampling and the Result Cache: RC Latch Read More »

Scroll to Top