[20190202]使用smem查询oracle内存使用.txt

来源：这里教程网时间：2026-03-03 12:54:39 作者：

[20190202]使用smem查询oracle内存使用.txt --//快放假,学习smem的使用.安装下载略.我一般选择rpm包安装.这些步骤略. # man smem ... DESCRIPTION smem reports physical memory usage, taking shared memory pages into account. Unshared memory is reported as the USS (Unique Set Size). Shared memory is divided evenly among the processes sharing that memory. The unshared memory (USS) plus a process's proportion of shared memory is reported as the PSS (Proportional Set Size). The USS and PSS only include physical memory usage. They do not include memory that has been swapped out to disk. .. --//金山词霸翻译如下: smem报告物理内存使用情况，并考虑到共享内存页。未共享内存报告为USS(唯一设置大小)。共享内存在共享该内存的进程之间平均分配。未共享内存(USS)加上进程共享内存的比例报告为PSS(比例设置大小)。USS和PSS只包括物理内存的使用。它们不包括已交换到磁盘的内存。 --- Linux使用到了虚拟内存(virtual memory)，因此要准确的计算一个进程实际使用的物理内存就不是那么简单。只知道进程的虚拟内存大小也并没有太大的用处，因为还是无法获取到实际分配的物理内存大小。 RSS(Resident set size)，使用top命令可以查询到，是最常用的内存指标，表示进程占用的物理内存大小。但是，将各进程的RSS值相加，通常会超出整个系统的内存消耗，这是因为RSS中包含了各进程间共享的内存。 PSS(Proportional set size)所有使用某共享库的程序均分该共享库占用的内存时，每个进程占用的内存。显然所有进程的PSS之和就是系统的内存使用量。它会更准确一些，它将共享内存的大小进行平均后，再分摊到各进程上去。 USS(Unique set size )进程独自占用的内存，它是PSS中自己的部分，它只计算了进程独自占用的内存大小，不包含任何共享的部分。 VSS – Virtual Set Size 虚拟耗用内存(包含共享库占用的内存),有一些叫VIRT. RSS – Resident Set Size 实际使用物理内存(包含共享库占用的内存) PSS – Proportional Set Size 实际使用的物理内存(比例分配共享库占用的内存) USS – Unique Set Size 进程独自占用的物理内存(不包含共享库占用的内存) --//你可以看到PSS并非真实应该的内存量,而是平摊到各个进程上,不过总量还是很准确的说明该数据库实例当前使用的内存量. --//通过例子说明问题. 1.环境: SCOTT@book> @ ver1 PORT_STRING VERSION BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production SCOTT@book> show sga Total System Global Area 643084288 bytes Fixed Size 2255872 bytes Variable Size 205521920 bytes Database Buffers 427819008 bytes Redo Buffers 7487488 bytes # top -u oracle Tasks: 277 total, 1 running, 276 sleeping, 0 stopped, 0 zombie Cpu(s): 0.2%us, 0.5%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 132261196k total, 33468576k used, 98792620k free, 376912k buffers Swap: 31455264k total, 178916k used, 31276348k free, 23449376k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 35284 oracle 20 0 6671m 6.1g 6.1g S 14.6 4.8 11864:10 VirtualBox 61378 oracle -2 0 853m 15m 13m S 2.0 0.0 0:39.39 oracle .. 61374 oracle 20 0 855m 17m 14m S 0.0 0.0 0:00.41 oracle 61376 oracle 20 0 853m 15m 13m S 0.0 0.0 0:00.43 oracle 61382 oracle 20 0 853m 15m 13m S 0.0 0.0 0:00.08 oracle 61384 oracle 20 0 853m 15m 13m S 0.0 0.0 0:00.12 oracle 61386 oracle 20 0 854m 21m 18m S 0.0 0.0 0:00.16 oracle 61388 oracle 20 0 854m 16m 13m S 0.0 0.0 0:01.39 oracle 61390 oracle 20 0 853m 15m 13m S 0.0 0.0 0:00.15 oracle 61392 oracle 20 0 861m 22m 14m S 0.0 0.0 0:00.22 oracle 61394 oracle 20 0 859m 22m 13m S 0.0 0.0 0:00.17 oracle 61396 oracle 20 0 860m 22m 13m S 0.0 0.0 0:00.15 oracle 61398 oracle 20 0 869m 16m 14m S 0.0 0.0 0:00.75 oracle 61400 oracle 20 0 854m 16m 14m S 0.0 0.0 0:00.92 oracle 61402 oracle 20 0 860m 26m 22m S 0.0 0.0 0:00.36 oracle 61404 oracle 20 0 855m 21m 18m S 0.0 0.0 0:00.06 oracle 61406 oracle 20 0 859m 34m 28m S 0.0 0.0 0:00.65 oracle 61408 oracle 20 0 855m 20m 17m S 0.0 0.0 0:01.11 oracle 61410 oracle 20 0 859m 15m 12m S 0.0 0.0 0:00.04 oracle 61412 oracle 20 0 854m 14m 12m S 0.0 0.0 0:00.03 oracle --//通过TOP观察RES,SHR每个oracle进程在12-22M之间. 2.测试smem: # smem -tk -U oracle -P ora_ PID User Command Swap USS PSS RSS 61412 oracle ora_s000_book 0 2.0M 2.5M 14.8M 61384 oracle ora_diag_book 0 2.1M 2.6M 15.6M 61376 oracle ora_psp0_book 0 2.1M 2.6M 15.6M 61440 oracle ora_vkrm_book 0 2.1M 2.6M 15.4M 61378 oracle ora_vktm_book 0 2.1M 2.6M 15.6M 61382 oracle ora_gen0_book 0 2.1M 2.6M 15.7M 61462 oracle ora_smco_book 0 2.1M 2.6M 15.5M 61390 oracle ora_mman_book 0 2.1M 2.6M 15.7M 61420 oracle ora_arc0_book 0 2.4M 3.0M 16.3M 61400 oracle ora_ckpt_book 0 2.5M 3.1M 16.7M 61398 oracle ora_lgwr_book 0 2.7M 3.3M 17.2M 61388 oracle ora_dia0_book 0 2.9M 3.4M 16.4M 61374 oracle ora_pmon_book 0 2.7M 3.4M 17.0M 61410 oracle ora_d000_book 0 2.9M 3.4M 15.7M 61386 oracle ora_dbrm_book 0 2.6M 3.6M 21.0M 61404 oracle ora_reco_book 0 2.9M 3.9M 21.2M 61408 oracle ora_mmnl_book 0 3.5M 4.4M 20.9M 61402 oracle ora_smon_book 0 4.7M 6.4M 26.7M 61464 oracle ora_w000_book 0 6.8M 8.2M 26.8M 61438 oracle ora_cjq0_book 0 6.0M 8.3M 30.7M 61396 oracle ora_dbw2_book 0 8.2M 8.7M 22.1M 61394 oracle ora_dbw1_book 0 8.2M 8.8M 22.2M 61392 oracle ora_dbw0_book 0 8.9M 9.5M 23.1M 61406 oracle ora_mmon_book 0 7.0M 10.1M 34.2M 61422 oracle ora_arc1_book 0 27.1M 27.7M 41.3M ------------------------------------------------------------------------------- 25 1 0 119.0M 139.8M 513.5M --//后台进程大约139.8M(PSS).注意RSS的合计没有任何意义. # smem -tk -U oracle -P "oraclebook" PID User Command Swap USS PSS RSS 61508 oracle oraclebook (LOCAL=NO) 0 4.6M 7.6M 30.9M 61510 oracle oraclebook (LOCAL=NO) 0 5.7M 9.4M 34.5M 61474 oracle oraclebook (DESCRIPTION=(LO 0 18.3M 22.5M 48.5M ------------------------------------------------------------------------------- 3 1 0 28.7M 39.5M 113.9M --//可以发现仅仅3个连接用户(2个远程,1个本地).全部退出后如下: # smem -tk -U oracle -P "oraclebook" PID User Command Swap USS PSS RSS ------------------------------------------------------------------------------- 0 0 0 0 0 0 3.打开一些连接看看: # free -m total used free shared buffers cached Mem: 129161 32659 96501 0 368 22899 -/+ buffers/cache: 9391 119769 Swap: 30718 174 30543 --//在远程连接数据库: $ seq 150 | xargs -i{} echo "sqlplus -s -l scott/book@book <<< 'host sleep 60' &" | bash & --//说明一下我这台客户端很旧(rh4.3) ,xargs 命令仅仅支持-i(小写),一般现在的版本使用大写-I. # smem -tk -U oracle -P "oraclebook" PID User Command Swap USS PSS RSS 61976 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.5M 62054 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 62082 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.5M 62096 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.5M 62116 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 61882 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.5M 61894 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 61902 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 61934 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 61988 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.5M 62366 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 62376 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 62390 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.7M 62424 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.7M 62438 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 62450 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.7M 62402 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.7M 62412 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 62226 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.6M 62420 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.7M 62444 oracle oraclebook (LOCAL=NO) 0 2.4M 2.5M 20.7M ------------------------------------------------------------------------------- 150 1 0 364.1M 379.3M 3.0G --//可以发现每个连接消耗2.5M上下.再次说明RSS的累计没有任何意义. # free -m total used free shared buffers cached Mem: 129161 33100 96061 0 368 22899 -/+ buffers/cache: 9832 119329 Swap: 30718 174 30543 --//(33100-32659)/150 = 2.94M.仅仅连接不做什么操作消耗3M上下. 4.在本机打开一些连接看看: $ cat a.sh free -m >> /tmp/aa.txt seq 150 | xargs -I{} echo "sqlplus -s -l scott/book <<< 'host sleep 300' &" | bash & sleep 10 free -m >> /tmp/aa.txt --//60秒有一些短,使用300秒. # smem -tk -U oracle -P "sleep|sqlplus -s|oraclebook" PID User Command Swap USS PSS RSS 1676 oracle sleep 300 0 68.0K 68.0K 508.0K 1691 oracle sleep 300 0 68.0K 68.0K 508.0K 1765 oracle sleep 300 0 68.0K 68.0K 508.0K 1769 oracle sleep 300 0 68.0K 68.0K 508.0K 1793 oracle sleep 300 0 68.0K 68.0K 508.0K 1821 oracle sleep 300 0 68.0K 68.0K 508.0K 1824 oracle sleep 300 0 68.0K 68.0K 508.0K 1894 oracle sleep 300 0 68.0K 68.0K 508.0K 1900 oracle sleep 300 0 68.0K 68.0K 508.0K .. 1615 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 1636 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 1646 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 1651 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 1653 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 1655 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 1662 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 1755 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 1763 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.4M 1764 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M ... 1921 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 1935 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 1943 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 1959 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 1988 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 1990 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 2005 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 2015 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 2019 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 2027 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 2032 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 2034 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M 2038 oracle sqlplus -s -l 0 3.8M 3.8M 12.8M ------------------------------------------------------------------------------- 451 1 0 936.4M 959.2M 4.9G --//看到451,是因为我shell脚本多执行1次sleep. --//大约每个连接占959.2/150 = 6.39466M. --//与链接:http://blog.itpub.net/28218939/viewspace-2081645/测试,这个进程从操作系统层面看却占用了7M左右的内存很接近. --//我个人的感觉作者的测试有问题,因为要抛去sqlplus占用的内存.实际上真实的连接占用2.5M,一般oltp业务不会消耗很大的PGA. --//我个人估计每个连接消耗5M已经算很多了(平均下来).如果你应用存在有大量排序,hash等操作也许估计要大一些. $ cat /tmp/aa.txt total used free shared buffers cached Mem: 129161 32670 96490 0 368 22900 -/+ buffers/cache: 9402 119758 Swap: 30718 174 30543 total used free shared buffers cached Mem: 129161 33736 95424 0 368 22900 -/+ buffers/cache: 10467 118693 Swap: 30718 174 30543 --//33736 - 32670 = 1066,1066/150 = 7.11M. --//我随手看了生产系统情况,连接数4600上下(不包括后台进程) SELECT ROUND (AVG (PGA_USED_MEM) / 1024 / 1024, 2) N10 ,ROUND (AVG (PGA_ALLOC_MEM) / 1024 / 1024, 2) n20 ,ROUND (AVG (PGA_MAX_MEM) / 1024 / 1024, 2) n30 FROM v$process WHERE program = 'oracle@xxxxxx'; N10 N20 N30 ---------- ---------- ---------- 1.9 3.15 11.63 --//所以一般oltp系统很少大排序等情况,估算每个连接消耗3-4M在服务端已经很充足了.还可以通过如下证明 SELECT begin_time, end_time, ROUND (VALUE / 1024 / 1024 / 1024, 2) VALUE FROM v$sysmetric_history WHERE metric_name = 'Total PGA Allocated'; --//最大就是4.2G.查询如下也可以看到: SELECT maxval/1024/1024 n10 FROM DBA_HIST_SYSMETRIC_SUMMARY WHERE metric_name ='Total PGA Allocated' order by 1 desc; --//看到最大4.5G. 5.再重复测试看看,加上后台的情况: $ . a.sh # smem -tk -U oracle -P "oraclebook|ora_" PID User Command Swap USS PSS RSS 61412 oracle ora_s000_book 0 2.0M 2.1M 14.8M 61384 oracle ora_diag_book 0 2.1M 2.2M 15.6M 61376 oracle ora_psp0_book 0 2.1M 2.2M 15.6M 61440 oracle ora_vkrm_book 0 2.1M 2.2M 15.4M 61378 oracle ora_vktm_book 0 2.1M 2.2M 15.6M 61382 oracle ora_gen0_book 0 2.1M 2.2M 15.7M 61462 oracle ora_smco_book 0 2.1M 2.2M 15.5M 61390 oracle ora_mman_book 0 2.2M 2.2M 15.7M 2658 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 2683 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.3M 2803 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.4M 2811 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.4M ... 2484 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.5M 2353 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.5M 2807 oracle oraclebook (DESCRIPTION=(LO 0 2.4M 2.5M 20.5M 61420 oracle ora_arc0_book 0 2.4M 2.6M 16.3M 61400 oracle ora_ckpt_book 0 2.5M 2.7M 16.7M 61398 oracle ora_lgwr_book 0 2.7M 2.9M 17.2M 61374 oracle ora_pmon_book 0 2.8M 3.0M 17.0M 61410 oracle ora_d000_book 0 2.9M 3.0M 15.7M 2347 oracle oraclebook (DESCRIPTION=(LO 0 2.6M 3.1M 23.3M 61386 oracle ora_dbrm_book 0 2.6M 3.2M 21.0M 61388 oracle ora_dia0_book 0 3.2M 3.3M 16.8M 61404 oracle ora_reco_book 0 2.9M 3.5M 21.2M 61408 oracle ora_mmnl_book 0 3.6M 4.1M 21.5M 61402 oracle ora_smon_book 0 5.0M 6.3M 26.8M 61464 oracle ora_w000_book 0 7.0M 7.8M 26.8M 61396 oracle ora_dbw2_book 0 8.2M 8.4M 22.1M 61394 oracle ora_dbw1_book 0 8.2M 8.4M 22.2M 61438 oracle ora_cjq0_book 0 6.1M 8.5M 30.7M 61392 oracle ora_dbw0_book 0 8.9M 9.1M 23.1M 61406 oracle ora_mmon_book 0 8.6M 11.3M 34.3M 61422 oracle ora_arc1_book 0 27.1M 27.3M 41.3M ------------------------------------------------------------------------------- 175 1 0 482.8M 509.3M 3.5G --//打开150个连接,没有什么操作的情况下orcle消耗510M上下. 6.顺便看看关闭hugepages的情况: --//修改启动参数加入:*.use_large_pages='FALSE' */ SYS@book> startup pfile='/tmp/book.ora'; ORACLE instance started. Total System Global Area 643084288 bytes Fixed Size 2255872 bytes Variable Size 205521920 bytes Database Buffers 427819008 bytes Redo Buffers 7487488 bytes Database mounted. Database opened. $ cat /proc/meminfo | grep -i page AnonPages: 239200 kB PageTables: 40432 kB AnonHugePages: 0 kB HugePages_Total: 104 HugePages_Free: 104 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB --// 没有使用hugepages. $ . a.sh # smem -tuk -U oracle -P "oraclebook" -s pss User Count Swap USS PSS RSS oracle 150 0 375.1M 412.3M 3.6G --------------------------------------------------- 150 0 375.1M 412.3M 3.6G --//仅仅比前面多使用412.3-379.3 = 33M. --//再修改启动参数加入: *.pre_page_sga=true */ # smem -tuk -U oracle -P "oraclebook" -s pss User Count Swap USS PSS RSS oracle 150 0 366.1M 915.8M 91.5G --------------------------------------------------- 150 0 366.1M 915.8M 91.5G --//你可以发现使用pre_page_sga=true,不使用hugepages的情况下,消耗很大. --//915.8/150 = 6.10,这样倒是有可能达到7M以上的.^_^. 7.补充一下,我看了生产系统,sga很大的情况下,估计消耗还是很大的(估计页面表部分也占用不少).不过5M的量还是很充足的. # smem -tk -U oracle -P "oraclexxxx1" -s pss --//注意-s pss 要小写. PID User Command Swap USS PSS RSS 29000 oracle oraclexxxx1 (DESCRIPTION=(L 0 2.1M 2.1M 18.5M 116067 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 9658 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 58779 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 82193 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 82937 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 83543 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 86108 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 101419 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 126643 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 128585 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 61510 oracle oraclexxxx1 (LOCAL=NO) 0 2.3M 2.3M 20.5M 112481 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 112483 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 97264 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 111967 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 112505 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.3M 109834 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 109847 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 109851 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 109855 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 111860 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 111862 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 111965 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 111806 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 103363 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M 101308 oracle oraclexxxx1 (LOCAL=NO) 0 2.4M 2.4M 21.4M ... 119918 oracle oraclexxxx1 (LOCAL=NO) 0 7.0M 7.1M 36.1M 682 oracle oraclexxxx1 (LOCAL=NO) 0 7.1M 7.1M 34.4M 4524 oracle oraclexxxx1 (LOCAL=NO) 0 7.1M 7.1M 37.0M 70387 oracle oraclexxxx1 (LOCAL=NO) 0 7.1M 7.2M 37.3M 33543 oracle oraclexxxx1 (LOCAL=NO) 0 7.2M 7.2M 31.8M 93193 oracle oraclexxxx1 (LOCAL=NO) 0 7.2M 7.3M 34.9M 84138 oracle oraclexxxx1 (LOCAL=NO) 0 7.3M 7.3M 32.4M 114216 oracle oraclexxxx1 (LOCAL=NO) 0 7.3M 7.3M 35.1M 107901 oracle oraclexxxx1 (LOCAL=NO) 0 7.4M 7.4M 35.6M 74966 oracle oraclexxxx1 (LOCAL=NO) 0 7.4M 7.4M 35.5M 91516 oracle oraclexxxx1 (LOCAL=NO) 0 7.6M 7.6M 35.2M 67260 oracle oraclexxxx1 (LOCAL=NO) 0 7.6M 7.7M 35.9M 20245 oracle oraclexxxx1 (LOCAL=NO) 0 7.7M 7.8M 36.2M 105204 oracle oraclexxxx1 (LOCAL=NO) 0 7.8M 7.8M 37.3M 26185 oracle oraclexxxx1 (LOCAL=NO) 0 6.1M 8.2M 43.3M 101757 oracle oraclexxxx1 (LOCAL=NO) 0 8.7M 8.9M 36.8M 76951 oracle oraclexxxx1 (LOCAL=NO) 0 8.9M 9.6M 44.9M 33285 oracle oraclexxxx1 (LOCAL=NO) 0 12.2M 12.2M 40.4M 46048 oracle oraclexxxx1 (LOCAL=NO) 0 6.4M 13.0M 48.2M 83094 oracle oraclexxxx1 (LOCAL=NO) 0 6.9M 13.4M 52.2M 20360 oracle oraclexxxx1 (LOCAL=NO) 0 36.4M 36.4M 62.1M ------------------------------------------------------------------------------- 4247 2 0 18.8G 18.8G 110.3G --//18.8*1024/4247 = 4.53M. 平均5M的估计的量还是充足的.

编辑推荐：

返回列表

[20190202]使用smem查询oracle内存使用.txt

编辑推荐：

相关推荐

excel表格怎样在数字前输入0

excel表格里怎么替换数据

excel表格里面如何插入圆形

excel表格里怎么添加表格数据透视表

excel表格中怎么添加线边框

excel表格里怎样设置条件自动排序

excel表格例怎样导入数据库

Excel表格如何设置数据排序

excel表格里怎么选择性粘贴快捷键

excel表格怎么插入分隔符号

excel表格怎么设置多行多列数据内容排序

Excel表格如何设置行和列相互转换

excel表格连接公式怎么使用

excel表格怎样链接到cad中

雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效

制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用

最新软件资讯

热文推荐

天极热推