• Troubleshooting and Tuning: Oracle RAC on Linux   by Edward Whalen 
  Presentation given at Oracle OpenWorld 2006.
  
  
• Comparison of the Oracle Database Server on Microsoft Windows Server 2003 and on Redhat Linux   by Larry Pedigo 
  The focus of this paper is to compare the Oracle Database Server on Microsoft Windows Server 2003 and the Oracle Database Server on Rehat Linux. Both systems utilized x64 technology.
  
  
• Comparison of 34-bit and 64-bit Oracle Database Performance on the Dell PowerEdge 6850 Server with Microsoft Windows Server 2003  by Larry Pedigo 
  The focus of this paper is comparing the performance of Oracle databases on 32-bit Microsoft Windows Server 2003 and 64-bit Oracle databases on the Microsoft Windows Server 2003 version for the EM64T processor.
  
  
• Deployment Guide: Oracle on Microsoft Windows and the Dell PowerEdge 6850 Server by Bryan Thomas and Larry Pedigo
  This paper identifies issues involved in configuring Oracle RAC on Windows with Dell hardware and provides a template for successful implementations.  Topics covered include installing the Operating System for Oracle, configuring the Cluster hardware, installing Oracle software, creating the RAC database, and post-installation tasks.
  
  
• Overview of I/O Performance and RAID in an RDBMS Environment by Edward Whalen
  This paper covers the fundamentals of I/O topics and an overview of RAID levels commonly found in an RDBMS environment.  This paper covers both the performance and fault tolerant properties of those RAID levels.
  
  
• Tuning Oracle and RAC on Linux (excerpt) Tuning Oracle is as much an art as it is a science. Tuning involves scientific investigation, good note taking, intuition and experience in order to determine if there is a performance problem, what that performance problem is, and how to solve it. Performance tuning is made easier by developing and sticking with a disciplined methodology.
  
  
• Configuring, Tuning, and Using Oracle9i in a Red Hat Linux Environment by Edward Whalen
  Tips on critical steps that must be taken when installing Linux to ensure the successful configuration of Oracle9i, including useful tuning suggestions and monitoring techniques.
  
  
• Oracle 9i I/O Configuration in a SAN/NAS Environment by Edward Whalen
  Some of the most common Oracle performance problems involve the I/O subsystem. Since Oracle’s main function is to manipulate data, and that data resides either in memory or on the I/O subsystem, any I/O performance problems will result in Oracle performance problems. Much of the design of the Oracle RDBMS is intended to make accessing the I/O subsystem as efficient as possible.
  
  
• Configuration and Installation of Oracle Fail-Safe on Windows 2000 by Edward Whalen
  This paper is designed as a beginner’s course for those interested in setting up Oracle Fail Safe in a Windows 2000 environment.
  
  
• Oracle 10g on Linux Cluster by Bryan Thomas  
  High Availability (HA) is in high demand today. Corporations lose thousands if not millions of dollars every time there is an outage of their IT systems. This white paper will cover the basic steps for creating a Linux Cluster. Specifically, it will cover installing Oracle 10g on a Linux Cluster in active/passive mode utilizing the Red Hat Cluster Manager.
  

• Survey of Popular Clustering Technologies by Edward Whalen
  
  Clustering has become quite popular and there are a number of different products that use the term clustering that act and perform differently. This paper explains the different technologies and terminologies that are used to form clusters.
  

• Performance Implications of Various Cursor Types in MS SQL Server by Edward Whalen
  By choosing the most efficient cursor type for MS SQL Server 2000, you can not only speed up the application, but you can conserve valuable system resources as well. In this paper, the various cursor types are discussed and their performance implications detailed.
  
  
• SQL Server 2000 I/O Configuration in a SAN/NAS Environment by Edward Whalen
  Since SQL Server’s main function is to manipulate data, and that data resides either in memory or on the I/O subsystem, any I/O performance problems will result in SQL Server performance problems.
  
  
• SQL Server Execution Plan Cost Formulas Joe Chang presents why SQL Server uses a given execution plan for a specific query: the cost model and statistics; when the execution plan changes; and performance testing: how to get the same results in test as in actual use, and size and cardinality.
  
  

top