1. 查看所有表空間大小 SQL select tablespace_name,sum(bytes)/1024/1024 || 'M' from dba_data_files group by tablespace_name; 2. 已經(jīng)使用的表空間大小 SQL select tablespace_name,sum(bytes)/1024/1024 || 'M' from dba_free_space gro...
鄠邑ssl適用于網(wǎng)站、小程序/APP、API接口等需要進行數(shù)據(jù)傳輸應(yīng)用場景，ssl證書未來市場廣闊！成為創(chuàng)新互聯(lián)公司的ssl證書銷售渠道，可以享受市場價格4-6折優(yōu)惠！如果有意向歡迎電話聯(lián)系或者加微信：028-86922220（備注：SSL證書合作）期待與您的合作！
運行nmon，然后按鍵盤上的“T”，
然后按 4 按內(nèi)存占用大小排序，類推：[1=Basic 2=CPU 3=Perf 4=Size 5=I/O 6=Cmds] （* 界面上有提示 *）
命令行輸入nmon：
root..[/] nmon
------------------------------ x
x N N M M OOOO N N For online help type: h x
x NN N MM MM O O NN N For command line option help: x
x N N N M MM M O O N N N quick-hint nmon -? x
x N N N M M O O N N N full-details nmon -h x
x N NN M M O O N NN To start nmon the same way every time? x
x N N M M OOOO N N set NMON ksh variable, for example: x
x ------------------------------ export NMON=cmt x
x TOPAS_NMON x
x 8 - CPUs currently x
x 8 - CPUs configured x
x 1498 - MHz CPU clock rate x
x PowerPC_POWER5 - Processor x
x 64 bit - Hardware x
x 64 bit - Kernel x
x 1,06-2298H - Logical Partition x
x 6.1.6.20 TL06 - AIX Kernel Version x
x bjrest01 - Hostname x
x bjrest01 - Node/WPAR Name x
x 062298H - Serial Number x
x IBM,9133-55A - Machine Type
按T鍵之后，再按數(shù)字鍵4
lqtopas_nmonqqC=many-CPUsqqqqqqqqHost=bjrest01qqqqqqqRefresh=2 secsqqq10:01.52qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk
x Top-Processes-(176) qqqqqMode=4 [1=Basic 2=CPU 3=Perf 4=Size 5=I/O 6=Cmds]qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqx
x PID %CPU Size Res Res Res Char RAM Paging Command x
x Used KB Set Text Data I/O Use io other repage x
x13500544 1.3 211M80320 45048 35272 0 1% 0 0 0 Oracle x
x18677916 0.2 207M75684 45048 30636 0 1% 0 0 0 oracle x
x11468978 0.5 207M75596 45048 30548 0 1% 0 0 0 oracle x
x 6357214 0.5 207M75596 45048 30548 0 1% 0 0 0 oracle x
x26738798 0.1 200M68188 45048 23140 0 1% 0 0 0 oracle x
x24641536 0.0 198M66944 45048 21896 0 0% 0 0 0 oracle x
x 6291688 0.1 198M66864 45048 21816 0 0% 0 0 0 oracle x
x24117292 0.0 198M66680 45048 21632 0 0% 0 0 0 oracle x
x30933066 0.0 197M65876 45048 20828 3 0% 0 0 0 oracle x
x23724058 0.0 193M61892 45048 16844 0 0% 0 0 0 oracle x
x 6619378 0.0 193M61308 45048 16260 0 0% 0 0 0 oracle x
x11075676 0.0 193M61212 45048 16164 0 0% 0 0 0 oracle x
x 7208984 0.1 193M61012 45048 15964 0 0% 0 2 0 oracle x
x17891498 0.0 192M60792 45048 15744 0 0% 0 0 0 oracle x
x12189894 0.0 192M60784 45048 15736 0 0% 0 0 0 oracle x
x16449708 0.0 192M60688 45048 15640 0 0% 0 0 0 oracle x
x15269948 0.0 192M60680 45048 15632 0 0% 0 0 0 oracle x
x21561584 0.0 192M60680 45048 15632 0 0% 0 0 0 oracle x
x 7536748 0.0 192M60668 45048 15620 0 0% 0 0 0 oracle x
x26345508 0.0 192M60664 45048 15616 0 0% 0 0 0 oracle x
x23986378 0.1 192M60660 45048 15612 0 0% 0 0 0 oracle x
x30474330 0.0 192M60660 45048 15612 0 0% 0 0 0 oracle
可用UNIX命令“ipcs”查看共享內(nèi)存的起始地址、信號量、消息隊列。
在svrmgrl下，用“oradebug ipc”，可看出ORACLE占用共享內(nèi)存的分段和大小。
example:
SVRMGR oradebug ipc
-------------- Shared memory --------------
Seg Id Address Size
1153 7fe000 784
1154 800000 419430400
1155 19800000 67108864
oracle內(nèi)存使用情況主要分兩個方面，一個是PGA，一個是SGA
簡單查詢的話，通過SQL語句在PLSQL里面運行一下就可以了
代碼如下：
select?'SGA'?as?name
,round(sum(value)?/?1024?/?1024,?2)?||?'M'?as?"SIZE(M)"
from???v$sga
union
select?'PGA'?as?name,?round(value?/?1024?/?1024,?2)?||?'M'?as?"SIZE(M)"
from???v$pgastat
where??name?=?'total?PGA?allocated'
復(fù)制粘貼后，進入PLSQL，登陸之后，新建頁面運行查看結(jié)果即可。
重慶分公司
重慶分公司
