1. Process
1.1. client (run app/tool code)
1.1.1. Pro*C Program
1.1.2. SQL* Plus
1.2. oracle (run database code)
1.2.1. background
1.2.1.1. perform maintenance task
1.2.1.1.1. instance recovey
1.2.1.1.2. cleaning up
1.2.1.1.3. writing redo buffers
1.2.2. server
1.2.2.1. upon client request
1.3. Oracle Server
1.3.1. Oracle Database
1.3.1.1. Database Files
1.3.1.1.1. Store Database Information
1.3.1.1.2. Organize need in order to operate
1.3.1.2. Redo Log Files
1.3.1.2.1. Recover Database
1.3.1.3. Archived redo log files
1.3.1.3.1. recover database
1.3.1.3.2. disk fails
1.3.1.4. parameter files
1.3.1.4.1. specify parameter
1.3.1.5. password files
1.3.1.5.1. optional
1.3.1.5.2. authenticate special user of database
1.3.1.6. alert
1.3.1.6.1. Trace log files
1.3.2. Oracle Instance
1.3.2.1. Process Monitor Process (PMON)
1.3.2.1.1. cleaning up database buffer cache
1.3.2.1.2. freeing resource that client used
1.3.2.2. System Monitor Process (SMON)
1.3.2.2.1. performing instance recovery
1.3.2.2.2. recovery terminated transactions
1.3.2.3. Database Writer Process (DBWn)
1.3.2.3.1. writes content of database buffer to data files
1.3.2.4. Achiever Processes (ARCn)
1.3.2.4.1. copy online redo log buffer
2. Memory
2.1. Basic Memory Structures
2.1.1. System Global Area (SGA)
2.1.1.1. Database Buffer Code
2.1.1.1.1. used
2.1.1.1.2. clean
2.1.1.1.3. dirty
2.1.1.2. Shared Pool
2.1.1.2.1. Library Cache
2.1.1.2.2. Data Dictionary Cache
2.1.2. Program Global Area (PGA)
2.1.2.1. exclusively for use by an Oracle process
2.1.2.1.1. contain data
2.1.2.1.2. control information
2.1.3. User Global Area