Oracle Applications Performance Tuning Handbook (Book/CD-ROM package)

( 2 )

Overview

This Oracle-authorized handbook explains how to tune Oracle applications systems for maximum efficiency. Written by a Senior Principal of the Oracle Applications Performance Group,the book offers the latest expert techniques and covers Oracle Applications Smart Client through Release 11i.

Maximize the Performance of Your Oracle Applications System.

Troubleshoot and tune Oracle Applications Smart Client and Internet computing environments. ...

See more details below
This Paperback (BK&CD-ROM) is Not Available through BN.com
Note: This is a bargain book and quantities are limited. Bargain books are new but may have slight markings from the publisher and/or stickers showing their discounted price. More about bargain books
Sending request ...

Overview

This Oracle-authorized handbook explains how to tune Oracle applications systems for maximum efficiency. Written by a Senior Principal of the Oracle Applications Performance Group,the book offers the latest expert techniques and covers Oracle Applications Smart Client through Release 11i.

Maximize the Performance of Your Oracle Applications System.

Troubleshoot and tune Oracle Applications Smart Client and Internet computing environments. Officially authorized by Oracle Corporation,Oracle Applications Performance Tuning Handbook provides a systematic approach to resolving complex system-wide performance issues. Learn how to preempt serious problems as well as increase system capacity,improve scalability,and extend the life of existing system components. Written by an expert Oracle insider,this book explains a comprehensive,end-to-end tuning approach that encompasses the complete system,including the client,applications,network,database,and servers. Real-world case studies and a CD-ROM containing a Tuning Toolkit are also included.

  • Understand system architecture and performance issues

  • Identify system problems and bottlenecks

  • Resolve performance issues using tuning methodologies

  • Tune the client — Windows 95/98 and Windows NT/2000

  • Tune the database,server,middle tier,and network

  • Handle user,concurrent processing,and Workflow tuning

  • Understand SQL tuning and how to transition to Oracle8i and Oracle Applications Release 11i

The bonus CD-ROM includes a Tuning Toolkit featuring PC and networking utilities and Oracle Support white papers.

Read More Show Less

Product Details

  • ISBN-13: 9781402893742
  • Publisher: McGraw-Hill Companies, The
  • Publication date: 9/19/2000
  • Series: Oracle Press Series
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 908
  • Product dimensions: 7.34 (w) x 9.13 (h) x 2.12 (d)

Read an Excerpt

Chapter 1: The Performance Methodology

Oracle Applications systems typically consist of a number of highly integrated and interdependent modules that can be implemented in a number of ways, sometimes making the resulting system appear quite complex. The modules are rarely static, and no two systems are ever alike. No matter how meticulous your proactive capacity planning has been, at some point during the system life cycle you should expect to encounter an emergency reactive performance problem. When faced with a performance challenge or, worse still, when facing many system problems, it is sometimes very difficult to know how and where to start, and perhaps more importantly, how to identify the resources you need to fix the problems. This chapter will help you to address these issues. 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 chapter 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.

TIP To see an example of the questions used in this approach, review the questions in Form 1-1 at the end of Chapter 4. (The dark edging on all Form pages makesthem easy to locate throughout this book.)

The methodology described here evaluates all of the interacting components by considering the system in its entirety, or "holistically." Other methodologies such as Kepner Tregoe and several proposed by the University of Maryland also use some of the same techniques but necessarily adopt a more generic approach. This holistic methodology integrates some of the best features from other techniques while maintaining the common approach of using five problem definition stages: What, Where, When, Extent, and Priority. Which approach you decide to use is a matter of personal choice. If you already use an approach or have a strategy with which you are more familiar, you may find it useful to modify or incorporate stages from this chapter. This methodology documents an approach based on real-world experience that has evolved from numerous performance engagements working on fundamentally disparate problems. It has repeatedly proven to reduce the effort and expense of locating and identifying system problems. A great deal of time has been expended

on maintaining the speed and simplicity of the approach, while ensuring it remains accurate and sufficiently comprehensive to identify the most complex Oracle Applications issues. Not only does it formalize the problem definition process, but it also enables you to correlate the subsidiary effects and possible consequences of poor performance from other areas.

Why Use This Methodology?

Throwing resources at a performance problem is rarely helpful. It can lead to contention between the parties, with you in the middle trying to mediate. If one of the on-site experts tells you that there are no problems in their area, applying this methodology can provide a definitive insight.

TIP It is essential to always draw your own conclusions, based on the facts and without bias.

Two strategies are commonly used when faced with a performance problem. One is to engage a database tuning expert, who has specialized skills and an understanding of the Oracle tuning tools. The other is to throw hardware at the problem. Neither of these options provides a long-term solution; they only address the symptoms, not the causes. There is a lot that you can do to locate and identify system problems. The value of the method described in this chapter is that while you may need an expert in a particular technology stack to resolve a problem, you do not need to be an expert to identify where the problem is in the system. Your goal is to narrow the scope of the investigation as quickly and cost-effectively as possible, enabling early identification of the correct resources. This will not only save you days or possibly weeks of sub-optimal performance; it can also avoid the significant costs associated with extending the working day or having to change the business practices in an attempt to address the shortfall.

Do You Need to Be an Expert?

Being an expert in every technology stack would be very beneficial. However, it is highly unlikely; you may need expert assistance to resolve a problem...

Read More Show Less

Table of Contents

Chapter 1: History of Applications/Enterprise Resource Planning.
Chapter 2: Architecture and Concepts.
Chapter 3: Enterprise Resource Planning.
Chapter 4: The Performance Methodology in Outline.
Chapter 5: Performance Troubleshooting.
Chapter 6: Stack Definitions in Detail.
Chapter 7: Client Stack.
Chapter 8: Database Stack.
Chapter 9: Server Stack.
Chapter 10: Unix Stack.
Chapter 11: NT Stack.
Chapter 12: Network Stack.
Chapter 13: Web Server Stack.
Chapter 14: Forms/Metrics Server Stack.
Chapter 15: Applications Stack - Forms.
Chapter 16: Applications Stack - Concurrent Processing.
Chapter 17: Applications Stack - SQL Tuning.
Chapter 18: Transitioning to Release 11i.
Appendices:
A: Customer Questionnaire.
B: Debugging.
C: Web Sites.
Read More Show Less

Customer Reviews

Average Rating 2.5
( 2 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(1)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted July 30, 2001

    A book I often refer.....

    This book opened up some topics which were seldom/rarely discussed in other manuals and documentation.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted October 5, 2000

    Very basic titles or areas covered

    The books is very basic and deals more with the client machine issues rather than the server side and is more NT oriented compared to the more Unix based implementations available in the market. Even those details are not covered in detail. This is not worth the money.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)