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.

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.

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.

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.

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.

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.

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.

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)

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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).

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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