查询ORACLE的CPU占用率、内存的使用量

Question

请教各位高手：怎样查询ORACLE的CPU占用率、内存的使用量（使用SQL语句）？
谢谢！！

Answer 1

呃。。要是再WINDOWS下可以用任务管理器~

Answer 2

查看自己所占用的内存应该可以，
但是看系统内存有这样的命令吗？怀疑top ,free
iostat,这些都是系统命令

Answer 3

SELECT * FROM v$osstat;
v$osstat显示的是操作系统的系统使用情况统计,所有的数据都是累积的,要通过计算差值能得到某一个时间点的情况.

Answer 4

学习了
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 3月 13 16:46:10 2009Copyright (c) 1982, 2005, Oracle.  All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> SELECT * FROM v$osstat;STAT_NAME                                                             VALUE
---------------------------------------------------------------- ----------
 OSSTAT_ID
----------
NUM_CPUS                                                                  8
         0IDLE_TIME                                                          80289442
         1BUSY_TIME                                                            188668
         2
STAT_NAME                                                             VALUE
---------------------------------------------------------------- ----------
 OSSTAT_ID
----------
USER_TIME                                                             70850
         3SYS_TIME                                                             117818
         4AVG_IDLE_TIME                                                      10033265
         7
STAT_NAME                                                             VALUE
---------------------------------------------------------------- ----------
 OSSTAT_ID
----------
AVG_BUSY_TIME                                                         20643
         8AVG_USER_TIME                                                          7340
         9AVG_SYS_TIME                                                          11798
        10
STAT_NAME                                                             VALUE
---------------------------------------------------------------- ----------
 OSSTAT_ID
----------
RSRC_MGR_CPU_WAIT_TIME                                                    0
        14NUM_CPU_CORES                                                             2
        16PHYSICAL_MEMORY_BYTES                                            8589148160
      1008
STAT_NAME                                                             VALUE
---------------------------------------------------------------- ----------
 OSSTAT_ID
----------
VM_IN_BYTES                                                        43552768
      1009VM_OUT_BYTES                                                      245051392
      1010
已选择14行。SQL>