Blog Post

SQL Server Essentials for Oracle DBAs: (03a) Instance Architecture Part 1

Download this episode

Download Video

Download captions

Description

Module 3 discusses the memory and process architectures that are key to a database's performance. The module goes into the details of the hierarchy of memory areas of an instance and its configuration. This module also describes how the various functions of the RDBMS are accomplished by the different processes running in the background. Finally, in this module, we look at the changes Oracle has made in its internal architecture on Microsoft Windows platform between 9i and 11g to exploit the advantages offered by the operating system mechanisms and how they compare to SQL Server's implementation.

  • [07:15] - Memory Architecture
  • [16:30] - Memory Address Space - Comparison
  • [22:23] - Monitoring memory usage
  • [29:48] - Process and Thread-Based architecture

Full course outline:

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.