第一步：登入dqlplus
Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.

C:Documents and SettingsAdministrator>sqlplus "sys/sys@oradb as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on 星期一 9月 6 17:43:56 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

查看句柄数
SQL> select count(*) from v$open_cursor;

  COUNT(*)
----------
      1167

查看进程数
SQL> select count(*) from v$process;

  COUNT(*)
----------
        33