My Oracle Support Banner

Under AIX Environment, Does Oracle Use CPU When MPROTECT_TXT is Off? (Doc ID 2397561.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

In an environment where MPROTECT_TXT in the AIX 7.2 environment is ON and when a large amount of connections are made to the Oracle Database in a short period of time,
the CPU will soar as compared to MPROTECT_TXT being OFF.

In the result of vmstat, "us" (used memory) is displayed as 99%:

----- vmstats -----
2018/02/14 03:14:42 r b avm fre re pi po fr sr cy in sy cs us sy id wa alp flp
2018/02/14 03:16:12 227 0 16876276 13306721 0 0 0 0 0 0 862 29120 15780 99 1 0 0 0 0
2018/02/14 03:16:22 220 0 16895806 13287165 0 0 0 0 0 0 1141 41119 16367 99 1 0 0 0 0
---------------------

However, based on the results of prof and AWR results, Oracle Database seems not to consume CPU.

----- prof -----
Total % For oracle[19924186] thread 34997293 (USER) = 0.03

User Process %
============= ======
oracle 0.03

Profile: oracle

Total % For oracle[19924186] thread 34997293 (oracle) = 0.03
----------------

----- AWR -----
Load Average Begin Load Average End %User %System %WIO %Idle
4.17 6.54 9.2 9.8 0.0 81.1
Instance CPU

%Total CPU %Busy CPU Û time waiting for CPU (Resource Manager)
4.8 25.3 0.0
----------------

Does ORACLE use the CPU?

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.