Questions and Answers
What does the term 'CDB' stand for in Oracle Database architecture?
A server process can read and write into the SGA, but a client process cannot.
True
What is a disadvantage of using a shared server process in Oracle databases?
What is the role of an application container within a CDB?
Signup and view all the answers
A dedicated server process can service multiple user processes simultaneously.
Signup and view all the answers
In Oracle architecture, a PDB is a portable collection of ______, schema objects, and nonschema objects.
Signup and view all the answers
What needs to be configured for a database to enable shared server processes?
Signup and view all the answers
Match the Oracle Database process types with their descriptions:
Signup and view all the answers
The architecture where client applications request operations to be performed on the database server is known as _______.
Signup and view all the answers
Which of the following describes an instance in Oracle Database?
Signup and view all the answers
Which of the following is a potential benefit of using a shared server process?
Signup and view all the answers
Match the architecture type to its description:
Signup and view all the answers
An Oracle Database can have only one PDB at any given time.
Signup and view all the answers
The shared server process is always enabled by default in an Oracle database.
Signup and view all the answers
What are the three kinds of processes in an Oracle database server?
Signup and view all the answers
In what scenario should a shared server be used according to general guidelines?
Signup and view all the answers
Which type of file contains user or application data in a database?
Signup and view all the answers
The spfile can be manually modified using a text editor.
Signup and view all the answers
What is the primary function of the online redo log files?
Signup and view all the answers
The ______ file contains critical information about the database itself.
Signup and view all the answers
Match the following files with their descriptions:
Signup and view all the answers
Which of the following files is used when the spfile is not available?
Signup and view all the answers
The parameter file is optional for starting an Oracle instance.
Signup and view all the answers
Name one type of file that contributes to the successful operation of the database.
Signup and view all the answers
Study Notes
Server Processes in Oracle Database
- Two types of server processes: dedicated and shared.
- Dedicated server process services one user process exclusively.
- Shared server process can service multiple user processes, requiring configuration for activation.
Dedicated Server Architecture
- Provides a direct, dedicated connection between the user and the database.
Shared Server Architecture
- Benefits include:
- Reduced OS process count and decreased instance PGA memory.
- Enhanced scalability allowing more simultaneous client connections.
- Potentially quicker under high connection/disconnection rates.
- Disadvantages include:
- Possible slower response times.
- Limited support for full database features.
- Increased setup and tuning complexity.
- Recommended for environments with high concurrent connections exceeding OS limits.
Application Architecture
- Encompasses the computing environment for database applications connecting to Oracle.
- Client/server architecture involves client applications requesting operations from the database server.
- Multitier architecture uses application servers to perform operations, reducing database load.
Oracle Database Server Architecture
- Consists of an Oracle instance (combination of SGA and Oracle processes) and an Oracle database (storage structure).
Multitenant Architecture
- Allows an Oracle database to operate as a Container Database (CDB).
- CDB can house multiple user-created Pluggable Databases (PDBs) and application containers.
- PDBs function as separate databases containing schemas, schema objects, and nonschema objects.
- Application containers store application-related data and metadata.
Database Instance Structure
- Involves processes that facilitate the database operations:
- Client processes initiated by user connection requests.
- Server processes manage sessions and communicate with the Oracle instance.
- Background processes perform routine maintenance tasks.
Physical Database Structure
- Three main file types:
- Control files: Critical data about the database.
- Data files: Contain user/application data.
- Online redo log files: Ensure database instance recovery.
- Additional necessary files:
- Parameter files, backup files, alert log files, password files, archive log files, and trace files.
Parameter File
- Essential for creating and starting an Oracle instance.
- Two types:
- SPFILE: Binary file, preferred, modifiable only via Oracle database.
- INIT file: Text file for starting the instance if SPFILE is unavailable, modifiable using OS text editors.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
This quiz explores the two types of server processes in Oracle Database: dedicated and shared. Understand their architectures, advantages, disadvantages, and ideal use cases for high-concurrency environments. Test your knowledge on how these processes impact database performance and scalability.
