Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 3: Understanding the working of Oracle Instance
Oracle Server can be configured to run under Shared Server mode or as
Dedicated Server mode. Figure 6 shows Oracle Instance working under
Shared Server configuration. The beauty of shared server configuration
is that a single server process handles multiple sessions and hence the
idle time of server process reduces.
LGWR (Log Writer Process), PMON (Process Monitor), SMON (System Monitor), ARCn (Archiver Process) etc. are all Oracle background processes and SGA in the center is the memory architecture of Oracle Instance. So all these background process utilize the memory architecture (shared area) to fulfill requests of all the connected users.
Figure 6: Oracle Instance background processes; shared
server mode.
________________________________________
Chapter 3: Understanding the working of Oracle Instance
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning