License high water mark in alert log

        我们在关闭数据库时,数据库日志会记录以下信息:

Fri Dec 25 12:14:55 2009
Shutting down instance: further logons disabled
Fri Dec 25 12:14:56 2009
Stopping background process CJQ0
Fri Dec 25 12:14:56 2009
Stopping background process QMNC
Fri Dec 25 12:14:58 2009
Stopping background process MMNL
Fri Dec 25 12:14:59 2009
Stopping background process MMON
Fri Dec 25 12:15:00 2009
Shutting down instance (immediate)
License high water mark = 112
All dispatchers and shared servers shutdown
Fri Dec 25 12:15:05 2009
ALTER DATABASE CLOSE NORMAL

记录了从数据库启动到数据库关闭前用户连接数的最高峰,和查询v$license视图字段sessions_highwater值一样

 SQL> select sessions_max s_max, sessions_warning s_warning,
         sessions_current s_current, sessions_highwater s_high, users_max
         from v$license;

              S_MAX   S_WARNING   S_CURRENT      S_HIGH   USERS_MAX
         ----------  ----------  ----------  ----------  ----------
                  0           0           6           6           0

所以通过这个值,我们可以确定当前连接数是否正常,如果这个值突然很大,那我们就要检查应用。

可以参考metalink ID 1034330.6

License high water mark in alert log
  文档 ID:  注释:1034330.6 类型:  BULLETIN
  上次修订日期:  28-JUN-2007 状态:  PUBLISHED


ABSTRACT
  What does the license high water mark represent in the "alert.log"?

SCOPE & APPLICATION
  General information for DBAs.


License High Water Mark in Alert Log:
=====================================

When shutting down the database, you notice various numbers being generated for
the license high water mark. According to the 8i Server Reference Guide, the
license high water mark number in the column of v$license represents the
highest number of concurrent users sessions since the instance started.
         

    Example:

    Shutting down instance (normal)
    License high water mark = 3


You can query the V$LICENSE data dictionary view for the high water mark, it is
sessions_highwater column.  Also, the current limits for all of the license
settings, the current number of sessions, and the maximum number of concurrent
sessions for the instance can be queried in V$LICENSE.

    SQL> select sessions_max s_max, sessions_warning s_warning,
         sessions_current s_current, sessions_highwater s_high, users_max
         from v$license;

              S_MAX   S_WARNING   S_CURRENT      S_HIGH   USERS_MAX
         ----------  ----------  ----------  ----------  ----------
                  0           0           6           6           0

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-659868/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-659868/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值