Author: Donald K. Burleson
Publisher: Rampant Techpress
Release Date: 2014-03
It's impossible to tune an Oracle database without understanding SQL tuning. Oracle is a SQL processing engine and the execution speed of any SQL query is influenced by many factors, both internal and external. As a declarative data access method, SQL relies on the Oracle cost-based optimizer to always choose the "best" execution plan for every SQL query. However, Oracle's SQL is among the most flexible and robust in the world, and along with this great power comes complexity. Tuning Oracle SQL is the single most important skill of any Oracle professional, and Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time. "Advanced Oracle SQL Tuning" is a pragmatic treatment of Oracle SQL tuning, short on theory and big on real-world techniques and tips. This book is the culmination of the author's 25 years of full-time DBA experience and he shares expert tips and secrets for hyper charging SQL execution speed. This book covers advanced topics and it is not appropriate for beginners, dilettantes or neophytes.
Author: Donald K. Burleson
Publisher: Rampant TechPress
Release Date: 2010
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.
This is the definitive guide to all Oracle utilities, and it is targeted at experienced Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases. The authors approach Oracle Utilities from a functional perspective, adding value by explaining the "why" and "how" for the use of all Oracle Utilities. This comprehensive book includes details on all of the Oracle utilities, including experts-only sections on undocumented utilities, plus the Linux/UNIX utilities, Oracle command-line utilities, and the all-important DBA package utilities. This indispensable book covers all areas of Oracle database administration and includes secrets for database migration (with Data Pump and SQL*Loader) and detailed tips for using The Oracle OS utilities (e.g. BBED, dbv, orastack, orakill). The book also covers Oracle tuning utilities, including ADDM and the SQL tuning advisors as well as the traditional command-line tuning utilities such as dbms_alert and dbms_xplan, tkprof and dbms_debug. This book is special because noted Oracle experts supplement the operational considerations of Oracle utilities with expert insights and working scripts. The time savings from a single utility script is easily worth the price of this definitive book. This book is not for beginners. These are powerful utilities to be used only by experienced DBAs and developers who need to perform powerful system-wide operating system internal operations on their Oracle databases.
Oracle PL/SQL is undoubtedly one of the most versatile and high performance yielding database languages of all time with many different methods for obtaining a single result. This comprehensive guide to Oracle PL/SQL will be a handy reference for all Oracle professionals who write PL/SQL code in their daily life. This book will direct the reader through the unused and unknown yet powerful techniques which can be used in a regular manner in application development. This book takes complex technical tasks and explains them in an easily understandable method.
Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQLPlus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.The new second edition of Oracle SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform.With Oracle SQLPlus: The Definitive Guide, you'll expertly: write and execute script files generate ad hoc reports extract data from the database query the data dictionary tables customize an SQLPlus environment and much more It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.This book is truly the definitive guide to SQLPlus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.
This is written for system administrators who may not have the time to learn about Slash by reading the source code. It collects all the current Slash knowledge from the code, Website and mailing lists and organizes it into a coherent package.
Successfully meeting the challenges of combining VMware and Oracle, this comprehensive reference provides a broad spectrum of technological recommendations that demonstrate how to reliably and consistently achieve optimal configuration and maximum performance for any virtualized Oracle database scenario. The guide includes the best practices for virtualized servers, suggested virtualization server configuration, and recommendations for client operating system configuration for Oracle in a virtualized world. With real-world examples and highly applicable advice, this handbook also details the complexities of designing, configuring, maintaining, and tuning Oracle database deployments, making it a complete compendium for keeping virtualized Oracle databases in top form.
Author: Christopher A. Jones
Publisher: "O'Reilly Media, Inc."
Release Date: 2002
If you are a Python programmer who wants to incorporate XML into your skill set, this is the book for you. Python has attracted a wide variety of developers, who use it either as glue to connect critical programming tasks together, or as a complete cross-platform application development language. Yet, because it is object-oriented and has powerful text manipulation abilities, Python is an ideal language for manipulating XML.Python & XML gives you a solid foundation for using these two languages together. Loaded with practical examples, this new volume highlights common application tasks, so that you can learn by doing. The book starts with the basics then quickly progresses to complex topics, like transforming XML with XSLT, querying XML with XPath, and working with XML dialects and validation. It also explores the more advanced issues: using Python with SOAP and distributed web services, and using Python to create scalable streams between distributed applications (like databases and web servers).The book provides effective practical applications, while referencing many of the tools involved in XML processing and Python, and highlights cross-platform issues along with tasks relevant to enterprise computing. You will find ample coverage of XML flow analysis and details on ways in which you can transport XML through your network.Whether you are using Python as an application language, or as an administrative or middleware scripting language, you are sure to benefit from this book. If you want to use Python to manipulate XML, this is your guide.
Exim delivers electronic mail, both local and remote. It has all the virtues of a good postman: it's easy to talk to, reliable, efficient, and eager to accommodate even the most complex special requests. It's the default mail transport agent installed on some Linux systems, runs on many versions of Unix, and is suitable for any TCP/IP network with any combination of hosts and end-user mail software. Exim is growing in popularity because it is open source, scalable, and rich in features such as the following: Compatibility with the calling interfaces and options of Sendmail (for which Exim is usually a drop-in replacement) Lookups in LDAP servers, MySQL and PostgreSQL databases, and NIS or NIS+ services Support for many kinds of address parsing, including regular expressions that are compatible with Perl 5 Sophisticated error handling Innumerable tuning parameters for improving performance and handling enormous volumes of mail Best of all, Exim is easy to configure. You never have to deal with ruleset 3 or worry that a misplaced asterisk will cause an inadvertent mail bomb. While a basic configuration is easy to read and can be created quickly, Exim's syntax and behavior do get more subtle as you enter complicated areas like virtual hosting, filtering, and automatic replies. This book is a comprehensive survey that provides quick information for people in a hurry as well as thorough coverage of more advanced material.
An introduction to embedding systems for C and C++++ programmers encompasses such topics as testing memory devices, writing and erasing Flash memory, verifying nonvolatile memory contents, and much more. Original. (Intermediate).
Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write. The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects. These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle’s world-class language for the database engine. Goes beyond the manual to cover good techniques and best practices Delivers knowledge usually gained only by hard experience Covers the functionality that distinguishes PL/SQL as a powerful and scalable programming language for deploying logic inside the database engine What you’ll learn Learn when PL/SQL is best used, and when to avoid it Move data efficiently using bulk SQL operations Write code that scales through pipelining, parallelism, and profiling Choose the right PL/SQL cursor type for any given application Reduce coding errors through sound development practices such as unit-testing Create and execute SQL and PL/SQL dynamically at runtime Who this book is for Expert PL/SQL Practices is for PL/SQL developers who want to develop deep expertise in key aspects of the language and its use in database programming. Any developer writing code against Oracle’s class-leading database engine will find value from the collected wisdom in this book. Some knowledge of PL/SQL is assumed. Readers should at least be past the beginning stage with the language. Table of Contents Do Not Use Dynamic SQL: Handling the Unknown PL/SQL and Parallel Processing Warnings and Conditional Compilation PL/SQL Unit Testing Bulk SQL Operations Know Your Code Contract-Oriented Programming PL/SQL from SQL Choosing the Right Cursor PL/SQL Programming in the Large Evolutionary Data Modeling Profiling for Performance Coding Conventions and Error Handling Dependencies and Invalidations
Explores Oracle's implementation of SQL and explains how to perform tasks including querying time-based data, implementing conditional logic in queries, writing queries, and joining data from two or more tables.
Demonstrates how to construct and properly build PL/SQL packages, providing a full-use shareware version of PL/Vision and a library of dozens of packages written by the author on the companion disk. Original. (Advanced).