Oracle 10g architecture diagram:

____________________________________________________________________________________________


Here is a brief explanation of architecture:


Oracle Server architecture
|
|
|– Oracle Instance (SGA + Background Process)
|    |
|    |– SGA (System Global Area)
|    |    |
|    |    |– Database buffer cache
|    |    |– Shared pool
|    |    |– Redolog buffer
|    |    |– Large pool
|    |    |– Java pool
|    |      |– Streams pool
|    |
|    |– Background process
|        |
|        |
|        |– SMON
|        |– PMON
|        |– CKPT
|        |– DBWn
|        |– LGWn
|        |– ArCn
|        |– MMAN
|        |– MMON
|        |– RECO
|        |– CJQn
|
|
|– Oracle Database (Physical file structure)
|    |
|    |– Control files
|    |– Redolog files
|    |– Data files
|
|
|– Others
|
|– init file
|– pwd file
|– archive log file


Here is a detailed diagram for Oracle 10g Release 2 Architecture:

Here is a brief explanation of architecture:

Oracle Server architecture

– Oracle Instance (SGA + Background Process)

– SGA (System Global Area)

– Database buffer cache
– Shared pool
– Redolog buffer
– Large pool
– Java pool

– Background process

– SMON
– PMON
– CKPT
– DBWn
– LGWn
– ArCn

– Oracle Database (Physical file structure)

– Control files
– Redolog files
– Data files

– Others

– init file
– pwd file
– archive log file

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: