Shulou(Shulou.com)06/01 Report--

This article mainly introduces LINUX how to check the amount of memory occupied by the real PGA. It is very detailed and has a certain reference value. Friends who are interested must finish it!

I don't know what the problem is, the memory of PGA is the private memory of the process, how to check whether the operating system memory that the process really occupies is based on v$process.PGA_ALLOC_MEM, or through other means.

Select PGA_ALLOC_MEM/1024/1024 MEM from v$process ORDER BY MEM; MEM-2.20257282... ... Omit 30 lines here (all starting with 2) 2.952572823.07757282. ... Omit 20 lines here (all starting with 3) 3.976674084.01507282. ... Several lines are omitted here (all starting with 4) 4.952572826.540089617.265072828.6635942511.077572819.539647121.552945121.912510922.054684622.427945122.427945122.427945122.99159246.304097275.9259233

You can see that according to the v$process provided by ORACLE, the amount of PGA memory consumed by each process is generally only 3m.

But the operating system memory that the process really takes up is more than that.

Ps aux | grep oraclecrmd | grep-v grepUSER PID% CPU% MEM VSZ RSS TTY STAT START TIME COMMANDoracle 415 0.1 0.0 152056 31896? Ss Sep22 4:21 oraclecrmd1 (LOCAL=NO) oracle 417 0.1 0.0 152048 31932? Ss Sep22 5:43 oraclecrmd1 (LOCAL=NO)... A little. Dozens of lines are omitted here oracle 15258 0.1 0.0 152040 31720? Ss Sep23 3:32 oraclecrmd1 (LOCAL=NO) oracle 15423 0.0 154100 31688? Ss Sep23 3:59 oraclecrmd1 (LOCAL=NO)

RSS is listed as the amount of memory consumed by the real process, and you can see that each ORACLE process takes up about 30m of operating system memory.

You can also view it through status under / proc/process_id

Admin@crmd-rac1:/home/admin > cd / proc/31493admin@crmd-rac1:/proc/31493 > cat status Name: oracleState: s (sleeping) SleepAVG: 98%Tgid: 31493Pid: 31493PPid: 0Uid: 501 501 501 501Gid: 501 501 501 501FDSize: 64Groups: 501 502 VmPeak: 23591404 kBVmSize: 151020 kBVmLck: 0 kBVmHWM: 38340 kBVmRSS: 29236 kBVmData: 2476 kBVmStk: 200 kBVmExe: 100616 kBVmLib: 16156 kBVmPTE: 308 kBStaBrk: 0e750000 kBBrk: 0e80d000 kBStaStk: 7fff4a3b7ab0 kBThreads: 1SigQ: 0/399360SigPnd: 0000000000000000ShdPnd: 0000000000000000SigBlk: 0000000000000000SigIgn: 0000000006005207SigCgt: 00000001c9802cf8CapInh: 0000000000000000CapPrm: 0000000000000000CapEff: 0000000000000000Cpus_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000 FfffffffMems_allowed: 00000000,00000003VmRSS: 29236 kB Is the amount of operating system memory consumed by the process. Of course, it is also the most convenient to see through the TOP command. Tasks: 526 total, 1 running, 525 sleeping, 0 stopped, 0 zombieCpu (s): 3.8%us, 0.5%sy, 0.0%ni, 95.4%id, 0.1%wa, 0.0%hi, 0.2%si, 0.0%stMem: 49448636k total, 31725736k used, 17722900k free, 825208k buffersSwap: 20482864k total, 289672k used, 2019319k free 1430524k cached PID USER PR NI VIRT RES SHR S% CPU% MEM TIME+ COMMAND 17954 oracle 18 0 22.5g 34m 24m D 15.5 0.18purl 49.84 oracle 415 oracle 15 022.5g 31m 24m S 0.0 0.14lv 21.48 oracle 417 oracle 15022.5g 31m 25m S 0.00.1m S 0.00.15More43.78 oracle 419 oracle 15022.5g 33m 25m S 0.0 5:19 . 47 oracle 456 oracle 15 0 22.5g 29m 23m S 0.0 0.1 6:42.85 oracle 582 oracle 15 0 22.5g 31m 24m S 0.0 0.1 4:48.01 oracle 584 oracle 15 0 22.5g 29m 23m S 0.0 0.1 4:26.69 oracle 586 oracle 15 0 22.5g 28m 22m S 0.0 0.1 5:39.92 oracle 692 oracle 15 0 22.5g 34m 28m S 0.0 0.1 6:40.93 oracle 694 oracle 150 22.5g 31m 24m S 0.0 0.1 5:42.40 oracle 1392 oracle 150 22.5g 31m 24m S 0.0 0.1 4:51.74 oracle 1508 oracle 150 22.5g 26m 21m S 0.0 0.1 4:07.42 oracle 1997 oracle 150 22.5g 17m 13m S 0.0 0.0 0:00.03 oracle 2000 oracle 150 22.5g 30m 24m S 0.0 0.1 3:22.19 oracle 2609 oracle 15 0 22.5g 16m 12m S 0.0 0.0 74:30.50 oracle 2611 oracle 15 0 22.5g 18m 13m S 0.0 0.0 0:00.99 oracle 2613 oracle 15 0 22.5g 15m 11m S 0.0 0.0 0:10.73 oracle 2615 oracle 15 0 22.5g 22m 15m S 0.0 0.0 37:54.79 oracle 2619 oracle 150 0 22.5 g 31m 17m S 0.0 0.1 48 oracle 2621 oracle-20 22.5 g 32m 17m S 0.0 0.1 356 oracle 2625 oracle-2 022.5 g 32m 17m S 0.0 0.1 355m S 0.0 0.1 355 oracle 2629 oracle-20 22.5 g 32m 17m S 0.0 0.1352v 42.52 oracle 2633 oracle-20 22.5 g 32m 17m S 0.00.1 356 : 19.10 oracle 2637 oracle 15 0 22.5g 15m 11m S 0.0 0.0 0:05.06 oracle 2639 oracle 16 0 22.5g 43m 32m S 0.0 0.1 183:11.05 oracle 2641 oracle 16 0 22.5g 40m 32m S 0.0 0.1 179:37.22 oracle 2643 oracle 15 0 22.5g 32m 28m S 0.0 0.1 1139:53 oracle 2645 oracle 15 0 22.5g 32m 22m S 0.0 0.1 20 : 43.16 oracle 2647 oracle 15 0 22.5g 30m 24m S 0.0 0.1 7:30.23 oracle 2649 oracle 15 0 22.5g 20m 16m S 0.0 0.0 0:00.12 oracle 2651 oracle 15 0 22.5g 27m 21m S 0.0 0.1 1:57.78 oracle 2653 oracle 15 0 22.5g 35m 28m S 0.0 0.1 1:54.48 oracle 2655 oracle 15 0 22.5g 19m 16m S 0.0 0.0 13:57.91 oracle 2994 oracle 15 0 22.5g 32m 26m S 0.0 0.1 3:29.14 oracle 3001 oracle 15 0 22.5g 29m 23m S 0.0 0.1 2:57.37 oracle 3360 oracle 15 0 22.5g 20m 13m S 0.0 0.0 26:39.06 oracle 3375 oracle 15 0 22.5g 20m 16m S 0.0 0.0 0:02.00 oracle 3616 oracle 15 0 22.5g 29m 23m S 0.0 0.1 3:34.69 oracle

The amount of operating system memory consumed by RES as a process is about 30m.

We usually allocate memory for ORACLE not only considering the memory occupied by ORACLE itself, but also considering the operating system memory occupied by the process itself.

The above is all the content of the article "how to check the amount of memory used by real PGA by LINUX". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.