Oracle Architecture Part 1

No Comments

[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=&notes=” 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 – Data, Index, Rolback, Temp
  • In Oracle you can now have around 65000 datafiles

Important views for the DBA

  • dba_data_files
  • v$dbfile
  • v$datafile

Control files.

Should have 3 identical control files on different disks and controllers

They contain information about the database

  • db name
  • created date
  • path to data files
  • check point info

Important Views

  • v$controlfile

Watch Part 2…

Leave a Reply

Your email address will not be published. Required fields are marked *