vee’s notes

this is about everything

Sekilas tentang Oracle May 7, 2009

Filed under: oracle — veeolina @ 1:37 pm

1. Sebuah oracle database server terdiri dari sebuah oracle instance dan sebuah oracle database.
2. Sebuah oracle instance terdiri dari background process dan allocated memory (SGA dan PGA)
3. Background process terdiri dari:

* Database Writer Process (DBWn)
* Log Writer Process (LGWR)
* Checkpoint Process (CKPT)
* System Monitor Process (SMON)
* Process Monitor Process (PMON)
* Recoverer Process (RECO)
* Archiver Processes (ARCn)

4. Sebuah oracle database terdiri dari:  datafile, control file, redo log file, archive log file, parameter file.
5. Untuk dapat mengakses oracle database, diperlukan proses yang disebut oracle listener


Leave a Reply

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

You are commenting using your 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