Oracle Database Administration from Zero to Hero - Practice - Configuring Databases for Shared Server

This video tutorial covers the configuration and monitoring of shared server processes in a database environment. It begins with an introduction to the objectives, followed by steps to connect to shared server processes. The tutorial then details the configuration of shared server processes for the PTP 1 service and demonstrates how to monitor these processes. Finally, it discusses performance and load management, including setting parameters to control the number of shared server processes.

What is the default service that allows connections to shared server processes in SRV One?

• Ora DB XDB

• PDB1 Service

• DBCA Utility

• PTP 1 Service

What tool is used to connect to the root container as SYS user in SRV One?

• Putty

• Swing Bench

• SQL Developer

• VI Editor

What is the purpose of adding a new dispatcher configuration for PDB1 service?

• To replace the existing dispatcher

• To remove all dispatchers

• To add a new dispatcher while keeping the existing one

• To configure a dispatcher for a different database

What is the impact of setting a specific port number for a dispatcher process?

• It prevents the dispatcher from registering with the listener

• It sets the address attribute to the dispatcher's value

• It assigns a random port number to the dispatcher

• It allows multiple dispatchers to use the same port

What indicates a successful connection to the shared server process?

• The server column value is 'Shared'

• The listener port number is not used

• The dispatcher port number is used

• The server column value is 'None'

What is the effect of running CPU intense operations on the server column value in the video science session?

• The server column value changes to 'Shared'

• The server column value remains 'Idle'

• The server column value becomes 'Busy'

• The server column value changes to 'None'

What tool is used to monitor shared server processes in the hosting PC?

• VI Editor

• Swing Bench

• Putty

• SQL Developer

What is the format for dispatcher process names?

• DN where N is a three digit integer

• XN where N is a three digit integer

• SN where N is a three digit integer

• PN where N is a three digit integer

What parameter is used to control the maximum number of shared processes in a database server?

• Max PROCESSES

• Max CONNECTIONS

• Max DISPATCHERS

• Max SHARED SERVERS

What happens to the number of shared server processes when the Max SHARED SERVERS parameter is set to five?

• The number of shared server processes remains the same

• The number of shared server processes increases

• The number of shared server processes decreases

• The number of shared server processes becomes zero