A Holistic Approach To Performance Tuning Oracle Applications Systems Release 11 and 11i.pdf

盖国强

381

84页

2次

2021-02-01

5墨值下载

A Holistic Approach To

Performance Tuning Oracle

Applicatio n s Systems Release 11

and 11i

An Oracle White Paper

November 2001

A Holistic Approach To Performance Tuning Oracle Applications Systems Release 11 and 11i Page 2

Executive Overview

A number of problem definition methods, decision support systems, continuous

improvement techniques, and other methodologies can be usefully employed for

troubleshooting Oracle-based systems. However, many of these approaches are

necessarily abstract and very generic. They can be so complex that they require

specialist problem-solving skills, making their deployment almost as difficult as

solving the problem they are endeavoring to identify. This paper describes a

proven methodology specifically designed to identify and analyze complex and

multifaceted Oracle Applications issues. Although this approach is primarily

intended for use with Oracle Applications, it can also be used to identify problems

with other Oracle-based systems. This paper should be useful to the whole user

community, from end-users and system administrators to the CIO.

The approach to performance tuning Oracle Applications has changed significantly

over the past year. Those familiar with the previous paper will recognize that many

sections have been reviewed and updated. The biggest updates and changes

include the following:

Desktop PC There has been a fundamental shift in PC requirements, from

memory in Smart Client to CPU in internet computing. At the same time, CPU

speeds have increased significantly. This has fundamentally changed the way you

need to tune the client. The benchmarks in this section have also been updated

and include Windows XP.

Database Statspack replaces the traditional BSTAT/ESTAT report and is now

the preferred analysis and tuning tool. Although it was introduced with Oracle

8.1.6, it is also available for earlier versions though some restrictions apply.

SQL This has been updated with the latest Applications information and

contains some very important information that everyone should be aware of.

Networking Oracle Applications network traffic has considerably reduced since

the introduction of the internet computing architecture. However, changes in

other technologies such as emails with large attachments, audio and video

streaming, all mean that many companies are still seeing bandwidth requirements

increasing. This section describes Quality of Service (QoS) and Packet Shaping, which

are techniques that can help you to restore and maintain service levels for your

mission critical applications without needing to upgrade expensive Wide Area

Network (WAN) links.

Concurrent Processing This section introduces several enhancements such as

automatically moving files to secure areas, printing PostScript under UNIX,

archiving, and many other features. Rather than include all the details in this paper,

you are referred to white paper (164085.1 written by Andy Tremayne) that

provides you with a myriad of functional enhancements.

of 84

5墨值下载

oracle 性能优化

关注

评论