Troubleshooting Oracle Performance


Author: Christian Antognini
Publisher: Apress
ISBN: 1430257598
Category: Computers
Page: 740
View: 5176

Continue Reading →

Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. Christian Antognini brings a decade and a half experience to his topic. His first edition is one of the most well-respected books in its field. This second edition has been rigorously updated to cover the latest developments in Oracle Database 11g Release 2 through Oracle Database 12c. What do you do when your database application isn’t running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It’s finding a solution that’s difficult. Troubleshooting Oracle Performance, 2nd Edition helps by providing a systematic approach to addressing the underlying causes of poor database application performance. The author freely shares his experience while explaining the underlying foundations of how SQL statements are executed by the Oracle database engine. You'll be able to draw a solid foundation of theory and shared experience as you face head-on the performance challenges in your daily work. Written for developers by an application developer who has learned by doing Gives a systematic approach to solving database application performance problems Helps you plan for performance as you would for any other application requirement

Oracle Performance Troubleshooting

With Dictionary Internals SQL & Tuning Scripts
Author: Robin Schumacher
Publisher: Rampant TechPress
ISBN: 9780972751346
Category: Computers
Page: 254
View: 2606

Continue Reading →

Provides information on how to quickly troubleshoot Oracle performance problems, covering such topics as designing databases, storage and reorganization, memory usage, and SQL.

Oracle Database 11g Performance Tuning Recipes

A Problem-Solution Approach
Author: Sam Alapati,Darl Kuhn,Bill Padfield
Publisher: Apress
ISBN: 1430236620
Category: Computers
Page: 592
View: 9555

Continue Reading →

Performance problems are rarely "problems" per se. They are more often "crises" during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 11g Performance Tuning Recipes delivers. Oracle Database 11g Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book. Provides proven solutions to real-life Oracle performance problems Offers relevant background and theory to support each solution Written by a team of experienced database administrators successful in their careers What you’ll learn Optimize the use of memory and storage Monitor performance and troubleshoot problems Identify and improve poorly-performing SQL statements Adjust the most important optimizer parameters to your advantage Create indexes that get used and make a positive impact upon performance Automate and stabilize using key features such as SQL Tuning Advisor and SQL Plan Baselines Who this book is for Oracle Database 11g Performance Tuning Recipes is aimed squarely at Oracle Database administrators. The book especially appeals to those administrators desiring to have at their side a ready-to-go set of solutions to common database performance problems. Table of Contents Optimizing Table Performance Choosing and Optimizing Indexes Optimizing Instance Memory Monitoring System Performance Minimizing System Contention Analyzing Operating System Performance Troubleshooting the Database Creating Efficient SQL Manually Tuning SQL Tracing SQL Execution Automated SQL Tuning Execution Plan Optimization and Cosistency Configuring the Optimizer Implementing Query Hints Executing SQL in Parallel

Oracle Database Performance and Scalability

A Quantitative Approach
Author: Henry H. Liu
Publisher: John Wiley & Sons
ISBN: 1118135512
Category: Computers
Page: 500
View: 1523

Continue Reading →

The innovative performance and scalability features with each newer edition of the Oracle database system can present challenges for users. This book teaches software developers and students how to effectively deal with Oracle performance and scalability issues throughout the entire life cycle of developing Oracle-based applications. Using real-world case studies to deliver key theories and concepts, the book introduces highly dependable and ready-to-apply performance and scalability optimization techniques, augmented with Top 10 Oracle Performance and Scalability Features as well as a supplementary support website.

Oracle Database Problem Solving and Troubleshooting Handbook


Author: Tariq Farooq,Mike Ault,Paulo Portugal,Mohamed Houri,Syed Jaffar Hussain,Jim Czuprynski,Guy Harrison
Publisher: Addison-Wesley Professional
ISBN: 0134429257
Category: Computers
Page: 512
View: 9737

Continue Reading →

An Expert Guide for Solving Complex Oracle Database Problems Oracle Database Problem Solving and Troubleshooting Handbook delivers comprehensive, practical, and up-to-date advice for running the Oracle Database reliably and efficiently in complex production environments. Seven leading Oracle experts have brought together an unmatched collection of proven solutions, hands-on examples, and step-by-step tips for Oracle Database 12c, 11g, and other recent versions of Oracle Database. Every solution is crafted to help experienced Oracle DBAs and DMAs understand and fix serious problems as rapidly as possible. The authors cover LOB segments, UNDO tablespaces, high GC buffer wait events, poor query response times, latch contention, indexing, XA distributed transactions, RMAN backup/recovery, and much more. They also offer in-depth coverage of a wide range of topics, including DDL optimization, VLDB tuning, database forensics, adaptive cursor sharing, data pumps, data migration, SSDs, indexes, and how to go about fixing Oracle RAC problems. Learn how to Choose the quickest path to solve high-impact problems Use modern best practices to make your day more efficient and predictable Construct your “Call 9-1-1 plan” for future database emergencies Proactively perform maintenance to improve your environment’s stability Save time with industry-standard tools and scripts Register your product at informit.com/register for convenient access to downloads, updates, and corrections as they become available.

Oracle Database 12c Performance Tuning Recipes

A Problem-Solution Approach
Author: Sam Alapati,Darl Kuhn,Bill Padfield
Publisher: Apress
ISBN: 1430261889
Category: Computers
Page: 636
View: 3982

Continue Reading →

Performance problems are rarely "problems" per se. They are more often "crises" during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 12c Performance Tuning Recipes delivers. Oracle Database 12c Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book. Provides proven solutions to real-life Oracle performance problems Offers relevant background and theory to support each solution Gets straight to the point for when you're under pressure for results

Der Oracle DBA

Handbuch für die Administration der Oracle Database 12c
Author: Mirko Hotzy,Andrea Held,Marek Adar,Christian Antognini,Ronny Egner,Markus Flechtner,Angelika Gallwitz,Stefan Oehrli,Daniel Steiger
Publisher: Carl Hanser Verlag GmbH Co KG
ISBN: 3446444203
Category: Computers
Page: 832
View: 700

Continue Reading →

Als Administrator der Oracle Database finden Sie in diesem Handbuch die ideale Unterstützung für die Herausforderungen Ihres Alltags. Hier hat sich eine Gruppe namhafter und praxiserfahrener Autoren zusammengetan, die gemeinsam 134 Jahre Erfahrung mit dieser Datenbank aufweisen und in den jeweiligen Kapiteln ihre Spezialgebiete darstellen. Die Autoren vermitteln Ihnen fundiertes Know-how sowie praktische Lösungen zu Themen wie Aufbau und Betrieb eines Datenbankservers, Administration und Monitoring, High Availability, Backup und Recovery, Security, Upgrade einer Datenbank und Optimierung. Zusätzlich finden Sie in diesem Handbuch neben einer Darstellung der Produkte und Features der Oracle Database 12c viele Beispiele, Praxistipps und Tricks, die Sie direkt in Ihre tägliche Arbeit integrieren können und die über Versionsgrenzen hinweg anwendbar sind. Im Internet finden Sie nicht nur die nützlichen Skripte des Buches, sondern auch wichtige Informationen, ideal aufbereitet.

Performance Tuning für Oracle-Datenbanken

Methoden aus der Praxis für die Praxis
Author: Leonid Nossov
Publisher: Springer-Verlag
ISBN: 3642330533
Category: Computers
Page: 402
View: 933

Continue Reading →

Stellen Sie sich vor, Ihre Datenbank lahmt plötzlich oder steht gar. Es kann auch sein, dass einige Anwendungsteile zu langsam sind, und Sie wissen nicht, warum. Wie klärt man die Ursache schlechter Performance und wie beseitigt man sie am effektivsten? Welche Möglichkeiten bietet Oracle? Welche anderen nicht oder nur spärlich beschriebenen Methoden und Tricks kann man anwenden, damit Ihre Datenbank wieder richtig „tickt“? Aus diesem Blickwinkel betrachtet der Autor diverse Oracle-Features. Sie sind auch mit Test-Cases versehen, so dass der Leser selbst deren „Tiefen“ untersuchen kann. Da „machs-wie-ich“ eine der besten Lehrmethoden ist, sind zahlreiche Fälle im Buch präsentiert, die direkt für die Praxis umsetzbar sind. Die begleitende Webseite bietet Test-Cases für einige Features sowie SQL- und PLSQL-Skripte für Performance Tuning.

Oracle Database 12c Release 2 Performance Tuning Tips & Techniques


Author: Richard Niemiec
Publisher: McGraw Hill Professional
ISBN: 1259589692
Category: Computers
Page: 848
View: 3276

Continue Reading →

Proven Database Optimization Solutions―Fully Updated for Oracle Database 12c Release 2 Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 12c Release 2 Performance Tuning Tips and Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to identify and fix bottlenecks on premises and in the cloud, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. • Properly index and partition Oracle Database 12c Release 2 • Work effectively with Oracle Cloud, Oracle Exadata, and Oracle Enterprise Manager • Efficiently manage disk drives, ASM, RAID arrays, and memory • Tune queries with Oracle SQL hints and the Trace utility • Troubleshoot databases using V$ views and X$ tables • Create your first cloud database service and prepare for hybrid cloud • Generate reports using Oracle’s Statspack and Automatic Workload Repository tools • Use sar, vmstat, and iostat to monitor operating system statistics

Instant Oracle GoldenGate


Author: Tony Bruzzese
Publisher: Packt Publishing Ltd
ISBN: 1782170251
Category: Computers
Page: 70
View: 2846

Continue Reading →

Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. Get the job done and learn as you go. A how-To book with practical recipes accompanied with rich screenshots for easy comprehension.This is a Packt Instant How-to guide, which provides concise and clear recipes for performing the core task of replication using Oracle GoldenGate.The book is aimed at DBAs from any of popular RDBMS systems such as Oracle, SQL Server, Teradata, Sybase, and so on. The level of detail provides quick applicability to beginners and a handy review for more advanced administrators.

PeopleSoft for the Oracle DBA


Author: David Kurtz
Publisher: Apress
ISBN: 1430237074
Category: Computers
Page: 548
View: 7118

Continue Reading →

PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment. You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment. Explains PeopleSoft’s technical architecture as it relates to Oracle Database Demonstrates how to instrument and measure the performance of PeopleSoft Provides techniques to troubleshoot and resolve performance problems What you’ll learn Understand PeopleSoft’s technical architecture and the structure of a PeopleSoft database Measure performance of the various tiers in the application Pinpoint and resolve performance problems within the code Configure server processes for optimal performance Monitor and manage your PeopleSoft installation using Oracle Enterprise Manager Take full advantage of the PeopleTools Performance Monitor that is new in version 8.44 Who this book is for PeopleSoft for the Oracle DBA is written for database administrators charged with supporting a PeopleSoft system, and especially those administrators responsible for troubleshooting and resolving PeopleSoft performance issues. PeopleSoft for the Oracle DBA also appeals to PeopleSoft administrators and developers who desire a better understanding of how PeopleSoft functions in an Oracle Database environment. Table of Contents An Overview BEA Tuxedo: PeopleSoft’s Application Server Technology Database Connectivity PeopleSoft Database Structure: A Tale of Two Data Dictionaries Keys and Indexing PeopleSoft DDL Tablespaces Locking, Transactions, and Concurrency Performance Metrics PeopleSoft Performance Utilities SQL Optimization Techniques in PeopleSoft Configuring the Application Server Tuning the Application Server The Process Scheduler

Oracle Tuning

The Definitive Reference
Author: Donald K. Burleson
Publisher: Rampant TechPress
ISBN: 0979795192
Category: Computers
Page: 1200
View: 8630

Continue Reading →

For Oracle tuning professionals wishing to add more tools to their Oracle tuning toolbox, this guidebook introduces the various tuning analytical tools and helpful strategies to make the database easier to use. Details describe how to extract information from the database and use it to determine and increase efficiency. It also provides specific steps with detailed information on how to congeal large amounts of database performance information into one pool from which the DBA can carefully choose tuning options based on what is predicted, all to give them the biggest improvement in performance for the least time and money investment. Sample code, sample code results, and guidelines on how to interpret the results help users manipulate code in an effective way. With countless hints, tips, and tools, the guide fully explains how to work with the Oracle system on order to achieve database performance excellence.

Professional Oracle WebLogic Server


Author: Robert Patrick,Gregory Nyberg,Philip Aston
Publisher: John Wiley & Sons
ISBN: 1118057368
Category: Computers
Page: 816
View: 5126

Continue Reading →

Authoritative guide to Oracle WebLogic Server-from Oracle insiders If you're an experienced Java developer who wants to expand your skills, Professional Oracle WebLogic Server is the perfect guide for you. This book is written by a top-notch author team that that includes one of the lead architects from Oracle’s Fusion Middleware Development Architects team. Follow their best practices, workarounds, and sound techniques and confidently develop even the most mission-critical applications with WebLogic Server. This book fully covers WebLogic Server 11g, including the new features of both JEE 5 and WebLogic Server, as well as JEE 5 annotations, Spring, JPA, JAX-WS, JMS Store-And-Forward, SAML support, and the WLST administrative scripting tool. This book is the authoritative guide to Choosing a Web application architecture Best practices for development and production environments Designing an Java EE application Building Enterprise JavaBeans in WebLogic Server Building an EJB application Packaging and deploying WebLogic web applications Developing and deploying web services Using WebLogic JMS Using WebLogic security Administering and deploying applications in WebLogic Server Optimizing WebLogic Server performance

Oracle Solid State Disk Tuning

High Performance Oracle Tuning with RAM Disk
Author: Donald K. Burleson,Michael R. Ault,Mike Ault
Publisher: Rampant TechPress
ISBN: 0974448656
Category: Computers
Page: 187
View: 1339

Continue Reading →

Provides information on using solid state RAM disk to optimize the performance of Oracle.

Expert Oracle Practices

Oracle Database Administration from the Oak Table
Author: Pete Finnigan,Alex Gorbachev,Tim Gorman,Charles Hooper,Jonathan Lewis,Niall Litchfield,Robyn Sands,Joze Senegacnik,Riyaj Shamsudeen,Jeremiah Wilton,Graham Wood,Connie Green,Karen Morton,Randolf Geist,Uri Shaft,Melanie Caffrey
Publisher: Apress
ISBN: 1430226684
Category: Computers
Page: 592
View: 7050

Continue Reading →

This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you. What you’ll learn Adopt a rational approach to database management; eliminate guesswork Add value to your organization as a database professional Manage and optimize performance Exploit different platform technologies Secure your organization's data Gain deep understanding of database internals and structures Who this book is for This book is aimed at Oracle database administrators who want to further their careers by implementing sound and proven database administration practices—and especially repeatable and predictable practices—in their daily work. Table of Contents Battle Against Any Guess A Partly Cloudy Future Developing a Performance Methodology The DBA as Designer Running Oracle on Windows Managing SQL Performance PL/SQL and the CBO Understanding Performance Optimization Methods Choosing a Performance Optimization Method Managing the Very Large Database Statistics Troubleshooting Latch Contention Measuring for Robust Performance User Security Securing Data

Expert Oracle Exadata


Author: Kerry Osborne,Randy Johnson,Tanel Põder
Publisher: Apress
ISBN: 1430233923
Category: Computers
Page: 588
View: 3855

Continue Reading →

Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer. Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Põder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. This book is intended for readers who want to understand what makes the platform tick and for whom—"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides. Will changes the way you think about managing SQL performance and processing Provides a roadmap to laying out the Exadata platform to best support your existing systems Dives deeply into the internals, removing the “black box” mystique and showing how Exadata actually works What you’ll learn Configure Exadata from the ground up Optimize for mixed OLTP/DW workloads Migrate large data sets from existing systems Connect Exadata to external systems Support consolidation strategies using the Resource Manager Configure high-availability features of Exadata, including real application clusters (RAC) and automatic storage management (ASM) Apply tuning strategies utilizing the unique features of Exadata Who this book is for Expert Oracle Exadata is for database administrators and developers who want to understand what makes Exadata unique so that they can take advantage of all the platform has to offer. It is also for anyone who needs to plan and execute migrations of systems to the Exadata platform. Finally, the book will be invaluable to those who support and maintain such systems. Table of Contents What Is Exadata? Offloading / Smart Scan Hybrid Columnar Compression Storage Indexes Exadata Smart Flash Cache Exadata Parallel Operations Resource Management Configuring Exadata Recovering Exadata Exadata Wait Events Understanding Exadata Performance Metrics Monitoring Exadata Performance Migrating to Exadata Storage Layout Compute Node Layout Unlearning Some Things We Thought We Knew