Re: Oracle 12c threaded execution

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 31 Mar 2019 13:12:19 -0400
Message-ID: <b8bfeb6b-a9c7-0ce7-9e7f-c127239f9c0b_at_gmail.com>

Hi Jeff,

I blogged about it long time ago:

https://dbwhisperer.wordpress.com/2013/10/04/multi-threaded-oracle-12c-architecture-on-linux-2/

Since then, I've seen that multi-threaded version didn't cause the problem with latches  when I've set OPTIMIZER_DYNAMIC_SAMPLING to 11, which was caused by an early bug in Oracle 12c. That is logical because

multi-threaded latches are cheaper than the multi-process ones. Also, 
multi-threading architecture uses a bit less kernel mode than the 
multi-process one. Other than that, you will lose "sqlplus / as sysdba". 

I would suggest testing to see whether this new architecture fits your purposes. It is possible to switch between the architecture, you don't need to re-create the database.

Regards

On 3/31/19 11:58 AM, Jeffrey Beckstrom wrote:
> We are migrating to Oracle 12c on Linux. We saw threaded execution
> listed as a new feature of 12c. I am seeking comments as to its use.
> Is it something to be considered?
>
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l

Received on Sun Mar 31 2019 - 19:12:19 CEST