…or how I stopped worrying about process count sprawl.

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.