oracle工作机制导图

   诚然,oracle大部分机制原理用图解方式进行理解学习,其效率比单纯文字高很多,下面将小编认为重要值得收藏的oracle工作导图罗列出来,希望对各位学友有所帮助:
  (1)oracle监听器:
      
(2)Oracle联机日志组的设置:

  尽量多个group,每个group中至少两个member,而且disk1disk2分别放置联机日志组的相关成员

 
(3)oracle归档进程设置:
 
(4)oracle DBA系统和session级别管理重要视图:
 
  ---->>
 
(5)share pool component and its functions:
 


-------->>shows the main components of an Oracle database instance.
            
            

Figure 15-1 shows a system global area (SGA) and background processes using dedicated server connections. For each user connection, the application is run by a client process that is different from the dedicated server process that runs the database code. Each client process is associated with its own server process, which has its own program global area (PGA).

Figure 15-1 Oracle Processes and the SGA

         

------------------------->>checkpoint in instance recovery
           
            ------------>>
           

请使用浏览器的分享功能分享到微信等