ps -ef | egrep "$ORACLE_SID" | awk '{print $2}' | xargs -n 1 ps vw \
| awk '{print $7-$10,$0;priv+=$7-$10;trs[$9]=$10} \
END{for(tsiz in trs){TRS+=trs[tsiz]}; print priv+TRS," :TOTAL (",priv,"private memory,",TRS,"shared code segments - TRS)"}' \
| sed '1p;/^0/d' | sort -n +0접속한 유저의 ORACLE_SID 환경변수를 가져오므로 필요시 변경.
사용 예 )
[lfmalldb01d:/DBMS/LFMQ] ps -ef | egrep "$ORACLE_SID" | awk '{print $2}' | xargs -n 1 ps vw \
> | awk '{print $7-$10,$0;priv+=$7-$10;trs[$9]=$10} \
> END{for(tsiz in trs){TRS+=trs[tsiz]}; print priv+TRS," :TOTAL (",priv,"private memory,",TRS,"shared code segments - TRS)"}' \
> | sed '1p;/^0/d' | sort -n +0
0 PID TTY STAT TIME PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND
164 62980774 pts/0 A 0:00 0 164 184 xx 16 20 0.0 0.0 tail -f /DBMS/LFMQ/LFDBA/batch/logs/clon_LFMQ.20230322
168 4916192 pts/3 A 0:00 0 168 188 xx 16 20 0.0 0.0 tail -f alert_LFMQ.log
536 27263876 - A 0:00 1 536 848 xx 266 312 0.0 0.0 /bin/ksh /DBMS/LFMQ/LFDBA/batch/scripts/02_RMAN_restore.sh
552 65405570 - A 0:00 0 552 864 xx 266 312 0.0 0.0 /bin/ksh /DBMS/LFMQ/LFDBA/batch/scripts/clon_LFMQ.sh.20230
752 11666330 - A 0:00 0 752 784 xx 13 32 0.0 0.0 ora_dism_LFMQ
1080 27132932 - A 61:46 1 1084 1160 xx 78 80 0.0 0.0 mxg_sndf c LFMQ D
1100 31916982 - A 0:30 2 1100 1200 xx 97 100 0.0 0.0 mxg_obsd -c LFMQ -OTHERD -i 10 -D
16824 33292958 - A 0:00 453 16824 17404 xx 737 580 0.0 0.0 /DBMS/LFMQ/product/12c/bin/tnslsnr LFMQ -inherit
21680 64684780 - A 0:00 0 21680 227184 xx 398736 205504 0.0 0.0 ora_tt01_LFMQ
21936 2687940 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_mman_LFMQ
21936 3933090 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_psp0_LFMQ
21936 5440628 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_vkrm_LFMQ
21936 19071944 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_clmn_LFMQ
21936 25428778 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_vktm_LFMQ
21936 27657160 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_pmon_LFMQ
21936 32113800 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_reco_LFMQ
21936 32179106 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_pman_LFMQ
21936 34538574 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_pxmn_LFMQ
21936 59507318 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_diag_LFMQ
21936 59965698 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_tmon_LFMQ
21936 63635820 - A 0:00 0 21936 227440 xx 398736 205504 0.0 0.0 ora_smon_LFMQ
22000 22414500 - A 0:00 0 22000 227504 xx 398736 205504 0.0 0.0 ora_mmon_LFMQ
22256 61604748 - A 0:00 0 22256 227760 xx 398736 205504 0.0 0.0 ora_o000_LFMQ
22448 3408896 - A 0:00 0 22448 227952 xx 398736 205504 0.0 0.0 ora_svcb_LFMQ
22448 5571450 - A 0:06 0 22448 227952 xx 398736 205504 0.0 0.0 ora_mmnl_LFMQ
22832 5702820 - A 0:01 0 22832 228336 xx 398736 205504 0.0 0.0 ora_dbrm_LFMQ
24176 3539926 - A 0:01 0 24176 229680 xx 398736 205504 0.0 0.0 ora_fenc_LFMQ
24816 52560520 - A 0:00 0 24816 230320 xx 398736 205504 0.0 0.0 ora_gen0_LFMQ
25008 22938874 - A 0:00 0 25008 230512 xx 398736 205504 0.0 0.0 ora_rbal_LFMQ
25200 9962302 - A 0:00 0 25200 230704 xx 398736 205504 0.0 0.0 ora_asmb_LFMQ
25712 24183766 - A 0:00 0 25712 231216 xx 398736 205504 0.0 0.0 ora_ofsd_LFMQ
25712 26805160 - A 0:00 0 25712 231216 xx 398736 205504 0.0 0.0 ora_gen1_LFMQ
26032 11076438 - A 0:00 0 26032 231536 xx 398736 205504 0.0 0.0 ora_lgwr_LFMQ
27248 64225762 - A 0:02 0 27248 232752 xx 398736 205504 0.0 0.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
27376 9438136 - A 0:00 0 27376 232880 xx 398736 205504 0.0 0.0 ora_ckpt_LFMQ
28016 8520670 - A 0:00 0 28016 233520 xx 398736 205504 0.0 0.0 ora_lreg_LFMQ
28848 1311664 - A 0:00 0 28848 234352 xx 398736 205504 0.0 0.0 ora_dbw3_LFMQ
28848 3736714 - A 0:00 0 28848 234352 xx 398736 205504 0.0 0.0 ora_dbw1_LFMQ
28848 14943182 - A 0:00 0 28848 234352 xx 398736 205504 0.0 0.0 ora_dbw5_LFMQ
28848 61997408 - A 0:00 0 28848 234352 xx 398736 205504 0.0 0.0 ora_dbw6_LFMQ
28848 65274420 - A 0:00 0 28848 234352 xx 398736 205504 0.0 0.0 ora_dbw7_LFMQ
28848 65405338 - A 0:00 0 28848 234352 xx 398736 205504 0.0 0.0 ora_dbw4_LFMQ
28848 65929692 - A 0:00 0 28848 234352 xx 398736 205504 0.0 0.0 ora_dbw2_LFMQ
30896 24839072 - A 0:00 0 30896 236400 xx 398736 205504 0.0 0.0 ora_dbw0_LFMQ
45104 1049490 - A 0:00 0 45104 250608 xx 398736 205504 0.0 0.0 ora_tt00_LFMQ
45680 7537580 - A 0:00 0 45680 251184 xx 398736 205504 0.0 0.0 ora_arc3_LFMQ
45680 53019128 - A 0:00 0 45680 251184 xx 398736 205504 0.0 0.0 ora_arc1_LFMQ
46000 54722908 - A 0:00 0 46000 251504 xx 398736 205504 0.0 0.0 ora_arc0_LFMQ
46000 55050626 - A 0:00 0 46000 251504 xx 398736 205504 0.0 0.0 ora_arc2_LFMQ
63032 55575448 - A 1173:59 1328 63544 64148 xx 1118 1116 0.0 0.0 mxg_rts c LFMQ r D
73456 18285624 - A 0:01 3 73456 278960 xx 398736 205504 0.0 0.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
75120 8717264 - A 0:25 0 75120 280624 xx 398736 205504 0.0 0.0 ora_dia0_LFMQ
82096 20054886 - A 0:00 0 82096 287600 xx 398736 205504 0.0 0.0 ora_mark_LFMQ
1616696 51118350 - A 5:16 1 1616696 1822200 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1616696 60621190 - A 5:05 0 1616696 1822200 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1682296 10027908 - A 4:11 1 1682296 1887800 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1682296 10421162 - A 4:33 2 1682296 1887800 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1682296 11601008 - A 4:58 2 1682296 1887800 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1682296 15074266 - A 5:00 2 1682296 1887800 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1682296 16974894 - A 5:21 0 1682296 1887800 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1682296 30736686 - A 5:14 0 1682296 1887800 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1682296 56426814 - A 5:24 0 1682296 1887800 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1682296 65012452 - A 4:47 1 1682296 1887800 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
1682936 60948954 - A 5:36 1 1682936 1888440 xx 398736 205504 0.1 2.0 oracleLFMQ (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)
20014808 :TOTAL ( 19807064 private memory, 207744 shared code segments - TRS)맨 마지막에 20014808 가 총 사이즈로 단위는 KB로 본 예제에서는 총 20G 정도 사용 중.
'OraclE' 카테고리의 다른 글
| sqlarea 쿼리 확인 (0) | 2022.07.21 |
|---|---|
| SPM - 튜닝된 SQL의 실행계획을 등록하고 적용 하는 방법 (0) | 2022.06.13 |
| SPM(SQL PLAN MANAGEMENT) (0) | 2022.06.13 |
| OGG 동기화 테이블 추가 (0) | 2022.04.04 |
| active session history (0) | 2022.01.30 |