Sunday, 7 April 2013

Oracle Architecture


Oracle-Architecture

Oracle architecture -let's discuss about basics of oracle architecture
                                 Oracle architecture divides into mainly 3 parts
                                               1.Memory
                                               2.Process
                                               3.Storage
Components of Memory : SGA - It contains -1. Shared pool
                                                                         2.Database buffer cache
                                                                         3.Redolog buffer cache
                                                                         4.Java pool
                                                                         5.Large pool
                                                                         6.Stream pool 
Background Process :  It contains                   1.SMON
                                                                         2.PMON
                                                                         3.DBWR
                                                                         4.LGWR
                                                                         5.Arcn.
Storage: There are tow types of storages physical and logical
               Physical Storage :Contains Control file,Data file & Redo file
               Logical Storage : Contains Table spaces and data files.

                                                               

No comments:

Post a Comment