Enterprise DBA Part 2: Performance and Tuning

The Database Resource Manager enables the database administrator to have morecontrol over resource management than would typically be possible through operatingsystem resource management alone. Using this facility, the database administrator can: Guarantee certain users or groups of users a minimum amount of processingresources regardless of the load on the system and the number of users
Nội dung trích xuất từ tài liệu:
Enterprise DBA Part 2: Performance and Tuning Enterprise DBA Part 2: Performance and Tuning Volume 2 • Student Guide .......................................................................................30052GC10Production 1.0September 1999M09214Author Copyright © Oracle Corporation, 1999. All rights reserved.Dominique Jeunot This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software isTechnical Contributors prohibited. If this documentation is delivered to a U.S. Government Agency of theand Reviewers Department of Defense, then it is delivered with Restricted Rights and theBruce Ernst following legend is applicable:Richard Foote Restricted Rights Legend Use, duplication or disclosure by the Government is subject to restrictions forAntonio Florindo commercial computer software and shall be deemed to be Restricted RightsSteven George software under Federal law, as set forth in subparagraph (c) (1) (ii) of DFARS 252.227-7013, Rights in Technical Data and Computer Software (October 1988).Joel Goodman This material or any portion of it may not be copied in any form or by any means without the express prior written permission of Oracle Corporation. Any otherScott Gossett copying is a violation of copyright law and may result in civil and/or criminalLex de Haan penalties. If this documentation is delivered to a U.S. Government Agency not within theDonna Hamby Department of Defense, then it is delivered with “Restricted Rights,” as defined in FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987).Scott Heisey The information in this document is subject to change without notice. If you findJohn Hough Jr. any problems in the documentation, please report them in writing to Education Products, Oracle Corporation, 500 Oracle Parkway, Box SB-6, Redwood Shores,Peter Kilpatrick CA 94065. Oracle Corporation does not warrant that this document is error-free.Kurt Lysy Oracle is a registered trademark and Oracle and all Oracle products are trademarks or registered trademarks of Oracle Corporation.Michael Moller All other products or company names are used for identification purposes onlyHoward Ostrow and may be trademarks of their respective owners.Thomas RaesShankar RamanS. RooUlrike SchwinnRoger SimonAnthony WoodellPublisherKelly Lee Contents.....................................................................................................................................................Lesson 1: Course Introduction Objectives 1-2Lesson 2: Tuning Overview Objectives 2-2 System Tuning Overview 2-3 Tuning Goals 2-5 Tuning Steps 2-7 Summary 2-8Lesson 3: Oracle Alert and Trace Files Objectives 3-2 Diagnostic Information 3-3 The Alert Log File 3-4 Controlling the Alert Log File 3-7 Controlling the Background Processes Trace Files 3-8 User Trace Files 3-11 Controlling the User Trace Files 3-12 Summary 3-14 Quick Reference 3-15Lesson 4: Utilities and Dynamic Performance Views Objectives 4-2 Views, Utilities, and Tools 4-3 Dictionary and Special Views 4-5 Dynamic Troubleshooting and Performance Views 4-6 Topics for Troubleshooting and Tuning 4-7 Collecting System-Wide Statistics 4-9 Collecting Session-Related Statistics 4-11 UTLBSTAT and UTLESTAT Utilities 4-14 Examining the Statistics Report 4-17 Library Cache Statistics Section 4-21 I/O Statistics Section 4-22 Latches 4-23.....................................................................................................................................................Enterprise DBA Part 2: Performance Tuning Workshop iiiContents..................................................................................................................................................... Latch Types 4-25 Oracle Wait Events 4-26 Statistics Event Views 4-29 Event Management ...