No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48757 | | Total active users | 1320 | | Act. users last 24h | 0 | | Act. users last hour | 0 | | Registered user hits last week | 24 | | Registered user hits last month | 1443 |
|
Go up
High swap utilization
| 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 ...... |
 |
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...... |
 |
Philip Wisse |
Jun 14, 2022, 14:16 |
| Hi Philip,
Thank you.
Regards,
Balaji... |
|
Balaji M |
Jun 15, 2022, 11:56 |
| Subject: |
High swap utilization |
| Author: |
Balaji M, India |
| Date: |
Jun 12, 2022, 11:28, 470 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, 470 days ago |
| Score: |
|
| 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, 469 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, 468 days ago |
| Score: |
|
| 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, 467 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
|