29 积分	187 好友	71 主题

发消息

答网友问：请问一下大家，awr报告的会有一个sessions

1^#

发表于 2014-1-13 21:29:56 | 查看: 3115| 回复: 3

答网友问：请问一下大家，awr报告的会有一个sessions 从哪里来？

QQ图片20140113212933.jpg

分享0

下载专业ORACLE数据库恢复工具PRM-DUL For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 13764045638 QQ: 47079569

收藏0 回复只看该作者道具举报

Liu Maclean(刘相兵

2^#

发表于 2014-1-13 21:30:25

as maclean answered:

SQL> set linesize 200 pagesize 2000
select * from dba_hist_sysstat where stat_name='logons current'

SNAP_ID    DBID INSTANCE_NUMBER STAT_ID STAT_NAME                                                          VALUE
---------- ---------- --------------- ---------- ---------------------------------------------------------------- ----------
      3  360655143             1 3080465522 logons current                                                          16
      4  360655143             1 3080465522 logons current                                                          16
      1  360655143             1 3080465522 logons current                                                          16
      2  360655143             1 3080465522 logons current                                                          16
      10  360655143             1 3080465522 logons current                                                          16
      5  360655143             1 3080465522 logons current                                                          16
      6  360655143             1 3080465522 logons current                                                          16
      7  360655143             1 3080465522 logons current                                                          17
      8  360655143             1 3080465522 logons current                                                          16
      9  360655143             1 3080465522 logons current                                                          16
      14  360655143             1 3080465522 logons current                                                          16
      15  360655143             1 3080465522 logons current                                                          16
      16  360655143             1 3080465522 logons current                                                          16
      11  360655143             1 3080465522 logons current                                                          16
      12  360655143             1 3080465522 logons current                                                          16
      13  360655143             1 3080465522 logons current                                                          16
      22  360655143             1 3080465522 logons current                                                          16
      17  360655143             1 3080465522 logons current                                                          16
      18  360655143             1 3080465522 logons current                                                          16
      19  360655143             1 3080465522 logons current                                                          16
      20  360655143             1 3080465522 logons current                                                          16
      21  360655143             1 3080465522 logons current                                                          16
      25  360655143             1 3080465522 logons current                                                          17
      26  360655143             1 3080465522 logons current                                                          17
      27  360655143             1 3080465522 logons current                                                          17
      24  360655143             1 3080465522 logons current                                                          16
      23  360655143             1 3080465522 logons current                                                          17
      32  360655143             1 3080465522 logons current                                                          17
      33  360655143             1 3080465522 logons current                                                          17
      34  360655143             1 3080465522 logons current                                                          17
      28  360655143             1 3080465522 logons current                                                          17
      29  360655143             1 3080465522 logons current                                                          17
      30  360655143             1 3080465522 logons current                                                          17
      31  360655143             1 3080465522 logons current                                                          17
      36  360655143             1 3080465522 logons current                                                          17
      37  360655143             1 3080465522 logons current                                                          17
      38  360655143             1 3080465522 logons current                                                          17
      39  360655143             1 3080465522 logons current                                                          17
      35  360655143             1 3080465522 logons current                                                          17
      44  360655143             1 3080465522 logons current                                                          17
      45  360655143             1 3080465522 logons current                                                          17
      40  360655143             1 3080465522 logons current                                                          17
      41  360655143             1 3080465522 logons current                                                          17
      42  360655143             1 3080465522 logons current                                                          17
      43  360655143             1 3080465522 logons current                                                          17
      48  360655143             1 3080465522 logons current                                                          17
      49  360655143             1 3080465522 logons current                                                          17
      46  360655143             1 3080465522 logons current                                                          17
      47  360655143             1 3080465522 logons current                                                          18

回复只看该作者道具举报