What are the benefits of a shared server, bearing in mind that you have to be somewhat careful about the… Read more
Category: Exams of Oracle
DBWn: Database Block Writer- Oracle Processes
The database block writer (DBWn) is the background process responsible for writing dirty blocks to disk. DBWn will write dirty… Read more
PMON: The Process Monitor- Oracle Processes
This process is responsible for cleaning up after abnormally terminated connections. For example, if your dedicated server “fails” or is… Read more
Dedicated Server Connections- Oracle Processes
In dedicated server mode, there will be a one-to-one mapping between a client connection and a server process (or thread,… Read more
Dedicated/Shared Server Wrap-Up- Oracle Processes
Unless your system is overloaded, or you need to use a shared server for a specific feature, a dedicated server… Read more
Pnnn: Parallel Query Execution Servers-Oracle Processes
Parallel query is the capability to take a SQL statement such as a SELECT, CREATE TABLE, CREATE INDEX, UPDATE, and… Read more
Reduces the Memory Needed on the System- Oracle Processes
This is one of the most highly touted reasons for using a shared server: it reduces the amount of required… Read more
Background Processes- Oracle Processes
The Oracle instance is made up of two things: the SGA and a set of background processes. The background processes… Read more
SMON: The System Monitor- Oracle Processes
SMON is the process that gets to do all of the system-level jobs. Whereas PMON was interested in individual processes,… Read more
RECO: Distributed Database Recovery- Oracle Processes
RECO has a very focused job: it recovers transactions that are left in a prepared state because of a crash… Read more