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只要连接过就会递增
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只要连接过就会递增