Great webinar on Oracle 12c plugable databases.
Skip to 8 minutes for the start of the actual presentation.
Data, the Cloud and other thoughts.
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:
Notes:
Initilisation params for the Buffer cache:
The Buffer cache is controled with a Least Recently Used (LRU) algorithm which determines what stays in and what gets removed from the SGA.
The goal being to have the data that is accesses most frequently kept in the SGA so that it can be accessed fast.
The purpose of the Shared pool is to reduce parsing
The Shared pool consists of 2 parts:
The Shared Pool also usesa LRU algorithm.
Initialization parameter – shared_pool_size controls size of shared pool.
Watch Part 4
[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:
Notes:
Dbwr
Database Writer
Lgwr
Log Writer
Smon
System monitor
Pmon
Process monitor
Ckpt
Checkpoint process
one big reason for checkpoints is that commonly accessed
data may never get written out to disk. A checkpoint forces
this to get written.
– is the SGA and background processes
Oracle database and the Oracle instance combined is called the Oracle Server.
You can have multiple instances associated with the same database, this is called RAC.
Dedicated server process connects through the PGA.
[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″ /]
Notes:
An Oracle database is comprised of datafiles, control files
and redo logs.
The second part is the memory – the SGA (system global area
or shared global memory)
Comprised of Oracle data blocks
There are 4 main types of data blocks, which are the same as the 4 types of data mentioned earlier:
[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
Important views for the DBA
Should have 3 identical control files on different disks and controllers
They contain information about the database
Important Views