L
Large Pool

An optional area in the SGA (System Global Area) used for specific database operations such as backup, recovery, or the UGA (User Global Area), when using the Oracle Shared Server configuration. See also System Global Area (SGA); User Global Area (UGA).

least recently used (LRU) algorithm

The mechanism that the Oracle kernel uses to manage the Shared Pool and database buffer caches, whereby the SQL or buffers that have been least recently accessed are those that are overwritten to make room for new SQL or buffers when these requests are made by user Server Processes.

LGWR

See log writer.

listener

A server-side process that is responsible for listening and establishing connections to an Oracle server in response to a client ...

Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.