Because no one expects the Data Inquisition

Oracle threaded execution

So I was looking at my test server today and noticed that my new container database has a large number of processes associated with it – 180 in all.

Oracle introduced the option of threaded execution a while back and I decided to enable it here. By default, it’s disabled in Oracle 12.1.0.2.

So let’s make the change and bounce the instance.

Hmmm – what’s going on here? Well, with threaded execution, you have to provide the username and password even if you have a password file etc…. Oracle’s documentation for threaded execution (link) clearly mentions this.

Much better now. How about the process counts?

Also much improved, 11 instead of 180.

As I wrote this, I realised that my fellow Enkitec friend, Martin Bach had a post on this. His is much better, so take a look here.