If you are having trouble getting your head around the basics of Oracles Architecture, this video does a good job of simplifying things and making it easy to remember by breaking it down and describing it via everyday examples. You can skip to around 2:30 for the real start of the video. Notes; Datafiles – …
[embedplusvideo height=”356″ width=”584″ standard=”http://www.youtube.com/v/L_2TfSHotsY?fs=1″ vars=”ytid=L_2TfSHotsY&width=584&height=356&start=&stop=&rs=w&hd=0&autoplay=0&react=1&chapters=¬es=” id=”ep6822″ /] Watch the rest of this series: Part 1 Part 2 Part 4 Notes: Initilisation params for the Buffer cache: db_cache_size db_block_size It is very helpfull if the buffer block size is a multiple of your operating system block size. The Buffer cache is controled with a Least Recently Used …
[embedplusvideo height=”328″ width=”584″ standard=”http://www.youtube.com/v/wmc9uxNW99E?fs=1″ vars=”ytid=wmc9uxNW99E&width=584&height=328&start=&stop=&rs=w&hd=0&autoplay=0&react=1&chapters=¬es=” id=”ep5503″ /] Check out part 1 first. Notes: Online Redo Logs Contains Redo and Undo info DML Inserts/Deletes DDL – Create alter drop Commits Need at least 2 files/groups Should be multiplexed each on different devices and controlers When each file fils, next one is started and old one is archived (if …
The Users server process is the process that handles the users requests to the oracle database. When the user requests a add, update or delete of data in the database, the server process modifies the data from the buffer cache, not the actual data files. The DBWR (Database Writer) process is the only process that …
Reading from the Oracle RDMS is done by the users server process Once a query is submitted, the users server process first determines if data is in the buffer cache of the SGA (System Global Area) memory area. If the data is not already in the buffer cache, Oracle reads the data from the data …