31.
Which command can you execute to get details about the number of sessions connected via
Shared Server?
- A.lsnrctl sessions
- B.lsnrctl conn
- C.lsnrctl status
- D.lsnrctl services
- E.None of these
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Dispatchers register with listeners so that when a listener redirects a connection to a dispatcher, the listener knows how many active connections the dispatcher is serving. The lsnrctl status command summarizes the number of connections established, connections currently active, and other valuable information regarding Shared Server. The lsnrctl services command summarizes only dispatchers and does not display any details about connections. |
32.
You want to gather performance and tuning-related information for the shared server processes.
You should start by querying which of the following views?
- A.V$USERS
- B.V$CIRCUIT
- C.V$SHARED_SERVER_MONITOR
- D.V$SESS_STATS
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| You can query the V$SHARED_SERVER_MONITOR view to display information about the maximum number of connections and sessions, the number of servers started and terminated, and the server high-water mark. These numbers can help determine whether you should start more shared servers. |
33.
What is the process that notifies the listener after a database connection is established?
- A.SMON
- B.DBWR
- C.PMON
- D.LGWR
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The PMON process notifies the listener after a client connection is established. This is so that the listener can keep track of the number of connections being serviced by each dispatcher. |
34.
You want to gather information about users connected via Shared Server connections. Which of
the following is the view that contains this information?
- A.V$USERS
- B.V$QUEUE
- C.V$SESS_STATS
- D.V$CIRCUIT
- E.None of the above
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| You can use several V$ views to manage the Shared Server. V$QUEUE gives information regarding the request and response queues. V$USERS and V$SESS_STATS are not valid views. V$CIRCUIT gives information about the users who are connected via Shared Server connections, and it provides the necessary information. |
35.
Which of the following is false about request queues?
- A.They reside in the SGA.
- B.They are shared by all the dispatchers.
- C.Each dispatcher has its own request queue.
- D.The shared server processes remove requests from the request queue.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Request queues reside in the SGA, and there is one request queue per instance. This is where shared server processes pick up requests that are made by users. Dispatchers have their own response queues, but they share a single request queue. |
|
|
||||||||||||||||||||||||||||
