Oracle

1. Database server = Instance (Processes + Memory) + Files (Database)

2. Single Instance Database = 1 Instance – 1 Database

3. RAC = Multi instance – 1 Database

4. On client access, listener creates dedicated server process which then accesses the database. Dispatcher pushes SQL in SQL queue, instead of creating individual server process for each client.

5. Data files:

>> Table Space is associated with .dbf files. One Table Space may be associated with several .dbf files.

>> Table space > Segments > Extents > Blocks (Header, table info, row info, data)

6. Processes:

>> Server processes: represent client.

>> Background processes: processes running sinceĀ server start (DBWriter)

>> Slave processes: work for either server or BG processes

7. Partitions: Range partitions, hash partitions, list partitions, sub partitions (e.g. range+hash)

Advertisements

Leave a comment

Filed under Uncategorized

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 )

Google photo

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

Connecting to %s