A brief discussion on Oracle ASM and some of its advantages over other file systems. Notes: Database centric file system only used for managing database files High performance Requires a certain amount of tuning Not suitable for all applications Current recommendation is to allow ASM handle raid mirroring rather than let hardware handle it Probably …
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 – …
Notes: Data appliance Server with preinstalled and pre optimised database Hardware designed to work with the database software specifically Pre configured clustered database server Exalogic is a preconfigured clustered application server Exadata is a pre configured clustered database server There are other products but they are targeted at OLAP specifically (read rather than write) Exadata supports OLTP and OLAP The first …
This is a pretty cheesy presentation but it gets some interesting points about exadata and smart scan over in only 3 minutes. Notes: Exadata offloads work to its storage servers which reduces the data that needs to travel over the network to the database servers. For example, the storage servers filter out rows that are …
This is a great discussion on and around Oracle Exadata by 2 performance tuning experts. Notes: A very relaxed presentation on the ins and outs of Exadata from a performance tuning and optimization perspective.Skip to about 10 mins in to get past the introductions.Exadata isn’t a solution to all performance problems. You can …
Great webinar on Oracle 12c plugable databases. Skip to 8 minutes for the start of the actual presentation.
[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/nNGLyWIPPTQ?fs=1″ vars=”ytid=nNGLyWIPPTQ&width=584&height=328&start=&stop=&rs=w&hd=0&autoplay=0&react=1&chapters=¬es=” id=”ep8443″ /] Watch the earlier parts first: Part 1 Part 2 Part 3 Notes: Oracle Processes Dbwr Database Writer Writes from the SGA to the data files Does deffered writes like a hotel room clerk kicks blocks out to disk when new data needs free blocks Lgwr Log …
[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 …
[embedplusvideo height=”328″ width=”584″ standard=”http://www.youtube.com/v/addFo5FMzkg?fs=1″ vars=”ytid=addFo5FMzkg&width=584&height=328&start=&stop=&rs=w&hd=0&autoplay=0&react=1&chapters=¬es=” id=”ep3446″ /] There are 3 essential elements of any database system Datafiles – storage Memory – in oracle its the SGA Processes – To operate on the data files and memory Storage Datafiles Contains data Tables Indexes Undo segments (used to be rollback segments) Temporary files Oracle is easy as DIRT …