Oracle 10g Performance on Windows Server 2008 Hyper-V Virutal Machine by Gary Parker
“Windows Server is one of the top platforms for Oracle databases. With Windows Server 2008, everything needed to support database server virtualization is available as an integral part of the operating system. This whitepaper demonstrates the performance capabilities of Oracle 10g on Hyper-V. It also highlights several best practices and resources essential to virtualization of Oracle database workloads.
Advantages of Running Oracle11g on Microsoft Windows Server x64 by Edward Whalen
Whitepaper presented at Collaborate 2008.This paper highlights some of the advantages of running Oracle on the Windows 64-bit operating system. In addition, it addresses some of the basic issues and factors to consider when choosing to deploy a new operating system, such as Windows.
Enabling the Maximum Availability Architecture on Linux by Edward Whalen
Whitepaper presented at Collaborate 2008. This paper explores how the MAA can be used to provide protection in a number of disaster scenarios.
Performance Tuning Oracle RAC on Linux by Edward Whalen
Whitepaper presented at Collaborate 2008. This paper explores the Oracle architecure, the troubleshooting tools and methodologies used to tune Oracle and the Linux operating system.
Oracle Recovery Manager (RMAN) and RAC by Edward Whalen
Presentation for Oracle IOUG RAC Attack 2008. This presentation discusses RMAN's application in backing up Oracle RAC databases.
Troubleshooting and Tuning: Oracle RAC on Linux by Edward Whalen
Presentation given at Oracle OpenWorld 2006. This presentation covers the aspects of performance tuning and its application to the Linux operating system and storage.
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.