SELECT * FROM v$osstat;
v$osstat显示的是操作系统的系统使用情况统计,所有的数据都是累积的,要通过计算差值能得到某一个时间点的情况.连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options SQL> SELECT * FROM v$osstat; STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
NUM_CPUS 8
0 IDLE_TIME 80289442
1 BUSY_TIME 188668
2
STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
USER_TIME 70850
3 SYS_TIME 117818
4 AVG_IDLE_TIME 10033265
7
STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
AVG_BUSY_TIME 20643
8 AVG_USER_TIME 7340
9 AVG_SYS_TIME 11798
10
STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
RSRC_MGR_CPU_WAIT_TIME 0
14 NUM_CPU_CORES 2
16 PHYSICAL_MEMORY_BYTES 8589148160
1008
STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
VM_IN_BYTES 43552768
1009 VM_OUT_BYTES 245051392
1010
已选择14行。
v$osstat显示的是操作系统的系统使用情况统计,所有的数据都是累积的,要通过计算差值能得到某一个时间点的情况.连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options SQL> SELECT * FROM v$osstat; STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
NUM_CPUS 8
0 IDLE_TIME 80289442
1 BUSY_TIME 188668
2
STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
USER_TIME 70850
3 SYS_TIME 117818
4 AVG_IDLE_TIME 10033265
7
STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
AVG_BUSY_TIME 20643
8 AVG_USER_TIME 7340
9 AVG_SYS_TIME 11798
10
STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
RSRC_MGR_CPU_WAIT_TIME 0
14 NUM_CPU_CORES 2
16 PHYSICAL_MEMORY_BYTES 8589148160
1008
STAT_NAME VALUE
---------------------------------------------------------------- ----------
OSSTAT_ID
----------
VM_IN_BYTES 43552768
1009 VM_OUT_BYTES 245051392
1010
已选择14行。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货