oracle工作機制導圖

dawn009發表於2014-04-29
Oracle
   誠然，oracle大部分機制原理用圖解方式進行理解學習，其效率比單純文字高很多，下面將小編認為重要值得收藏的oracle工作導圖羅列出來，希望對各位學友有所幫助:
  (1)oracle監聽器:
      
(2)Oracle聯機日誌組的設定:

  儘量多個group,每個group中至少兩個member,而且disk1和disk2分別放置聯機日誌組的相關成員

 
(3)oracle歸檔程式設定:
 
(4)oracle DBA系統和session級別管理重要檢視：
 
  ----&gt>
 
(5)share pool component and its functions:
 


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

         

-------------------------&gt>checkpoint in instance recovery
           
            ------------&gt>
           

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29119536/viewspace-1151304/，如需轉載，請註明出處，否則將追究法律責任。

相關文章