Oracle-Books.com
Home > Publisher > Rampant TechPress
Oracle Books Oracle Tuning: The Definitive Reference (Oracle In-Focus series)
By: Donald K. Burleson
Hardcover: 1200 pages (January 15, 2011)
Rampant Techpress

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 choos e 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.


Oracle Books Advanced Oracle SQL Programming: Expert Guide to Writing Complex Queries
By: Laurent Schneider
Paperback: 450 pages (December 1, 2008)
Rampant Techpress

Providing the best solutions to Oracle customers, this comprehensive manual answers some of SQL's most exciting challenges. Covering all the elements of an Oracle query-including new features from Oracle versions 9i, 10g, and 11g-this guide will help information technology managers and programmers alike to gain new insight into complex queries, advanced aggregation, and analytics techniques. Introducing Model and XML as new ways to retrieve data out of the database, this sourcebook culminates as a perfect companion for advanced programmers and Oracle experts.


Oracle Books Oracle 11g Grid & Real Application Clusters: Oracle 11g Grid Computing with RAC
By: Mike Ault, Madhu Tumma, Byran Jones, Steve Karam
Hardback: 700 pages (December 1, 2008)
Rampant Techpress

Covering all areas of Oracle Grid computing, this guide is indispensable for any Oracle DBA who is charged with configuring and implementing Oracle 11g Grid with server blades. This comprehensive manual presents a complete method for the installation, configuration and design of Oracle Grid and 11g RAC. It supplies expert internals of shared disk technology, raw devices and RAID, and exposes the internal configuration methods for server blades. Also demonstrated is the use of Oracle Grid using t he Enterprise Manager Grid control utility.


Oracle Books Oracle Job Interview Handbook
By: Andrew Kerber, Donald Burleson
Paperback: 200 pages (December 1, 2008)
Rampant Techpress

The product of interviews with hundreds of Oracle professionals, this thorough guidebook provides useful insight into what characteristics make a good database administrator, offering helpful techniques to use while interviewing candidates for an Oracle DBA position. By using Oracle job interview questions that only an experienced person would be familiar with, employers can employ this incredible collection to ensure that their interviewer asks the right questions and hires the best-qualified D BA or developer available. A full set of Oracle job interview questions and a complete method for accurately assessing the technical abilities of Oracle job candidates are provided.


Oracle Books Oracle Utilities: The Definitive Reference
By: Bert Scalzo
Paperback: 300 pages (December 1, 2008)
Rampant Techpress

Targeted toward experienced Oracle professionals who need to perform powerful system-wide operating system on their Oracle databases, this definitive guide includes details on all of the Oracle utilities, including an experts-only section on undocumented utilities, plus the Linux/UNIX utilities, Oracle command-line utilities, and the all-important DBA package utilities. Approaching Oracle Utilities from a functional perspective, this guide adds value by explaining the "why" and "how" for the use of all Oracle Utilities. Additionally, the book also covers Oracle tuning utilities and all areas of Oracle database administration, including ADDM and the SQL tuning advisors and the traditional command-line tuning utilities, as well as secrets for database migration, and detailed tips for using Oracle OS utilities.


Oracle Books Oracle 11g New Features: Get Started Fast with Oracle 11g Enhancements
By: Brian Carr, John Garmany, Lutz Hartmann, V. J. Jain, Steve Karam
Paperback: 300 pages (September 1, 2008)
Rampant Techpress

Tackling some of the more than 500 updates to Oracle 11g that are intended to automate the inherent complexity of the Oracle engine, this guidebook explores all of the new features from the perspective of a working Oracle professional. This valuable resource examines only the important Oracle 11g enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 11g functionality. Written by working Oracle experts for both current DBAs an d Oracle developers and programmers, this flagship book on Oracle 11g explores language and PL/SQL, DBA features, RAC and enhancements, performance features, new security features, and Enterprise Manager.


Oracle Books Oracle Forensics: Oracle Security Best Practices (Oracle In-Focus series)
By: Paul M. Wright
Paperback: 320 pages (May 15, 2008)
Rampant Techpress

Instructions on proactively ensuring the safety and security of Oracle data are found in this innovative guide to Oracle Forensics techniques. Packed with insights and expert tips, this definitive reference provides strategies for protecting critical data from a variety of outside threats and for boosting the overall effectiveness of Oracle firewalls. Additional instructions for developing an automated framework for accessing database security make this required reading for any Oracle database a dministrator.


Oracle Books Oracle Data Mining: Mining Gold from Your Warehouse
By: Dr. Carolyn Hamm
Paperback: 300 pages (July 1, 2007)
Rampant Techpress

Written in the friendly, easy-to-understand style of the For Dummies series, this book shows novice PL/SQL programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. Experienced Oracle programmers and project managers will also benefit from the best practices and code and naming standards material in the book. Discusses getting started with PL/SQL (including language fundamentals, program control, exception handling, and packages); Ora cle-specific programming topics (Oracle constructs of interest to PL/SQL developers, code-placement option, and more); and advanced PL/SQL (manipulating strings, manipulating dates, and manipulating numbers, among others)


Oracle Books Oracle Shell Scripting: Linux and UNIX Programming for Oracle
By: Jon Emmons
Paperback: 293 pages (May 28, 2007)
Rampant Techpress

With the expert techniques discussed in this book, Oracle database administrators can automate routine tasks to save time and money and better monitor the flow of work. Using shell scripts-an indispensable tool on UIX and Linux-any number of commands can be combined and executed either simultaneously or sequentially. More than 50 working shell scripts for both beginners and experts give Oracle professionals a fantastic head-start on automating their administration duties and are easily modifiabl e for any environment. Topics include the history of shells and shell scripting, detailed step-by-step instructions on building shell scripts, how to tell when things are working right, and how to effectively monitor the system for failures.


Oracle Books Database Benchmarking: Practical Methods for Oracle & SQL Server
By: Dr. Bert Scalzo, Kevin Kline, Claudia Fernandez, Mike Ault, Donald Burleson
Paperback: 200 pages (April 1, 2007)
Rampant Techpress

In an effort to provide foresight as systems grow and resources are stressed, this guidebook explains how one of the major causes of unplanned database outages is the failure to anticipate the effects of growth. The benchmark method detailed enables users to spot areas of pending problems before they cripple the database. This real-world approach ensures the user will be prepared for whatever the future brings to mission-critical databases. Areas explored in this book include knowing the limits of the database, avoiding unplanned outages with capacity planning, and predicting the need for new hardware.


Oracle Books Easy Oracle Data Warehousing: Practical Examples for Data Warehouse Success
By: Donald K. Burleson, Mike Ault
Paperback: 227 pages (May 1, 2006)
Rampant Techpress

Targeting those new to Oracle data warehousing who need to get started right away, this book presents real-world problems and issues with managing large volumes of data in an Oracle database. All aspects of Oracle data warehouse management-including Oracle warehouse database administration, OLAP with Oracle Discoverer, Oracle Warehouse Builder, and Oracle data mining-are covered in detail. An overview of Oracle business intelligence tools and a downloadable code depot are also included.


Oracle Books Personal Oracle Real Application Clusters: Create Oracle 10g Grid Computing at-home
By: Edward Stoever, Donald K. Burleson
Paperback: 200 pages (May 1, 2006)
Rampant Techpress

A guide for Oracle DBAs who are too busy to build a clustered server environment to learn about Oracle's Real Application Cluster technology, this book allows DBAs to build and configure a Real Application Cluster quickly and inexpensively. Covers how to find the right hardware to build an at-home RAC, where to get Linux and how to set it up, how to install the Oracle Cluster Manager, and how to create the RAC database.


Oracle Books Easy Oracle Jumpstart: Oracle Database Management Concepts and Administration
By: Robert G. Freeman, Don Burleson
Paperback: 200 pages (May 1, 2006)
Rampant Techpress

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.


Oracle Books Easy HTML-DB Oracle Application Express: Create Dynamic Web Pages with OAE
By: Michael Cunningham, Kent Crotty, Donald Burleson
Paperback: 400 pages (April 15, 2006)
Rampant Techpress

By removing the guesswork from Oracle HTML manipulation, this book shows working examples of complex HTML-DBA database access and techniques for creating easy HTML-DB applications. All HTML-DB concepts are described, and working examples of each HTML-DB feature are provided. Examples of HTML-DB data access and document formatting, information on how to update Oracle HTML-DB, and methods of customizing applications with Themes and CSS are also included.


Oracle Books Oracle Tuning: Oracle 10g Time-series Optimization With The Automatic Workload Repository
By: Alexey B. Danchenkov, Donald Burleson
Hardcover: 640 pages (April 15, 2006)
Rampant Techpress

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.


Oracle Books Easy Oracle PHP: Create Dynamic Web Pages with Oracle Data
By: Mladen Gogala, Donald Burleson
Paperback: 350 pages (April 15, 2006)
Rampant Techpress

Simplifying the work of creating dynamic web pages with Oracle content is the focus of this guide, which provides working examples of connecting to Oracle and delivering data into an HTML page. It thoroughly details information on complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.


Oracle Books Oracle Best Practices: Practical Standards for Success
By: Kent Crotty, Donald K. Burleson
Paperback: 230 pages (April 1, 2006)
Rampant Techpress

Describing the successful techniques employed by large Oracle database shops to ensure quality and uniformity, this guide contains real-world examples and a code depot. All areas of Oracle best practices management, including the Oracle Optimal Flexible Architecture and testing and quality assurance best practices, are covered in detail.


Oracle Books Oracle PL/SQL Tuning: Expert Secrets for High Performance Programming
By: Timothy Hall, Donald K. Burleson
Paperback: 227 pages (April 1, 2006)
Rampant Techpress

With tools for gaining as many as 30 times the execution speed, this handbook educates database administrators on how to rewrite SQL into PL/SQL and how to use advanced Oracle bulk array processing techniques to achieve high performance. Ready-to-use tips for saving hardware costs by running applications at peak efficiencies are provided for senior Oracle DBAs and developers, and powerful PL/SQL techniques are outlined.


Oracle Books Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples
By: John Garmany, Don K. Burleson
Paperback: 200 pages (March 1, 2006)
Rampant Techpress

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.


Oracle Books Oracle RAC & Grid Tuning with Solid-state Disk: Expert Secrets for High Performance Clustered Grid Computing
By: Mike Ault, Robert G. Freeman, John Garmany, Donald K. Burleson
Paperback: 200 pages (January 1, 2006)
Rampant Techpress

This guide to leveraging RAM-SAN technology shows Oracle DBAs how to create fast Oracle9i RAC databases. Techniques for leveraging RAM disk in an Oracle RAC and Grid environment are demonstrated including changes to initialization parameters and the selective use of SSD in large database environments (UNDO, REDO, and TEMP tablespaces on solid-state disk).


Oracle Books Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts
By: Mike Ault, Harry Conway, Don Burleson, Don K. Burleson
Paperback: 1200 pages (January 1, 2006)
Rampant Techpress

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.


Oracle Books Easy Oracle SQL: Get Started Fast Writing SQL Reports with SQL*Plus
By: John Garmany, Don K. Burleson
Paperback: 200 pages (June 1, 2005)
Rampant Techpress

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.


Oracle Books Oracle Silver Bullets: Real-World Oracle Performance Secrets
By: Donald Burleson
Paperback: 200 pages (May 15, 2005)
Rampant Techpress

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.


Oracle Books Oracle Solid State Disk Tuning: High Performance Oracle Tuning with RAM Disk
By: Donald Burleson, Mike Ault
Paperback: 240 pages (February 1, 2005)
Rampant Techpress

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.


Oracle Books Easy Oracle Automation: Oracle10g Automatic Storage, Memory and Diagnostic Features (10g)
By: Dr. Arun Kumar, Don Burleson
Paperback: 200 pages (January 28, 2005)
Rampant Techpress

Explaining how to use the powerful Oracle10g automatic features for simple database administration, this book has complete coverage for 10g Automatic Storage Management (ASM), 10g Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), and the SQL Tuning Advisor. Demonstrated is how a non-Oracle person can quickly install and configure Oracle database 10g for automatic database administration and how, in less than a day, a complete Oracl e10g database can be ready to use. Also explained is easy disk and file management with the 10g Automatic Storage Management and how the 10g Automatic Workload Repository collects important Oracle performance statistics.


Oracle Books Oracle Dataguard: Standby Database Failover Handbook (10g)
By: Bipul Kumar
Paperback: 230 pages (January 28, 2005)
Rampant Techpress

This guide for using Dataguard technology covers all areas of disaster recovery, standby databases, and automatic Oracle failover. The details of how Oracle10g's improved Dataguard provides a comprehensive solution for disaster recovery while keeping a low TCO are discussed. Descriptions of the concepts and architecture of standby databases as well as the implementation and management of Dataguard are provided. Tips for success in configuration and first-time implementation of Dataguard includin g the internal working of Dataguard Broker and Dataguard with Recovery Manager are revealed.


Oracle Books Oracle Streams: High Speed Replication and Data Sharing
By: Madhu Tumma
Paperback: 240 pages (December 28, 2004)
Rampant Techpress

Revealing secrets for achieving high-speed replication and data sharing, this guide uses proven techniques from mission-critical applications for ensuring success with Oracle Streams. From installation to implementation, step-by-step instructions are provided to ensure success with these powerful Oracle features. Oracle DBAs are walked safely through the myriad of complex Oracle Streams tasks including the set-up of the staging area queue, propagation through data hubs, customized apply function s, rule-based data propagation, and Oracle Streams transformation.


Oracle Books Oracle Wait Event Tuning: High Performance with Wait Event Interface Analysis
By: Stephen Andert
Paperback: 200 pages (October 28, 2004)
Rampant Techpress

This handbook provides database administrators with clear and concise processes with which to attack tuning problems using Oracle Wait Interface. A guide is provided to demonstrate the mechanics of the Wait Interface and how to use it not only to tune database performance at the database level but also to give the statistics needed to understand problems that lie outside of the database in the SAN or the network. Techniques that apply to tuning any Oracle database from version 7 through 9i and b eyond are included.


Oracle Books Oracle 10g Grid & Real Application Clusters
By: Mike Ault, Madhu Tumma, Ranko Mosic
Paperback: 680 pages (May 1, 2004)
Rampant Techpress

Revealing the secrets for quickly implementing and tuning Oracle RAC database systems, this book covers all areas of Oracle Real Application Clusters including Oracle10g new features. Oracle DBAs who are charged with configuring and implementing a RAC clusters database will benefit from this complete guide to the installation as well as configuration and design of Oracle Real Application Clusters. Information is supplied on expert internals of shared disk technology, raw devices and RAID with RA C, the internal concurrency, resource coordination, and the locking mechanism within RAC. Also explained are Transparent Application Failover (TAF) and monitoring and tuning Oracle10g RAC applications.


Oracle Books Oracle Disk I/O Tuning: Disk I/O Performance & Optimization for Oracle Databases
By: Donald K. Burleson
Paperback: 300 pages (April 1, 2004)
Rampant Techpress

Covering all aspects of Oracle disk I/O tuning, this book explores disk performance, RAID management, Oracle data file performance, and Oracle data segment internals. Also explored is physical disk I/O, which includes disk device internals, detecting disk bottlenecks, disk organization techniques, and disk striping and disk load balancing. Highlighted are RAID and Oracle performance as well as techniques for effective use of RAID with Oracle. Additionally, Oracle data file internals are consider ed and how to use multiple data block sizes to detect and repair Oracle data segment bottlenecks and segment waits is described. Oracle segment management is illustrated, and the effective use of Oracle segment partitioning, segment slot internals, and monitoring segment I/O is explained.


Oracle Books OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration
By: Christopher T. Foot
Paperback: 336 pages (April 1, 2004)
Rampant Techpress

An instructor's guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, desig n review meetings, software installation, database objects, backup and recovery, and tuning and performance.


Oracle Books Oracle SQL Tuning & CBO Internals
By: Donald K. Burleson
Paperback: 300 pages (April 1, 2004)
Rampant Techpress

As Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time, this book's timing is critical as tuning Oracle SQL has become the single most important skill of the Oracle professional. While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution. Topics include the intern als of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Also included is a ready-to-use code depot full of working SQL tuning scripts, which allow for quick optimization of the SQL and indexes inside the Oracle database.


Oracle Books Oracle Privacy Security Auditing: Includes Federal Law Compliance with HIPAA, Sarbanes Oxley & The Gramm Leach Bliley Act GLB
By: Arup Nanda, Donald K. Burleson
Paperback: 400 pages (December 1, 2003)
Rampant Techpress

Sharing secrets for the effective creation of auditing mechanisms for Health/Insurance Portability and Accountability Act of 1996 (HIPAA) compliant Oracle systems, this book demonstrates how the HIPAA framework provides complete security access and auditing for Oracle database information. Complete details for using Oracle auditing features, including auditing from Oracle redo logs, using system-level triggers, and using Oracle9i fine-grained auditing (FGA) for auditing of the retrieval of sensi tive information, are provided. Examples from all areas of auditing are covered and include working scripts and code snippets. Also discussed are the use of the Oracle9i LogMiner to retrieve audits of database updates and how to implement all Oracle system-level triggers for auditing, including DDL triggers, server error triggers, and login and logoff triggers.


Oracle Books Mike Ault's Oracle Internals Monitoring & Tuning Scripts: Advanced Internals & OCP Certification Insights for the Master DBA
By: Mike Ault, Don Burleson
Paperback: 288 pages (December 1, 2003)
Rampant Techpress

A guide to Oracle DBA management scripts, this book is indispensable for all Oracle professionals who must quickly automate and manage their Oracle databases with scripts. An online code depot full of more than 200 pretested Oracle DBA scripts is provided. Coverage of all areas of Oracle database administration including data files, tablespace, and table and index management scripts is included. Also reviewed are mechanisms for automating Oracle database administration tasks and tips for automat ing without buying expensive tools.


Oracle Books Oracle Replication: Snapshot, Multi-master & Materialized Views Scripts
By: John Garmany, Robert Freeman
Paperback: 208 pages (December 1, 2003)
Rampant Techpress

With the advent of inexpensive and fast worldwide connectivity, many Oracle professionals recognize the benefits of distributing Oracle data. However, Oracle multi-master replication is extremely complex and time-consuming to implant. This book addresses the complexity of Oracle replication by providing working code examples and illustrations of working systems. Demonstrated is every aspect of Oracle snapshot replication including syntax for refresh intervals, managing snapshot logs, monitoring oracle replication, and refresh timings. Included is a description of the intricacies of Oracle multimaster replication tuning and monitoring. Also detailed are techniques for implementing conflict resolution in multi-master replication.


Oracle Books Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration
By: Mike Ault, Madhu Tumma, Daniel Liu
Paperback: 544 pages (December 1, 2003)
Rampant Techpress

For those database administrators intending to upgrade or those who need to know the new features that will affect the entire Oracle database world, this book relates all of the features of this new database. The complete details of the database's new features, including database management and administration enhancements, are discussed. Improvements and additions to security, architecture, Internet features, real application clusters, and performance are also detailed.


Oracle Books Oracle9i RAC: Oracle Real Application Clusters Configuration and Internals
By: Mike Ault, Madhu Tumma
Paperback: 606 pages (August 1, 2003)
Rampant Techpress

A reference for RAC and TAF technology, this book demonstrates how to optimize Oracle clustered server environment for optimal performance and flexibility. Covering all areas of RAC continuous availability and transparent application failover, this book is indispensable for any Oracle DBA who is charged with configuring and implementing a RAC clusters database. Described are the secrets for successful design of RAC clusters and the expert internals of shared disk technology, raw devices and RAID with RAC. Exposed is the internal concurrency and PCM locking mechanisms within RAC and the configuration of Transparent Application Failover is explained. Also provided are tips for monitoring and tuning RAC applications as well as tricks for using Oracle9i RAC Cluster Guard.


Oracle Books Oracle Utilities: Using Hidden Programs, Import/Export, SQL*Loader, oradebug, tkprof, & More
By: Dave Moore, Donald K. Burleson
Paperback: 288 pages (August 1, 2003)
Rampant Techpress

Targeted at seasoned Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases, this book provides help on how to use the utilities provided with the Oracle database. Explained are secrets for database migration with export/import and SQL*Loader utilities as well as OS utilities such as dbverify, orastack, and orakill. Tuning utilities including tkprof and dbms_debug are described in detail in addition to monitoring utilities inc luding dbms_alert and dbms_xplan. Also covered in the book are network and developer utilities.


Oracle Books Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance
By: Donald K. Burleson
Paperback: 160 pages (August 1, 2003)
Rampant Techpress

The dynamic memory features of Oracle9i make it possible to create a self-tuning database. This book explores proven techniques for monitoring the behavior of the Oracle System Global Area (SGA) and shows proven techniques that can be used to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle DBA's this guide focuses on proactive tuning and scripting, and shows how to collect historical data and use it to develop signatures for all memo ry areas. Using these metrics DBAs will be able to develop scripts that will anticipate and correct upcoming SGA performance problems. Provided are the commands to modify the Oracle9i SGA areas, sample scripts for automating SGA tuning, and access to an online code deport full of interesting Oracle scripts.


Oracle Books Oracle Performance Troubleshooting: With Dictionary Internals, SQL & Tuning Scripts
By: Robin Schumacher
Paperback: 272 pages (August 1, 2003)
Rampant Techpress

If you're a DBA who's looking for real world Oracle tuning techniques, Oracle scripts, and advice on how to get to the heart of critical Oracle performance problems, then you've come to the right place. Written by one the world's top DBAs and Oracle internals experts, Robin Schumacher focuses his incredible knowledge of the Oracle data dictionary into a superb book that show how to quickly troubleshoot and correct Oracle performance problems. As a Vice President at Embarcadero Technologies, Rob in Schumacher has written the internals for some of the world's most powerful Oracle performance software and now he shows you how to use the most recent advancements in Oracle8i and 9i to make your Oracle database run as fast as possible.


2001-2011 Oracle-Books.com