Oracle Architecture & Tools Flashcards

Which Oracle memory structure caches recently accessed data blocks?

Answer: Database Buffer Cache

The Database Buffer Cache is a critical component of the System Global Area (SGA) in Oracle, used to store copies of data blocks read from data files. Its purpose is to reduce physical I/O by caching frequently accessed data, allowing subsequent requests for the same data to be served directly from memory, which is much faster.

The process responsible for writing redo entries from the redo log buffer to the online redo log files is:

Answer: LGWR

The Log Writer (LGWR) background process is responsible for writing redo entries from the redo log buffer to the online redo log files on disk. LGWR is crucial for database recovery and ensuring transaction durability, as it records all changes made to the database before they are committed.

Which file records the physical structure of the database, including data file locations and log history?

Answer: Control file

The control file is a small, vital binary file that records the physical structure of the Oracle database. It contains essential information such as the database name, names and locations of data files and redo log files, and checkpoint information. The control file is indispensable for database startup and recovery operations.

Oracle SQL*Loader is primarily used to:

Answer: Load data from flat files into tables

Oracle SQL*Loader is a powerful utility specifically designed for high-speed data loading from external flat files (like CSV or text files) into Oracle database tables. It supports various data formats and can handle complex loading scenarios, making it ideal for bulk data imports and migrations.

Data Pump Export (expdp) differs from the legacy EXPORT utility by:

Answer: Supporting parallel, direct-path export

Data Pump Export (expdp) is a modern, high-performance utility that significantly improves upon the legacy EXPORT utility. Key advantages include supporting parallel execution for faster data movement, direct-path data access for efficiency, and server-side operation, which reduces network overhead and improves scalability.

Enterprise Manager (EM) Express provides:

Answer: Graphical web interface for basic administration

Oracle Enterprise Manager (EM) Express is a lightweight, web-based graphical user interface (GUI) embedded directly in the Oracle database. It provides a convenient way for database administrators to perform basic administrative tasks, monitor performance, and manage database components without needing a separate installation.

Automatic Storage Management (ASM) simplifies storage by:

Answer: Automating disk group management and striping

Automatic Storage Management (ASM) is an Oracle-managed volume manager and file system specifically designed for Oracle database files. It simplifies storage administration by automating tasks like disk group creation, mirroring, and striping data across multiple disks, enhancing performance and reliability. ASM abstracts the underlying storage complexity.

Which component parses and caches SQL execution plans in memory?

Answer: Library cache

The Library Cache, a component of the Shared Pool within the SGA, stores parsed SQL and PL/SQL code, including execution plans. When a SQL statement is executed, Oracle checks the Library Cache first; if the parsed statement and its execution plan are found, it avoids the costly parsing step, significantly improving performance.

Oracle Net Listener’s primary role is to:

Answer: Accept and route incoming client connections

The Oracle Net Listener is a server-side process that listens for incoming client connection requests to the Oracle database. Its primary role is to accept these requests, establish a connection to the appropriate database instance, and then hand off the connection to a server process. It acts as the initial point of contact for clients.