134.View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 l

来源:互联网 发布:ssm框架打印sql语句 编辑:程序博客网 时间:2024/05/17 09:24
134.View the Exhibit and examine the output.
Which two statements are true regarding the LISTENER2 listener? (Choose two.)
A.The ORCL instance is registered dynamically with the listener.
B.The ORCL instance is registered statically in the listener.ora file.
C.The number of current client connections handled by the service handler is two.
D.The total number of client connections handled so far by the service handler is two.
答案:BD
解析:
A:错误,UNKNOW 为静态 READY 为动态这里显示的是UNKNOW说明是静态
B:正确
C:错误,这个的意思是当前的连接是两个
D:正确,这个的意思是到目前为止共有2个连接
我们测试一下
Service "wahaha3" has 1 instance(s).
  Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
--这里显示的是0个
[oracle@wahaha3 ~]$ sqlplus scott/tiger@wahaha3
SQL> quit
[oracle@wahaha3 ~]$ sqlplus scott/tiger@wahaha3
SQL> quit
[oracle@wahaha3 ~]$ sqlplus scott/tiger@wahaha3
SQL> quit
---连续连接3次,并且断开
Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
  Instance "wahaha3", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:3 refused:0 state:ready
         LOCAL SERVER
--查看当前是否存在连接         
[oracle@wahaha3 admin]$ ps -ef | grep oraclewahaha3 | grep -v grep                   
说明这里的established只要连接过就会递增
0 0
原创粉丝点击