统计一段时间内新建的session数

1、我们知道客户端连接服务器是需要通过监听的，有一个监听日志文件会记录相关连接建立的信息：

/u01/app/oracle/diag/tnslsnr/hddb1/listener/alert/log.xml

[oracle@hddb1 trace]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 25-MAY-2015 15:45:09

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.x)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oradb1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                07-MAY-2015 15:32:27
Uptime                    18 days 0 hr. 12 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/hddb1/listener/alert/log.xml

统计某一分钟内新建连接：

[oracle@hddb1 alert]$ grep "2015-05-25T14:35" log.xml| wc -l
221
[oracle@hddb1 alert]$ grep "2015-05-25T14:30" log.xml| wc -l
196
[oracle@hddb1 alert]$ grep "2015-05-25T14:39" log.xml| wc -l
191

2、通过AWR报告查看新建的连接数