Oracle threaded execution

…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.

threaded-1

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

threaded-2

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.

threaded-3

Much better now.  How about the process counts?

threaded-4

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s