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
Figure 7 shows the same thing as the previous one but here you might have noticed that we have less number of blocks, especially there is no Dispatcher process and no Request and Response Queue. This is because; here we are showing Oracle working in Dedicated Server mode.
In dedicated server mode, each connected user is entertained by a separate server process. Although this configuration would be having high idle server time as most of the time Server process would be doing nothing and waiting for next SQL statement to arrive. This configuration has high performance factor but it should only be utilized when you have plenty of system resources available.
Figure 7: Oracle Instance background processes;
dedicated 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
Share with others: