oracle工作機制導圖

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

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

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


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

shows a and background processes using dedicated server connections. For each user connection, the application is run by a 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 .

Figure 15-1 Oracle Processes and the SGA

         

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

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

相關文章