ITPub博客

首页 > 数据库 > Oracle > oracle工作机制导图

oracle工作机制导图

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

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

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


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

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
           
            ------------>>
           

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29119536/viewspace-1151304/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-08-15

  • 博文量
    595
  • 访问量
    4988622