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行。