Oracle - Books On Amazon.com _{Check eBay.com!}

BOOK
Cost-Based Oracle Fundamentals (Expert's Voice in Oracle)
Jonathan Lewis
$32.41

About this product:

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columnsand the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. Youll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL.

The cost-based optimizer is simply a piece of code that contains a model of how Oracle databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.

In Cost-Based Oracle Fundamentals, the first book in a series of three, Jonathan Lewisone of the foremost authorities in this fielddescribes the most commonly used parts of the model, what the optimizer does with your statistics, and why things go wrong. With this information, youll be in a position to fix entire problem areas, not just single SQL statements, by adjusting the model or creating more truthful statistics.

BOOK
Oracle Applications DBA Covers 11i and R12
Joyjeet Banerjee
$36.07

About this product:
Oracle Applications DBA covers all the pertinent aspects of administrating Oracle Applications—from installation to day-to-day maintenance. It covers upgrading, cloning, patching, maintenance and troubleshooting of the application system. Embellished with over 350 screenshots and illustrations, it helps in administrating complex Oracle Database in an easy-to-navigate format. To help readers manage Oracle Applications without much difficulty, a comprehensive discussion on upgrading Oracle Applications in Unix environment has been provided. Further the book includes a balanced coverage of Oracle 11i and R12 – making it a must-have for experienced Oracle Applications DBAs. Professionals who are keen to migrate from DBA to Apps DBA profile would also find the book useful.

BOOK
Oracle Database 10g SQL (Osborne ORACLE Press Series)
McGraw-Hill
$28.42

About this product:
This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download.

BOOK
OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052)
John Watson
$31.13

About this product:

A Fully Integrated Study System for OCA Exam 1Z0-052

Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including:

• Database architecture
• Creating an Oracle Database
• Managing the Oracle instance
• Configuring and managing the Oracle network
• Managing database storage structures
• Administering user security
• Managing schema objects, data and concurrency, and undo data
• Implementing Oracle Database security
• Database maintenance and performance management
• Backup and recovery
• Moving data
• Intelligent infrastructure enhancements

On the CD-ROM:

• One full practice exam that simulates the actual OCA exam
• Detailed answers and explanations
• Score report performance assessment tool
• Complete electronic book
• Bonus exam available free with online registration

BOOK
Oracle PL/SQL For Dummies
Paul Dorsey
$14.64

About this product:
Find tips for creating efficient PL/SQL code

If you know a bit about SQL, this book will make PL/SQL programming painless!

The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.

Discover how to

• Write efficient, easy-to-maintain code
• Test and debug PL/SQL routines
• Integrate SQL and PL/SQL
• Apply PL/SQL best practices
• Use new features introduced in Oracle 9i and 10g

BOOK
RMAN Recipes for Oracle Database 11<em>g</em> : A Problem-Solution Approach (Expert's Voice in Oracle)
Arup Nanda
$28.95

About this product:

It’s sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database.

There’s much wisdom in that statement. Of all the things you are responsible for as a database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organizations most critical data falls squarely upon your shoulders:

• Lose that data and your company could fail.
• Lose that data and you could be out of a job.

Scared? You should be. But theres help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracles backup and recovery tool of choice. RMAN Recipes for Oracle Database 11g helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. This handy guide

• Demystifies the steps required to protect your business data
• Provides ready-made and step-by-step solutions to simple and complex backup, restore, and recovery operations
• Is task-oriented, making it easy for you to find the solution to pressing backup and recovery problems
• Respects your time by providing example-based solutions, not endless reading material

When the pressure’s on, you dont have time for long discussions of theory. This book gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.

What you’ll learn

Who is this book for?

BOOK
Oracle Tuning: The Definitive Reference (Oracle in-Focus Series)
Donald Burleson
$36.49

About this product:

BOOK
The Faeries' Oracle
Jessica Macbeth
$5.68

About this product:
Author and illustrator Brian Froud offers believers a chance to consult with the magical wee folks. Using a deck of 66 "oracle cards," believers conduct readings as if interpreting Tarot cards. Each of the cards features Froud's signature faery pictures. Some of the cards have specific faeries, like the naked leaping "Spirit Lancer"--a feminine card that represents "self-expression, freedom, and exploration," according to the accompanying text written by Jessica Macbeth. Others are more abstract, like the "Guardian of the Gate," a blue- tinted card with splaying silver-white streaks that look like tendrils of faery hair.

This fascinating deck will keep Froud fans delighted for hours. Once seekers are ready to actually start communicating with faeries, they will also be delighted with Macbeth's whimsical, yet highly informative, guidebook. She is quick to sympathize with the self-consciousness that comes with talking to faeries, yet she also has the ability to jolly people out of their embarrassment. Macbeth is at her wisest when discussing how to ask for guidance and interpret specific layouts of oracle cards. But if you find yourself succumbing to giggles in the midst of all this faery woo-woo, take heart. Writes Macbeth, "Giggles are the grace notes of faery music." --Gail Hudson

BOOK
Oracle E-Business Suite Financials Handbook (Osborne ORACLE Press Series)
Graham H. Seibert
$36.57

About this product:
Deploying Oracle applications in any organization is an enormous task, and Oracle Financials Handbook should be considered prerequisite reading for any technical or business process specialist involved in such a project. The applications provide core business processes based on Oracle Corporation's database architecture, and the book discusses some of the most popular applications in the suite.

The book opens with a brief executive summary of Oracle Financials. The authors place financial applications in perspective, explaining where they fit into the overall Oracle Applications strategy and what the benefits are of choosing them for core business processes. This section also presents some of the important organizational choices you must make at the outset of deployment.

In the middle section of the book, the authors discuss the modules: general ledger, receivables, payables, asset management, purchasing, inventory, order entry, and others. The General Ledger module forms the core of the strategy and is discussed in great detail. The book provides plenty of flow diagrams to explain each module. The authors devote an additional chapter to budgeting and allocations, and address different accounting models.

Oracle Financials Handbook closes with technical details on deploying Oracle Financials in an enterprise. The entire computing environment is considered in this discussion, which includes information on customizing and modifying the modules to meet your needs. The final chapters cover project management and training issues that you need to work through. --Stephen Plain

BOOK
Troubleshooting Oracle Performance
Christian Antognini
$47.97

About this product:

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 helps by providing a systematic approach to addressing the underlying causes of poor database application performance.

• 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

What you’ll learn

• See how to treat and plan for performance as a basic application requirement.
• Identify performance problems using a systematic and repeatable approach.
• Configure your query optimizer to meet your application performance goals.
• Optimize table accesses, joins, and physical table layout.
• Read and recognize inefficient SQL execution plans.
• Reduce inefficiencies from too much procedural code.

Who is this book for?

For application developers and database administrators involved in troubleshooting performance problems of Oracle-based applications

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard-won solutions to problems you will face in your professional programming career.

Related Titles from Apress

• Cost-Based Oracle Fundamentals
• The Art and Science of Oracle Performance Tuning
• Forecasting Oracle Performance