Database Management Systems

A cache hit occurs when requested data is found in the database buffer cache, eliminating the need to read from disk. This is much faster than a cache miss, which requires reading from data files on disk. The buffer cache is part of the SGA and stores frequently accessed data blocks to improve performance.

The database buffer cache internally manages three types of buffers: free buffers (available for use), dirty buffers (modified but not yet written to disk), and pinned buffers (currently being read or modified). Access buffers is not a standard buffer cache type. The buffer cache uses these states to manage data blocks efficiently and maintain data consistency.

PGA memory is configured using the PGA_AGGREGATE_TARGET parameter, which specifies the total memory for all server processes combined. You cannot specify memory per individual server process. Oracle dynamically allocates PGA memory from this aggregate target to individual processes as needed, optimizing overall memory usage.

The redo log buffer is a volatile memory area in the SGA that holds redo entries temporarily before they are written to disk. On instance failure, the contents of the redo log buffer are lost. Recovery uses the online redo log FILES (on disk) and archived redo logs, not the buffer contents. The buffer is just a staging area, not a recovery source.

LGWR (Log Writer) is the Oracle background process responsible for writing redo entries from the redo log buffer in the SGA to the online redo log files on disk. DBWR writes data blocks, CKPT is the checkpoint process, and ARCH archives redo logs. LGWR is the only process that writes redo log buffer to redo log files.

The Shared Pool in the SGA contains the Library Cache (which stores parsed SQL and PL/SQL) and the Data Dictionary Cache (which caches data dictionary information). The Data Buffer Cache is a separate SGA component for caching data blocks. SQL buffer cache is not a standard Oracle term - the Library Cache handles SQL caching.

The Large Pool is an optional area of the SGA used for RMAN backups, Recovery Manager operations, and shared server connections. The Shared Pool, Redo Log Buffer, and (in most configurations) Java Pool are mandatory components required for basic database operation. Large Pool can be configured but is not required.

SMON (System Monitor) is the Oracle background process responsible for instance recovery. It performs recovery at startup by rolling forward changes from redo logs and rolling back uncommitted transactions. PMON monitors and recovers user processes, while IMON and INSTMON are not standard Oracle processes.

Cursor bind information and private runtime values are stored in the Private SQL Area within the PGA (Process Global Area). Each user session has its own Private SQL Area containing bind variable values, execution state, and other session-specific SQL information. The Cursor and SQL area terminology is less precise.

DBWR (Database Writer) is the Oracle background process responsible for writing modified data blocks from the database buffer cache to the data files. LGWR writes redo logs, PMON manages processes, and CKPT updates headers.

When a SQL query is parsed, Oracle first checks the Data Dictionary Cache to verify that referenced tables, columns, and other objects exist and the user has proper privileges. The Library Cache stores parsed SQL, but object definitions come from the Data Dictionary Cache. The buffer cache stores data blocks, not metadata.

In Lotus Notes, only the Manager access level grants permission to delete databases entirely. Designers can modify design elements but cannot delete the database itself. Editors and Authors have document-level permissions only. The Manager role is the only one with full administrative control including database deletion.

In older versions of Lotus Notes (now IBM Notes/Domino), applications were referred to as 'databases' because they were stored as .NSF database files. The terminology evolved over time, with 'application' becoming the preferred term in modern versions.

In Lotus Notes, the Manager access level has full administrative rights including the ability to encrypt databases. Manager access can modify ACL settings, delete databases, and perform encryption operations. Designer and Editor have more limited permissions and cannot encrypt databases.

Replication is the process of synchronizing (or re-synchronizing) the contents of one database replica with another, ensuring data consistency across sites. The other options mistakenly describe replication as preventing synchronization or copying.