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.

Categories: UncategorizedTags:

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

dbaonTap

What's #OnTapToday

globetrottingteen

If travel is an addiction, I'm afflicted.

The Black Veil One

My Diary Travel, Photography, My Sight About Somethings

Off to Ireland

Trotz Knacks den Schritt ins Ausland wagen

Randy Johnson's Oracle Blog

Oracle DBA Topics Including Unix, Scripting, & Automation

Model For {Change

Creating a positive change.

Globe-T.

Le Bonnet voyageur • The travelling Winter Hat

Another Photography Enthusiast

CLICKS THROUGH MY EYES

corkandspoon

Adventures in food and drink

Break Your Cage

Embracing The Unknown - Travel is not a pause from life, merely an extension of it.

My Girls On Tour

Fashion & Travel Blog by Abigail Royston

NYCQuirk

Two college girls trying to make the most out of living in NYC without breaking the bank!

Don Charisma

because anything is possible with Charisma

Bunny Kitchen

Exploring the possibilities of cruelty free food

Angelart Star

The beautiful picture of angels makes you happy.

%d bloggers like this: