Oracle Architecture & Tools Flashcards

Which Oracle background process is responsible for writing dirty buffers from the buffer cache to data files?

Answer: DBWR

DBWR (Database Writer) moves modified (dirty) buffers from the buffer cache to the physical data files on disk.

What is the purpose of the Oracle Redo Log Buffer?

Answer: Holds redo entries before they are written to redo log files

The Redo Log Buffer is a circular buffer in the SGA that holds redo entries (change vectors) before LGWR flushes them to the online redo log files.

Which Oracle tool provides a graphical interface for database administration including startup, shutdown, and performance monitoring?

Answer: Enterprise Manager Database Express

Oracle Enterprise Manager Database Express is the web-based GUI tool bundled with Oracle Database for administration tasks like startup/shutdown, storage, and performance.

What does the Oracle PMON background process do?

Answer: Cleans up failed user process resources and rolls back uncommitted transactions

PMON (Process Monitor) detects failed user processes and cleans up resources such as locks, releasing them and rolling back uncommitted transactions.

In Oracle, what is the Shared Pool primarily used for?

Answer: Caching parsed SQL and PL/SQL code along with data dictionary information

The Shared Pool stores the Library Cache (parsed SQL/PL/SQL) and the Data Dictionary Cache (metadata), allowing reuse of parsed statements.

Which Oracle utility is a command-line tool used specifically for backup and recovery operations?

Answer: RMAN

RMAN (Recovery Manager) is Oracle's dedicated command-line utility for backup, restore, and recovery of Oracle databases.

What is an Oracle Instance?

Answer: The combination of memory structures and background processes that manage the database

An Oracle Instance consists of the SGA (memory) and the set of background processes; it provides access to the database but is distinct from the database files themselves.