U Make it Easy as 1,2,3,4

1 Think, 2 Do, 3 Words, 4 You….. I am Happy

Oracle Database Architecture March 24, 2009

Filed under: Oracle10g — Princess Frog @_@ @ 6:24 AM

Kata database dalam frasa “arsitektur database Oracle” seharusnya adalah Database Management System (DBMS). Untuk penyederhanaan penyebutan, Database Management System memang sering cukup disebut database saja.

Secara umum komponen DBMS Oracle terdiri atas memory, proses, dan file-file. Lebih jauh lagi, komponen-komponen tersebut dikelompokkan sebagai berikut:

1. Instance
– Memory yang disebut sebagai System Global Area (SGA), terdiri atas: Shared Pool (Libary Cache and Data Dictionary Cache), Database Buffer Cache, Redolog Buffer Cache, Java Pool, Large Pool.
– Back ground process: PMON, SMON, DBWR, LGWR, CKPT, dan lain-lain
2. Database
– Datafile
– Control file
– Redo log file
3. Komponen lain
– process: Server Process, user process
– memory: Program Global Area (PGA)
– File: Archived log, parameter, dan password file

 

4 Responses to “Oracle Database Architecture”

  1. jefri Says:

    datapum di oracle 10g tu apa kak……
    da tugas ny di kelas……


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