No question at this time
DBA Top 10
1 M. Cadot 6300
2 B. Vroman 2700
3 P. Tsongayinwe 1500
4 P. Wisse 1300
4 J. PĂ©ran 1300
6 A. Kavsek 900
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48709
Total active users1322
Act. users last 24h2
Act. users last hour0
Registered user hits last week33
Registered user hits last month217
Go up

High swap utilization
Next thread: Restore of database
Prev thread: ORA-01017: invalid username/password; logon denied

Message Score Author Date
Hi, There is an incident where I observed high ...... Balaji M Jun 12, 2022, 11:28
Hi Balaji M, These are Oracle server processes ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jun 12, 2022, 15:12
Hi Philip, Kindly find the output below of sga ...... Balaji M Jun 13, 2022, 12:08
Hi Balaji, First you need to know the fysical m...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Philip Wisse Jun 14, 2022, 14:16
Hi Philip, Thank you. Regards, Balaji... Balaji M Jun 15, 2022, 11:56

Follow up by mail Click here


Subject: High swap utilization
Author: Balaji M, India
Date: Jun 12, 2022, 11:28, 169 days ago
Os info: Red hat Linux 7.9
Oracle info: Oracle 12.2.1.0
Message: Hi,

There is an incident where I observed high swap utilization in the server and requested
OS team to have a look into this issue. OS team checked and gave their findings.

These are the process consuming more swap space
[root@1234 tmp]$ sh swapuse.sh
top swap using processes which are still running:
13604316 kb oracle ora_arc0_TBKEMR

13604136 kb oracle ora_arc1_TBKEMR
13578756 kb oracle ora_cjq0_TBKEMR
13574432 kb oracle ora_arc2_TBKEMR
13573136 kb oracle ora_dbw0_TBKEMR
13569904 kb oracle ora_arc3_TBKEMR
13566576 kb oracle oracleTBKEMR (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
13566392 kb oracle ora_ofsd_TBKEMR
13566160 kb oracle ora_gen1_TBKEMR
13565840 kb oracle ora_lreg_TBKEMR
Does some have any idea what these oracle process are and how to reduce the utilization.

Regards,
Balaji


Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: High swap utilization
Author: Philip Wisse, Netherlands
Date: Jun 12, 2022, 15:12, 169 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Balaji M,

These are Oracle server processes belonging to the TBKEMR instance.
They use much 'shared memory' which is reported by your 'swapuse.sh' script, this is expected behaviour.

In order to find the culprit try the 'top' command.

Or use 'show sga' from within sqplus.
https://www.orafaq.com/wiki/SGA

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: High swap utilization
Author: Balaji M, India
Date: Jun 13, 2022, 12:08, 168 days ago
Message: Hi Philip,

Kindly find the output below of sga & top command.

SQL> SELECT * FROM v$sga;

NAME VALUE CON_ID
-------------------- ---------- ----------
Fixed Size 12173600 0
Variable Size 1.7180E+10 0
Database Buffers 7918845952 0
Redo Buffers 54931456 0
SQL>
SQL> select * from v$sgainfo;
NAME BYTES RES CON_ID
-------------------------------- ---------- --- ----------
Fixed SGA Size 12173600 No 0
Redo Buffers 54931456 No 0
Buffer Cache Size 7918845952 Yes 0
In-Memory Area Size 0 No 0
Shared Pool Size 1.2549E+10 Yes 0
Large Pool Size 201326592 Yes 0
Java Pool Size 134217728 Yes 0
Streams Pool Size 134217728 Yes 0
Shared IO Pool Size 536870912 Yes 0
Data Transfer Cache Size 0 Yes 0
Granule Size 67108864 No 0
NAME BYTES RES CON_ID
-------------------------------- ---------- --- ----------
Maximum SGA Size 2.5166E+10 No 0
Startup overhead in Shared Pool 433864528 No 0
Free SGA Memory Available 4160749568 0
14 rows selected.
Top command
PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND

4422 root 20 0 839288 15628 6320 S 2.3 0.1 5733:59 BESClient
10883 oracle -2 0 23.9g 1440 1044 S 0.7 0.0 1651:51 ora_vktm_tbkemr
1200 root 20 0 342940 2060 1296 S 0.3 0.0 203:59.09 vmtoolsd
11031 oracle 20 0 23.9g 175672 173696 S 0.3 1.4 388:04.62 ora_dbrm_tbkemr
14806 oracle 20 0 23.9g 762292 751860 S 0.3 6.3 172:59.58 ora_cjq0_tbkemr
59792 root 20 0 4951980 261776 3624 S 0.3 2.2 27:50.47 ds_am
80986 root 20 0 1267096 25020 10272 S 0.3 0.2 0:23.75 TaniumClient
120695 oracle 20 0 168996 2780 1768 R 0.3 0.0 0:00.14 top
1 root 20 0 191660 3428 1624 S 0.0 0.0 528:29.67 systemd
2 root 20 0 0 0 0 S 0.0 0.0 10:36.33 kthreadd
4 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
6 root 20 0 0 0 0 S 0.0 0.0 16:08.22 ksoftirqd/0
7 root rt 0 0 0 0 S 0.0 0.0 0:30.76 migration/0

Could you please provide your inputs on above outputs.

Regards,
Balaji


Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: High swap utilization
Author: Philip Wisse, Netherlands
Date: Jun 14, 2022, 14:16, 167 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Balaji,

First you need to know the fysical mem available.
https://kerneltalks.com/linux/4-ways-to-check-size-of-physical-memory-in-linux/

In the top output all the oracle server processes use '23.9g' virtual memory. This is shared memory. If the shared memory is too large (over say 50% of physical) you can adjust the values for SGA_TARGET and/or MEMORY_TARGET.
https://docs.oracle.com/database/121/TGDBA/part3.htm#TGDBA290

If the shared memory is not too large you'll have to find other processes with large 'VIRT' values.
https://access.redhat.com/discussions/3202051
https://access.redhat.com/documentation/fr-fr/red_hat_enterprise_linux/7/html/virtualization_tuning_and_optimization_guide/sect-virtualization_tuning_optimization_guide-memory-tuning
https://support.oracle.com/knowledge/Oracle%20Cloud/2197176_1.html

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: High swap utilization
Author: Balaji M, India
Date: Jun 15, 2022, 11:56, 166 days ago
Message: Hi Philip,

Thank you.

Regards,
Balaji
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here