We admit it - we're big name droppers. We like to get to know the big Oracle thinkers, and then we get them to offer training classes with us. So take a look at these books, and then take a look at our training schedule, because they might just be coming to visit.

Mike Swing

Mike Swing is our newest author. He's written a series of books to guide you through the upgrade process for the Release 11.5.10.2 Vision instance to Release 12.1.2 with RDBMS Version 11gR2. Start with the little r12.1.2 project plan, add on the little r12.1.2 upgrade essentials for managers and team members, and then finish up with the little r12.1.2 upgrade guide..

the little r12.1.2 project plan the little r12.1.2 upgrade essentials for managers and team members the little r12.1.2 upgrade guide

Jonathan Lewis

 

Robert Freeman - Oracle Corporation

Although Robert has moved on to the big leagues at Oracle Corporation and no longer offers training with us, we still love him and his books!

 

Tim Gorman

 

Steve Feuerstein

 

Dan Hotka

Scott Spendolini

 

OnCallDBA books on Lulu. Buy Amazon Gift Certificate
     

 

A Few Of My Favorite Books - Guest Author Jonathan Lewis - November 1, 2008

When I was in Salt Lake City last month, Barbara Matthews asked me for my “Top 10” books about Oracle. I don’t normally do lists – and I don’t read many Oracle books – but Iggy Fernandez put the same question, slightly differently phrase, as part of a brief interview for the Northern California User Group magazine a few days later. So I thought I’d try to come up with a useful answer. This is Iggy’s phrasing:

"Let's say that I'm a junior Oracle DBA and my manager offered to buy ten books on Oracle for me. Which books would you recommend?"

Ten is a pretty big number, and I think you'd have to consider getting some books which are tailored to the parts of Oracle used by the business (such as RAC, streams, and so on) but I'll restrict myself to a fairly generic response - to the extent that some of the books aren't even specific to Oracle.

For my first choice I'd try to claim a Kindle or Sony e-Reader as the first "book". I haven't used one in anger, and the Kindle isn't even available in the UK, but the brief play I had with the e-reader left me keen to buy one. (Unfortunately the demo model in the shop was sealed in a tamper-proof frame and had no real books on it because someone had accidentally deleted all (100) books from its memory – so maybe I should be a little cautious about recommending it.)

The second choice(s) ought to be some Oracle manuals. I know you can get them in html or pdf form online (I prefer the pdfs with Acrobat indexing); but for simply reading (rather than reference) there's nothing quite like a real book - and I don't mean a stack of paper from a laser printer. My books of choice would be the Concepts Guide, the Database Admin Guide (Fundamentals) and the Performance Tuning Guide. I might pick the 9i versions, rather than the 10g versions because some of the 10g manuals are getting to the stage where they lean too heavily on "how to use the OEM GUI".

But if you've got a Kindle or eReader, you can probably load the entire set of pdf files for the last four versions of Oracle, and carry them all around at once ! So I'm not going to count any of the Oracle manuals towards my list of 10.

In no particular order, then, here are the other nine:

2. Tapio Lahdenmaki and Mike Leach: Relational Database Index Design and the Optimizers. The authors are better known in the DB2 world than the Oracle world, but the concepts and understanding needed to design good indexes are the same even when there are variations in vendor implementation. (For more details, check my review on www.amazon.co.uk)

3. Dan Tow: SQL Tuning. This is the book that does for SQL Tuning what Tapio Lahdenmaki and Mike Leach do for understanding indexes. There is a way to think through the problems of data access - that method is going to help you find the best execution plan and work out what indexes your system needs.

4. Toon Koppelaars and Lex de Haan: Applied Mathematics for Database Professionals. This is a book that many might think too theoretical for a practising DBA - but if you don't have some idea of why the relational model is a "good thing" then you can't do your job properly. This book may not be a direct help to you in your work, but it may help you to appreciate what you can achieve with the Oracle software. (For more details, check my review on www.amazon.co.uk)

5. Tom Kyte: Expert Oracle Database Architecture. For a wealth of information about a wide range of the Oracle technology and how best to use it. This book tells you a lot about what Oracle can do, but also shows you, by the way it's written, how to extend your knowledge into new areas. If I were allowed a longer list, I would also include Tom's Expert One-on-one Oracle.

6. Jonathan Lewis: Cost Based Oracle - Fundamentals. I know that it's my own, but it is the best book you're going to find about how the optimizer works, and if you understand the core features of the optimizer you'll find it much easier to solve problems with slow SQL. (And if I were allowed a longer list, I probably would include Practical Oracle 8i)

7. Christian Antognini: Troubleshooting Oracle Performance. A recent release that contains a huge amount of information about how to identify and address performance problems.

8. Cary Millsap and Jeff Holt: Optimizing Oracle Performance. There are a couple of key points about Oracle performance that are rarely stated as clearly as they are in this book. One is the focus on addressing the users' complaints, the other is the impact of concurrency. It won't be casual reading for everyone - but the chapter on queueing theory is a must-read for all DBAs.

9. Recovery. If you're a DBA, then the most important job you'll ever do is to make sure that you can recover the database quickly after a disaster - and if you're lucky you'll never have to do it. There's probably a good book out there somewhere, but I've never had any need to go looking for it. But if there is one, then every DBA should have a copy and be made to practise. The difficulty with recovery is that the bits you need to cover well are site dependent, and no one book will tell you all you really need to know about the way you end up doing things for your site.

10. X: One of my pet theories is that people learn more by seeing things go wrong, rather than being told what things look like when they are going well. So all DBAs should be given at least one really bad book about Oracle and told to compare the clarity of writing, quality of explanation, and method of teaching with a good book so that they can learn to recognise suspect material. There are plenty of bad books on the market - fortunately I haven't seen enough of them to be able to give you a "bottom 10" list.

Beginning Oracle Database 11g Administration: From Novice to Professional -This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity.

Oracle Database 10g RMAN Backup & Recovery - Deploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume by Matthew Hart and Robert Freeman. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup And Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, generate meaningful lists and reports, and automate administrative tasks using third-party media management tools. Plus, you'll learn to perform incremental backups, Flashback recoveries, and database cloning.

OCP: Oracle Database 11g Administrator Certified Professional Certification Kit: (1Z0-051, 1Z0-052, and 1Z0-053) - Prepare for your OCP in Oracle Database 11g with this all-in-one study kit by Robert Freeman. Study, practice, and review for certification as an Oracle Database 11g Administrator Certified Professional with this complete study kit that prepares you for three required exams: 1Z0-051, 1Z0-052, and 1Z0-053.

OCP: Oracle Database 11g Administrator Certified Professional Study Guide: (Exam 1Z0-053) - Study, practice, and review for Oracle Certified Professional certification in Oracle 11g, Oracle's new release of its top-selling database software. Inside this in-depth guide, you'll find full coverage of essential topics for the very latest, updated Administration II exam (1Z0-053), including database architecture and ASM; configuring backups; using Flashback technology; managing database performance, memory, and resources; and more. Get extra exam practice using the exercise workbook in the Appendix. Start your preparation today with:

  • Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
  • Bonus Exercise Workbook that allows you to practice as you learn Real-world scenarios that put what you've learned in the context of actual job roles
  • Challenging review questions in each chapter to prepare you for exam day
  • Exam Essentials, a key feature in each chapter that identifies critical areas you must become proficient in before taking the exam
  • A handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective

Oracle Database 11g New Features - This must-have guide to everything new in Oracle Database 11g helps readers realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including:

  • New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components
  • Improved Automated Memory Management capabilities
  • New database design features, such as virtual columns, tablespace encryption, and true table-level data compression
  • New Database Advisors for data recovery and repair, partitioning, and streams performance
  • New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer
  • Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization
  • Improved auditing and security capabilities
  • Advanced BI, data warehousing, and partitioning features
  • New SQL and PL/SQL enhancements

Oracle Database 11g: New Features for DBAs and Developers - Sift the gold from the silt and discover which new features of the latest release of Oracle’s flagship database product are really worth adopting. Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step-by-step testing and a heart-felt emphasis on what matters in the real world to help you get the most out of Oracle Database 11g.

Oracle Database 10g Performance Tuning Tips & Techniques - Rich Niemiec's definitive guide to Oracle performance tuning has been fully expanded to cover every aspect of Oracle Database 10g. This comprehensive resource contains everything database administrators and developers need to know to keep Oracle Database 10g performing at its peak. Real-world case studies and in-depth examples illustrate best practices and highlight the latest tuning options.

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions - Tom Kyte's book covers all of the most important Oracle architecture features, including files, memory structures and processes; locking and latching; transactions, concurrency and multi-versioning; tables and indexes; datatypes; and partitioning and parallelism. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

Practical Oracle8i: Building Efficient Databases - Jonathan Lewis' book offers a real-life approach to constructing Oracle databases--one that is geared toward solving important business problems. This book will help you devise appropriate strategies for database design that takes into account Oracle's technical underpinnings, hardware and user limitations, and tradeoffs between simplicity and efficiency. It discusses selecting the Oracle features needed to perform specific functions and demonstrates how to structure code most effectively for the features being implemented.

Oracle Database 10g Real Application Clusters Handbook - Maximize database availability, scalability, and efficiency using Oracle Real Application Clusters (RAC) and the in-depth information contained in K Gopalakrishnan's guide. Oracle Database 10g Real Application Clusters Handbook explains RAC concepts, administration, tuning, and troubleshooting. Inside, you'll learn how to prepare and create Oracle RAC databases and servers, and automate administrative tasks. You'll also get full coverage of cutting-edge Oracle RAC diagnostic tools, backup and recovery procedures, performance tweaks, and custom application design strategies.

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning - Troubleshoot, diagnose, and optimize your Oracle database efficiently and successfully every time. Tim Gorman, one of our instructors, offered this review:

The book is simply spectacular, both for the quality of its writing as well as the depth of the material. Practical? Indeed, indispensible!

The three authors, Richmond Shee, Kirti Deshpande, and K Gopalakrishnan, have done a wonderful job in organizing a enormous subject area into manageable chunks. They have also managed to render potentially bone-dry source material into very readable text, interspersed heavily with code examples and output, sidebars, and analogies. This is a good read as well as an authoritative reference. I'm still unable to read it steadily for long periods of time, as the analogy of trying to drink from a fire-hose is relevant here. But picking it up and reading different sections, treating it like a reference, has proved rewarding. Richmond, Kirti, and K had an absolute "dream team" of reviewers on this book in Kyle Hailey, John Kanagaraj, Craig Shallahamer, and Graham Wood. The combined efforts of the three authors and the four technical editors blows my mind.

All I can say is - get it! You may (like me) not read it immediately. But, keep it handy. Along with the Google, Ixora, Asktom, JLComp, MetaLink websites, this book is the place to find explanation for the unexplainable in Oracle. Start skimming through it and recognize situations that had previously baffled now being explained (and proved) in full. It is like a light coming on.

Oracle8i Internal Services for Waits, Latches, Locks, and Memory - Steve Adams' concise book contains detailed information about Oracle internals -- information that's not readily available to Oracle customers. It lays a foundation for advanced performance tuning of the Oracle database. Based on Oracle8i release 8.1, the book describes many of the secrets of Oracle's internal services: data structures, algorithms, and undocumented Oracle system statistics. Main topics include waits, latches; locks and memory.

Oracle DBA Checklists Pocket Reference - Pocket guide and quick reference to Oracle DBA, containing easy-to-use checklists for common database administration tasks. Includes coverage of database management, installation and configuration, and network management. Also includes step-by-step quick reference material.

Oracle Built in Packages - Steve Feuerstein's book pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.

Essential Oracle8i Data Warehousing: Designing, Building, and Managing Oracle Data Warehouses - With this book, Gary Dodge describes how to design a data warehouse for optimum performance; construct the data warehouse using Oracle8 and Oracle8i database technology; load data into the data warehouse; summarize and aggregate data within a warehouse; administer and monitor a data warehouse for optimum performance; build and manage very large (multiterabyte) data warehouses.

Oracle Initialization Parameters Pocket Reference - David Kreines' pocket reference describes each initialization parameter, indicates what category it's in--from auditing to multi-threaded server MTS--and whether it can be modified dynamically via the ALTER SESSION or ALTER SYSTEM command. In addition to the details about parameter characteristics and settings, you'll find performance tips, such as how the various parameters interact, and what the most advantageous settings are for different configurations. No other reference focuses exclusively on these initialization parameters--an absolute must for anyone working with an Oracle database.

Oracle Database 10g Insider Solutions - Arun Kumar provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors also address common and not-so-common installation concerns, database administration, development, and tuning.

Everyday Oracle DBA - Learn how to effectively and efficiently administer an Oracle database and handle a variety of daily tasks with ease. Filled with tips, tricks, and shortcuts, April Wells' book is designed to make your job easier and more productive. The book covers database setup, user management, PL/SQL, backup, restoration, tuning, troubleshooting, testing, and much more.

Oracle Database 10g Real Application Clusters Handbook - Maximize database availability, scalability, and efficiency using Oracle Real Application Clusters (RAC) and the in-depth information contained in this Oracle Press guide. Oracle Database 10g Real Application Clusters Handbook explains RAC concepts, administration, tuning, and troubleshooting. Inside, you'll learn how to prepare and create Oracle RAC databases and servers, and automate administrative tasks. You'll also get full coverage of cutting-edge Oracle RAC diagnostic tools, backup and recovery procedures, performance tweaks, and custom application design strategies.

Pro Oracle Database 10g RAC on Linux: Installation, Administration, and Performance (Expert's Voice in Oracle) - Julian Dyke and Steve Shaw's well-received book describes Real Application Clusters (RAC) and the Grid architecture, Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many other topics.

The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. The Oracle features RMAN and Data Guard are also discussed, along with available hardware options. The authors include practical examples and configuration information, so that upon reading this book, you'll be armed with the information you need to build an Oracle RAC database on Linux, whether it is on a single laptop or a 64-node Itanium cluster.

Oracle Database 10g High Availability with RAC, Flashback, and Data Guard (Osborne ORACLE Press Series) - Matthew Hart and Scott Jesse's book offers a "DBA-centric" approach to High Availability. This book concentrates on explaining Oracle Database 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions. Hardware and application needs are also taken into account. While Oracle Database 10g is the main focus, many of the options discussed are available in earlier database releases. Organized to provide conceptual understanding of High Availability, included are "HA Workshops," step-by-step instructions to get you through certain implementations, plus real-world inspired case studies.

 

Mastering Oracle PL/SQL: Practical Solutions - This isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. Connor McDonald shows you how to write code that will run quickly and wont break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques.

Mastering Oracle SQL and SQL*Plus - Lex de Haan's exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics. If you work with relational databases you need to understand the SQL language. And you will gain full competence to define, access, and manipulate data in an Oracle database, if you do so following this book's guidance.

Oracle PL/SQL 101 - Christopher Allen's step-by-step guide to performing database tasks quickly and easily, showing how to automate complicated tasks with PL/SQL. Begins with database basics and quickly moves into more complex areas like writing SQL commands to insert, select, and delete data, and declaring variables using anchored types.

Oracle Built in Packages - Steve Feuerstein's book pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.

Oracle SQL Plus Pocket Reference - Jonathan Gennick's pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i release 8.1.6 features.

 

Oracle Database 10g Performance Tuning Tips & Techniques - Monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, this book is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

Troubleshooting Oracle Performance - 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. Christian Antognini's book 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

Optimizing Oracle Performance - According to Robert Freeman, Cary Milsap and Jeff Holt's book offers this:

"In a style that will be appreciated by the beginner, intermediate and advanced DBA/Developer, Cary and Jeff introduce the reader to the world of the Oracle wait interface. This book has depth, the contents are full of meat, and it's not a rehash of every other Oracle book published in the last 10 years. In these pages is something for everyone. Cary introduces the wait interface, and how it can be used for tuning. The book presents the topic in a clear and concise fashion.

The book is full of detail such as concise information on the internal workings of Oracle trace files and how to use them to your advantage when tuning your Oracle database. They demonstrate the power of the 10046 event and it's potential.

Putting all of this together into a performance tuning method he calls Method-R, they lead us from tuning by guess work into a world of facts and using accurate measures to generate appropriate tuning responses.

This book IS required reading for any DBA who wants to be elevated to the level of a tuning deity. I've already dog eared a goodly number of pages!"

Forecasting Oracle Performance - What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus, not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig Shallahamer's book helps you avoid all the heat in the first place.

Oracle Performance Tuning 101 - Tuning Oracle databases or Oracle Performance Management (OPM) is what database administrators (DBAs) do to help the database run optimally. With the increase in e-commerce and deployment of databases and applications on the Internet, the task of keeping databases running is becoming increasingly important. This entry-level study teaches the essentials of keeping databases running at top performance. Gaja Krishna Vaidyanatha's guide covers releases 7.3 through 8i for NT, Linux and Unix platforms.

 

 

 

 

 

 

Pro Oracle Application Express - Learn from experts John Scott and Scott Spendolini, one of the oiginal creators of APEX, how to take full advantage of APEX. They cover topics including how to product powerful, professionally polished applications, all without developer help.

Shell Scripting Recipes: A Problem-Solution Approach - This book is geared towards any Unix user who doesn't want to spend time creating or testing shell scripts. Instead, Shell Scripting Recipes dissects and explains over 150 much-needed and practical real-world examples, and then shows the reader how and when to appropriately use them. File conversion, system administration, and resource monitoring are just a few of the topics covered in this highly practical shell scripting reference.

Pro Perl - Pro Perl helps you master the key features and complexities of this powerful language. Aimed at intermediate and advanced developers alike, the material assumes some general knowledge of programming concepts but not necessarily prior Perl experience. However, given the expansive coverage of core language topics, Pro Perl also serves as a valuable guide to seasoned Perl programmers seeking to push their proficiency to the next level.

Expert Oracle JDBC Programming - This book teaches you not just how to write JDBC code, but how to write effective JDBC code in a step-by-step fashion. This book does not assume any prior knowledge of JDBC though it does assume basic knowledge of SQL and PL/SQL. It covers JDBC with a focus on writing high-performing, scalable and secure applications for Oracle 10g and 9i.

Mastering Oracle PL/SQL: Practical Solutions - This isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and wont break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques.

Mastering Oracle SQL and SQL*Plus - This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics. If you work with relational databases you need to understand the SQL language. And you will gain full competence to define, access, and manipulate data in an Oracle database, if you do so following this book's guidance.

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions - Tom Kyte's book covers all of the most important Oracle architecture features, including files, memory structures and processes; locking and latching; transactions, concurrency and multi-versioning; tables and indexes; datatypes; and partitioning and parallelism. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

Dive into Python - Dive Into Python is a hands-on guide to the Python language. Each chapter starts with a real, complete code sample, proceeds to pick it apart and explain the pieces, and then puts it all back together in a summary at the end. Python is a new and innovative scripting language. It is set to replace Perl as the programming language of choice for shell scripters, and for serious application developers wanting a feature-rich, yet simple language, with which to deploy their products.

Oracle PL/SQL 101 - A step-by-step guide to performing database tasks quickly and easily, showing how to automate complicated tasks with PL/SQL. Begins with database basics and quickly moves into more complex areas like writing SQL commands to insert, select, and delete data, and declaring variables using anchored types.

Oracle Built in Packages - Steve Feuerstein's book pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.

Oracle SQL Plus Pocket Reference - This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i Release 8.1.6 features.

Storage Networks - Daniel Worden's book provides one of the clearest explanations of RAID striping that we've seen, as well as a thorough discussion of SCSI protocols.

Shell Scripting Recipes: A Problem-Solution Approach - Chris Johnson's book is geared towards any Unix user who doesn't want to spend time creating or testing shell scripts. Instead, Shell Scripting Recipes dissects and explains over 150 much-needed and practical real-world examples, and then shows the reader how and when to appropriately use them. File conversion, system administration, and resource monitoring are just a few of the topics covered in this highly practical shell scripting reference.

Automating Linux and Unix Administration - Wouldn't you like to automate the tedious daily tasks of system administration? This book will show you how, by exploring existing tools and offering real-world examples. Although some of the book is Linux-specific, most of the information applies to any UNIX system, including material on automating tasks across multiple variants of UNIX. Author Kirk Bauer briefly overviews tools and technologiesand assumes preliminary knowledge about editing a configuration file or mounting a file system.

Optimizing Linux Performance: A Hands-On Guide to Linux Performance Tools - Renowned Linux benchmarking specialist Phillip Ezolt introduces each of today's most important Linux optimization tools, showing how they fit into a proven methodology for perfecting overall application performance. Using realistic examples, Ezolt shows developers how to pinpoint exact lines of source code that are impacting performance. He teaches sysadmins and application developers how to rapidly drill down to specific bottlenecks, so they can implement solutions more quickly.

UNIX System Administration Handbook (3rd Edition) - Evi Nemeth's book is ideal as both an introductory tutorial for those new to system administration AND a day-to-day reference for “power administrators.” Practical and hands-on in approach, it covers every aspect of system administration and provides explicit instructions for dealing with the six most popular versions of UNIX. Topics include the filesystem; controlling processes; serial devices; periodic processes; backups; syslog and log files; configuring the kernel; TCP/IP and routing; the Domain Name System; the Network File System; sharing system files; SLIP and PPP; the Internet; security; printing and imaging; disk space management; accounting; and UUCP.

Linux Administration Handbook - Evi Nemeth's guide specifically focuses on the needs of administrators working in production/enterprise environments that may consist of hundreds or even thousands of servers which must be managed centrally to deliver optimal availability and performance. The book contains extensive coverage of Linux security; working with drivers and the kernel; TCP/IP networking; routing; network hardware; and NFS configuration. It also presents comprehensive, step-by-step guidance for configuring and managing email with sendmail; network management and debugging; using Linux in Web hosting environments; automating administration with daemons; and integrating with Windows clients and servers.

the little r12 upgrade guide - Mike Swing tackles upgrading to Release 12 with the first test you ought to do - take the Release 11.5.10.2 Vision instance provided by Oracle. Install it. Upgrade it. This book covers the upgrade on a Linux environment and takes the database from Verison 9i to Version 10g, and the E-Business Suite from Release 11.5.10.2 to Release 12.0.6.

The ABCs of Workflow for E-Business Suite Release 11i and Release 12 - The long-awaited "The ABCs of Workflow for Oracle E-Business Suite Release 11i and Release 12", written by Karen Brownfield, Susan Behn, Gerald Jones and Jerry Ireland, all experts on Oracle Workflow, is finally available. This book is 700 pages long and covers everything anyone might want to know about Workflow, from how to use Builder to create custom Workflows, to problem solving common (and not so common) Workflow problems. We highly recommend this incredibly thorough book.

The Release 12 Primer - The Release 12 Primer describes the modules that have changed the most between E-Business Suite Release 11i and Release 12. The book also includes chapters that describe the Release 12 technical architecture, security issues and Fusion. This combination of both a technical and functional point of view offers a well-rounded perspective for users who need to decide if they should upgrade to Release 12.

Upgrading, Installing and Maintaining Oracle E-Business Suite Applications Release 11.5.10+ - This book provides a thorough technical review of Release 11i, Version 11.5.10+. Topics include Release 11i Concepts and Architecture, Oracle10g, Installing Release 11i, Upgrading or Migrating to Release 11i, Maintaining Release 11i, Administering Release 11i, Securing Release 11i, Setting Up the Concurrent Manager, Using the Concurrent Manager, Release 11i Reporting, and Tuning and Troubleshooting. Co-authored by Barbara Matthews, John Stouffer, Randy Giefer, Karen Brownfield, Jeff Holt, James Morrow, Bruno Coon, Tim Sharpe and Faun deHenry.

Oracle General Ledger Guide: Implement a Highly Automated Financial Processing System - Melanie Cameron's book helps E-Business Suite users learn how to maintain a centralized, highly automated processing platform across a fully integrated set of Oracle E-Business Suite applications using Oracle General Ledger. This Oracle Press guide explains how to utilize Oracle General Ledger to distribute timely and accurate financial information enterprise-wide. Learn efficient techniques for creating transactions and budgets, defining custom rules and flows, reconciling balances, and easing regulatory compliance. You will also discover how to consolidate financial data, process foreign currencies, and implement the brand-new Oracle Subledger Accounting.

  • Plan, test, and carry out a new implementation or upgrade
  • Work with ledgers, calendars, journals, budgets, and business flows
  • Convert and load data from external systems and spreadsheets
  • Perform company-wide consolidations
  • Render reports using the Financial Statement Generator
  • Handle foreign transactions, translations, and revaluations
  • Centralize accounting rules using Oracle Subledger Accounting
  • Understand implications of setup and implementation decision

Oracle Procure-to-Pay Guide - Melanie Cameron's book helps E-Business Suite users drive better decision making and maximize asset usage with Oracle E-Business Suite's comprehensive end-to-end procurement solution. This Oracle Press guide details, step-by-step, how to streamline and optimize your enterprise acquisition cycle using Oracle Procure-to-Pay. Set up and configure each module, generate contracts and purchase orders (POs), perform automatic invoicing, process payments, and enforce fiscal policies. You will also learn how to use powerful new purchasing and payables features.

  • Manage POs and strengthen policy compliance using Oracle Purchasing
  • Track documents from the buyers work center and demand workbench
  • Centralize requisition creation and approvals
  • Create and use sourcing rules for supplier purchases
  • Use Oracle Payables to process invoices and handle settlements
  • Consolidate and disburse funds using Oracle Payments
  • Understand key setups for Oracle Purchasing, Oracle Payables, and Oracle Payments

Installing, Upgrading and Maintaining Oracle Applications 11i - Here's a technical book whose intent is to dive into the details about managing your Release 11i (pre Release 11.5.9) environment. Topics include 11i Concepts and Architecture, 11i New Administration Features, 11i Installation, Upgrading or Migrating to 11i, Maintaining 11i, Administering 11i, Setting Up the Concurrent Manager, Using the Concurrent Manager, Workflow Setup, Using Workflow Builder, Workflow Care and Feeding, and Tuning & Troubleshooting. Co-authored by Barbara Matthews, John Stouffer, Karen Brownfield and Randy Giefer. If you are running Release 11.5.10, take a look at "Installing, Upgrading and Maintaining Oracle E-Business Suite Applications Release 11.5.10+"

Administering Oracle Applications Releases 10.7/11.0 - If you're still running Oracle Applications Release 10.7 or 11.0, then "Administering Oracle Applications" offers plenty of sound advice and examples for how to administer these releases. Topics include Setting Up the Concurrent Manager, Using the Concurrent Manager, Oracle Applications Reports & Programs, Using Oracle Alerts, and Troubleshooting Oracle Applications Problems. If you're running Release 11i, then you should look at "Installing, Upgrading and Maintaining Oracle Applications 11i" for pre-11.5.9 releases, or "Installing, Upgrading and Maintaining Oracle E-Business Suite Release 11.5.10+" for release 11.5.10.

Oracle Applications DBA Field Guide - There are relatively few books that have been published for DBA's that run the 11i Oracle Applications. Well, now we have a good one for our bookshelves... This book was an easy read and kept me engaged throughout the various topics. I especially appreciated the specific MetaLink note references within the chapters that allowed me to gather more detailed information straight from Oracle. DBAs that have been involved with the Oracle Apps for awhile will get a refresher to things they may have learned and forgotten over the years as well as getting a solid explanation of the newer features for 11i; while newer DBA's with get well written explanations of the components needed to run the Apps. This book can also be a great desk reference for those quick "... how does that work..." questions. We highly recommend this book to anyone wanting to learn more about the Apps DBA job.

 

SOA for the Business Developer: Concepts, BPEL, and SCA - Ben Margolis tells the SOA story in a simple, straightforward manner that will help you understand not only the buzzwords and benefits, but also the technologies that underlie SOA: XML, WSDL, SOAP, XPath, BPEL, SCA, and SDO. And through it all, the authors provide business examples and illustrations, giving a practical meaning to abstract ideas.

Pro Apache, Third Edition - Peter Wainwright aims to teach you everything you need to know to build, install, and configure every aspect of Apache, the world's most popular Web server. Two versions of Apache are now available. Apache 1.3 is still widely used and is continuously updated. Apache 2 offers new and powerful features, such as multi-processsing modules and filters, as well as a revised and expanded build system for compiling Apache from source. This book comprehensively covers both server versions, presenting up-to-date information and examples, and highlighting variations bettween the two releases in context.

Expert Oracle JDBC Programming- R.M. Menon teaches you not just how to write JDBC code, but how to write effective JDBC code in a step-by-step fashion. This book does not assume any prior knowledge of JDBC though it does assume basic knowledge of SQL and PL/SQL. It covers JDBC with a focus on writing high-performing, scalable and secure applications for Oracle 10g and 9i.

Oracle Application Server 10g Essentials - Robert Stakowiak provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms and Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software. Divided into three concise sections, the book covers server basics, core components, and server functionality.

The Oracle Hacker's Handbook: Hacking and Defending Oracle - David Litchfield has devoted years to relentlessly searching out the flaws in the Oracle database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems. This in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle and then it shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

Oracle E-Business Suite Security - Secure Oracle E-Business Suite within organizations and across the Internet using the in-depth guidance of this comprehensive volume. John Abel covers everything from key infrastructure, technical, and functional information to cutting-edge auditing, cryptography, and VPD techniques. Real-world scenarios and insightful tips throughout illustrate how to hacker-proof, audit, and troubleshoot your system. Plus, you'll get critical information on international regulatory standards, access to online code, and a blueprint of deployment topology.

Effective Oracle Database 10g Security by Design - Oracle expert David Knox has written the most practical, up-to-date book on Oracle Database 10g security available. With an emphasis on real-world problems and detailed solutions, this book provides all the information you need to develop and deploy secure database applications. The entire security cycle is covered--from identification and authentication to fine-grained access control and encryption to effective auditing techniques. The material is presented with comprehensive yet easy-to-understand examples that show how to use all the security technologies in a complementary way.

  • Assess database vulnerabilities and develop effective security policies
  • Preserve user identity with in-depth analyses of JDBC connection pools, proxy authentication, and client identifiers
  • Manage database users from a central directory without sacrificing security
  • Lock down database access using secure application roles
  • Leverage application and database security within Oracle’s Identity Management infrastructure
  • Validate user privileges by using simple views and scripts
  • Protect individual data elements by using the new Oracle DBMS_CRYPTO package
  • Exploit database views to provide row-level and column-level fine-grained access controls
  • Enforce need-to-know access and data privacy with Virtual Private Database and Oracle Label Security
  • Ensure user accountability with Oracle fine-grained Auditing

Content 12

Practical Oracle8i: Building Efficient Databases - Jonathan Lewis' book offers a real-life approach to constructing Oracle databases--one that is geared toward solving important business problems. This book will help you devise appropriate strategies for database design that takes into account Oracle's technical underpinnings, hardware and user limitations, and tradeoffs between simplicity and efficiency. It discusses selecting the Oracle features needed to perform specific functions and demonstrates how to structure code most effectively for the features being implemented.

Oracle Database 11g: New Features for DBAs and Developers - Sift the gold from the silt and discover which new features of the latest release of Oracle’s flagship database product are really worth adopting. Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step-by-step testing and a heart-felt emphasis on what matters in the real world to help you get the most out of Oracle Database 11g.

Oracle Database 10g Performance Tuning Tips & Techniques - Rich Niemiec's definitive guide to Oracle performance tuning has been fully expanded to cover every aspect of Oracle Database 10g. This comprehensive resource contains everything database administrators and developers need to know to keep Oracle Database 10g performing at its peak. Real-world case studies and in-depth examples illustrate best practices and highlight the latest tuning options.

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions - Tom Kyte's book covers all of the most important Oracle architecture features, including files, memory structures and processes; locking and latching; transactions, concurrency and multi-versioning; tables and indexes; datatypes; and partitioning and parallelism. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning - Troubleshoot, diagnose, and optimize your Oracle database efficiently and successfully every time. This exclusive Oracle Press guide explains how to take full advantage of the revolutionary Oracle Wait Interface (OWI) to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially. Get extensive details on all the OWI features, including the wait event views, their applications, and the extended SQL trace file. This invaluable resource will help you maximize the most advanced diagnostics tool available and minimize processing time.

Oracle8i Internal Services for Waits, Latches, Locks, and Memory - This concise book contains detailed information about Oracle internals -- information that's not readily available to Oracle customers. It lays a foundation for advanced performance tuning of the Oracle database. Based on Oracle8i release 8.1, the book describes many of the secrets of Oracle's internal services: data structures, algorithms, and undocumented Oracle system statistics. Main topics include waits, latches; locks and memory.

Oracle DBA Checklists Pocket Reference - Pocket guide and quick reference to Oracle DBA, containing easy-to-use checklists for common database administration tasks. Includes coverage of database management, installation and configuration, and network management. Also includes step-by-step quick reference material.

Oracle Built in Packages - Steve Feuerstein's book pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.

Essential Oracle8i Data Warehousing: Designing, Building, and Managing Oracle Data Warehouses - With this book, you'll learn how to design a data warehouse for optimum performance; construct the data warehouse using Oracle8 and Oracle8i database technology; load data into the data warehouse; summarize and aggregate data within a warehouse; administer and monitor a data warehouse for optimum performance; build and manage very large (multiterabyte) data warehouses.

Oracle Initialization Parameters Pocket Reference - The book describes each initialization parameter, indicates what category it's in--from auditing to multi-threaded server MTS--and whether it can be modified dynamically via the ALTER SESSION or ALTER SYSTEM command. In addition to the details about parameter characteristics and settings, you'll find performance tips, such as how the various parameters interact, and what the most advantageous settings are for different configurations. No other reference focuses exclusively on these initialization parameters--an absolute must for anyone working with an Oracle database.

Oracle Database 10g Insider Solutions - This book provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors also address common and not-so-common installation concerns, database administration, development, and tuning.

Everyday Oracle DBA - Learn how to effectively and efficiently administer an Oracle database and handle a variety of daily tasks with ease. Filled with tips, tricks, and shortcuts, "Everyday Oracle DBA" is designed to make your job easier and more productive. The book covers database setup, user management, PL/SQL, backup, restoration, tuning, troubleshooting, testing, and much more.

Pro Oracle Database 10g RAC on Linux: Installation, Administration, and Performance - Real Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. This book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many other topics. The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. The Oracle features RMAN and Data Guard are also discussed, along with available hardware options.

Oracle Database 10g Real Application Clusters Handbook - Maximize database availability, scalability, and efficiency using Oracle Real Application Clusters (RAC) and the in-depth information contained in this Oracle Press guide. Oracle Database 10g Real Application Clusters Handbook explains RAC concepts, administration, tuning, and troubleshooting. Inside, you'll learn how to prepare and create Oracle RAC databases and servers, and automate administrative tasks. You'll also get full coverage of cutting-edge Oracle RAC diagnostic tools, backup and recovery procedures, performance tweaks, and custom application design strategies.

Mastering Oracle PL/SQL: Practical Solutions - This isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and wont break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques.

Mastering Oracle SQL and SQL*Plus - This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics. If you work with relational databases you need to understand the SQL language. And you will gain full competence to define, access, and manipulate data in an Oracle database, if you do so following this book's guidance.

Oracle PL/SQL 101 - A step-by-step guide to performing database tasks quickly and easily, showing how to automate complicated tasks with PL/SQL. Begins with database basics and quickly moves into more complex areas like writing SQL commands to insert, select, and delete data, and declaring variables using anchored types.

Oracle Built in Packages - Steve Feuerstein's book pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.

Oracle SQL Plus Pocket Reference - This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i release 8.1.6 features.

Mastering Oracle PL/SQL: Practical Solutions - This isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and wont break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques.

Mastering Oracle SQL and SQL*Plus - This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics. If you work with relational databases you need to understand the SQL language. And you will gain full competence to define, access, and manipulate data in an Oracle database, if you do so following this book's guidance.

Oracle PL/SQL 101 - A step-by-step guide to performing database tasks quickly and easily, showing how to automate complicated tasks with PL/SQL. Begins with database basics and quickly moves into more complex areas like writing SQL commands to insert, select, and delete data, and declaring variables using anchored types.

Oracle Built in Packages - Steve Feuerstein's book pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.

Oracle SQL Plus Pocket Reference - This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i release 8.1.6 features.

Pro Oracle Application Express - Learn from experts John Scott and Scott Spendolini, one of the oiginal creators of APEX, how to take full advantage of APEX. They cover topics including how to product powerful, professionally polished applications, all without developer help.

Shell Scripting Recipes: A Problem-Solution Approach - This book is geared towards any Unix user who doesn't want to spend time creating or testing shell scripts. Instead, Shell Scripting Recipes dissects and explains over 150 much-needed and practical real-world examples, and then shows the reader how and when to appropriately use them. File conversion, system administration, and resource monitoring are just a few of the topics covered in this highly practical shell scripting reference.

Pro Perl - Pro Perl helps you master the key features and complexities of this powerful language. Aimed at intermediate and advanced developers alike, the material assumes some general knowledge of programming concepts but not necessarily prior Perl experience. However, given the expansive coverage of core language topics, Pro Perl also serves as a valuable guide to seasoned Perl programmers seeking to push their proficiency to the next level.

Expert Oracle JDBC Programming - This book teaches you not just how to write JDBC code, but how to write effective JDBC code in a step-by-step fashion. This book does not assume any prior knowledge of JDBC though it does assume basic knowledge of SQL and PL/SQL. It covers JDBC with a focus on writing high-performing, scalable and secure applications for Oracle 10g and 9i.

Mastering Oracle PL/SQL: Practical Solutions - This isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and wont break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques.

Mastering Oracle SQL and SQL*Plus - This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics. If you work with relational databases you need to understand the SQL language. And you will gain full competence to define, access, and manipulate data in an Oracle database, if you do so following this book's guidance.

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions - Tom Kyte's book covers all of the most important Oracle architecture features, including files, memory structures and processes; locking and latching; transactions, concurrency and multi-versioning; tables and indexes; datatypes; and partitioning and parallelism. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

Dive into Python - Dive Into Python is a hands-on guide to the Python language. Each chapter starts with a real, complete code sample, proceeds to pick it apart and explain the pieces, and then puts it all back together in a summary at the end. Python is a new and innovative scripting language. It is set to replace Perl as the programming language of choice for shell scripters, and for serious application developers wanting a feature-rich, yet simple language, with which to deploy their products.

Oracle PL/SQL 101 - A step-by-step guide to performing database tasks quickly and easily, showing how to automate complicated tasks with PL/SQL. Begins with database basics and quickly moves into more complex areas like writing SQL commands to insert, select, and delete data, and declaring variables using anchored types.

Oracle Built in Packages - Steve Feuerstein's book pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.

Oracle SQL Plus Pocket Reference - This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i Release 8.1.6 features.

Storage Networks - This book provides one of the clearest explanations of RAID striping that we've seen, as well as a thorough discussion of SCSI protocols.

Shell Scripting Recipes: A Problem-Solution Approach - This book is geared towards any Unix user who doesn't want to spend time creating or testing shell scripts. Instead, Shell Scripting Recipes dissects and explains over 150 much-needed and practical real-world examples, and then shows the reader how and when to appropriately use them. File conversion, system administration, and resource monitoring are just a few of the topics covered in this highly practical shell scripting reference.

Automating UNIX and Linux Administration - Wouldn't you like to automate the tedious daily tasks of system administration? This book will show you how, by exploring existing tools and offering real-world examples. Although some of the book is Linux-specific, most of the information applies to any UNIX system, including material on automating tasks across multiple variants of UNIX. Author Kirk Bauer briefly overviews tools and technologiesand assumes preliminary knowledge about editing a configuration file or mounting a file system.

Optimizing Linux Performance: A Hands-On Guide to Linux Performance Tools - Renowned Linux benchmarking specialist Phillip Ezolt introduces each of today's most important Linux optimization tools, showing how they fit into a proven methodology for perfecting overall application performance. Using realistic examples, Ezolt shows developers how to pinpoint exact lines of source code that are impacting performance. He teaches sysadmins and application developers how to rapidly drill down to specific bottlenecks, so they can implement solutions more quickly.

UNIX System Administration Handbook (3rd Edition) - This book is ideal as both an introductory tutorial for those new to system administration AND a day-to-day reference for “power administrators.” Practical and hands-on in approach, it covers every aspect of system administration and provides explicit instructions for dealing with the six most popular versions of UNIX. Topics include the filesystem; controlling processes; serial devices; periodic processes; backups; syslog and log files; configuring the kernel; TCP/IP and routing; the Domain Name System; the Network File System; sharing system files; SLIP and PPP; the Internet; security; printing and imaging; disk space management; accounting; and UUCP.

SOA for the Business Developer: Concepts, BPEL, and SCA - This book tells the SOA story in a simple, straightforward manner that will help you understand not only the buzzwords and benefits, but also the technologies that underlie SOA: XML, WSDL, SOAP, XPath, BPEL, SCA, and SDO. And through it all, the authors provide business examples and illustrations, giving a practical meaning to abstract ideas.

Pro Apache, Third Edition - This book aims to teach you everything you need to know to build, install, and configure every aspect of Apache, the world's most popular Web server. Two versions of Apache are now available. Apache 1.3 is still widely used and is continuously updated. Apache 2 offers new and powerful features, such as multi-processsing modules and filters, as well as a revised and expanded build system for compiling Apache from source. This book comprehensively covers both server versions, presenting up-to-date information and examples, and highlighting variations bettween the two releases in context.

Expert Oracle JDBC Programming - This book teaches you not just how to write JDBC code, but how to write effective JDBC code in a step-by-step fashion. This book does not assume any prior knowledge of JDBC though it does assume basic knowledge of SQL and PL/SQL. It covers JDBC with a focus on writing high-performing, scalable and secure applications for Oracle 10g and 9i.

Oracle Application Server 10g Essentials - This guide provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms and Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software. Divided into three concise sections, the book covers server basics, core components, and server functionality.

The Oracle Hacker's Handbook: Hacking and Defending Oracle - David Litchfield has devoted years to relentlessly searching out the flaws in the Oracle database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems. This in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle and then it shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

Upgrading, Installing and Maintaining Oracle E-Business Suite Applications Release 11.5.10+ - This book provides a thorough technical review of Release 11i, Version 11.5.10+. Topics include Release 11i Concepts and Architecture, Oracle10g, Installing Release 11i, Upgrading or Migrating to Release 11i, Maintaining Release 11i, Administering Release 11i, Securing Release 11i, Setting Up the Concurrent Manager, Using the Concurrent Manager, Release 11i Reporting, and Tuning and Troubleshooting. Co-authored by Barbara Matthews, John Stouffer, Randy Giefer, Karen Brownfield, Jeff Holt, James Morrow, Bruno Coon, Tim Sharpe and Faun deHenry.

The ABCs of Workflow for E-Business Suite Release 11i and Release 12 - The long-awaited "The ABCs of Workflow for Oracle E-Business Suite Release 11i and Release 12", written by Karen Brownfield, Susan Behn, Gerald Jones and Jerry Ireland, all experts on Oracle Workflow, is finally available. This book is 700 pages long and covers everything anyone might want to know about Workflow, from how to use Builder to create custom Workflows, to problem solving common (and not so common) Workflow problems. We highly recommend this incredibly thorough book.

The Release 12 Primer - The Release 12 Primer describes the modules that have changed the most between E-Business Suite Release 11i and Release 12. The book also includes chapters that describe the Release 12 technical architecture, security issues and Fusion. This combination of both a technical and functional point of view offers a well-rounded perspective for users who need to decide if they should upgrade to Release 12.

PeopleSoft for the Oracle DBA - "PeopleSoft for the Oracle DBA" will teach you a range of techniques for maintaining a PeopleSoft system. You can then implement techniques like indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Author David Kurtz is a field expert and thus provides answers to common questions that arise when using PeopleSoft on an Oracle database. Kurtz begins with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. The book covers database structures, connectivity, keys and indexing, the PeopleSoft DDL, and tablespaces. Kurtz gives appropriate weight to advanced topics as well, like schemas, performance metrics, performance monitoring utilities, and SQL optimization techniques. And the final chapters provide crucial, advanced information about Tuxedo.

Oracle Database 11g New Features - Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this book offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations of Oracle Database 11g. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g.

Forecasting Oracle Performance - What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus, not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig's book helps you avoid all the heat in the first place.

Oracle Insights: Tales of the Oak Table - Eleven world-renowned industry specialists proffer their own highly experienced views, input, and insights on Oracle - where it's been, where it's going, how (and how not) to use it successfully, the software and techniques that they've introduced to help people achieve their goals, and some frightening tales of what can happen when fundamental design principles are ignored. The collaborating authors have solved many of the worst Oracle performance problems in the world, and they've each saved at least one doomed flagship project.

Oracle PL/SQL Best Practices - In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering Oracle Database 11g, Feuerstein has rewritten this book in the style of his bestselling "Oracle PL/SQL Programming". The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes - and each other.

Oracle PL/SQL Developer's Workbook - However excellent they are, most computer books are inherently passive--readers simply take in text without having any opportunity to react to it. The "Oracle PL/SQL Developer's Workbook" is designed to engage you actively, to get you solving programming problems immediately, and to help you apply what you've learned about PL/SQL--and in the process deepen your knowledge of the language. The book contains a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer--both with PL/SQL and with other languages. Exercises are provided at three levels: beginner, intermediate, and expert. The workbook exercises cover all the major features of PL/SQL, including those new to Oracle8i (e.g., Java and web features, autonomous transactions, and bulk binds).

Oracle Built in Packages - Steve Feuerstein's book pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.

Cost-Based Oracle Fundamentals - Jonathan Lewis' "Cost-Based Oracle Fundamentals" provides a deep dive into Oracle's Cost Based Optimizer. Topics include how to gather system statistics, selectivity issues, histograms, bitmap indexes, sorting and merge joins, and hash joins.

Oracle SQL Developer Handbook - Enhance productivity and simplify database development tasks using Oracle SQL Developer and the detailed instructions in this guide. Written by experienced Oracle instructor Dan Hotka, Oracle SQL Developer Handbook shows you, step-by-step, how to put every feature of this deployment tool to work for you. Inside, you'll learn to set up Oracle SQL Developer, establish database connections, and manage SQL, SQL*Plus, and PL/SQL scripts. Detailed code examples and screenshots illustrate each point along the way.

Oracle PL/SQL for DBAs - Covering Oracle Database 10g Release 2, and packed with code and usage examples, "Oracle PL/SQL for DBAs" contains a quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running; extensive coverage of security topics for DBAs: Encryption (including both traditional methods and Oracle's new Transparent Data Encryption, TDE); Row-Level Security (RLS), Fine-Grained Auditing (FGA); and random value generation; methods for DBAs to improve query and database performance with cursors and table functions; and coverage of Oracle scheduling, which allows jobs such as database monitoring and statistics gathering to be scheduled for regular execution.

Oracle Database 10g RMAN Backup & Recovery - To say Robert Freeman knows databases is a bit of an understatement. In this book, Robert Freeman and Matthew Hart delve into the RMAN architecture, how to configure RMAN for backup and recovery operations, how to perform offline and online database backups, and diagnosing errors that require RMAN recovery.

Oracle PL/SQL Programming, 4th Edition - If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where Steve Feuerstein's Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit.

Toad Handbook - TOAD Handbook is a guide for developing Oracle applications and administering Oracle databases with TOAD. Starting with installation and configuration, the book covers the TOAD SQL editors in depth, including dozens of helpful, undocumented features. Later chapters discuss reporting and exporting data and using several add-on tools designed to enhance TOAD development. Along the way, the authors, Bert Scalzo and Dan Hotka, provide critical insights into the workings of TOAD and how developers can use it to make the most of their applications. Includes a foreword by Jim McDaniel, the inventor of TOAD.

Installing, Upgrading and Maintaining Oracle Applications 11i - Here's a technical book whose intent is to dive into the details about managing your Release 11i (pre Release 11.5.9) environment. Topics include 11i Concepts and Architecture, 11i New Administration Features, 11i Installation, Upgrading or Migrating to 11i, Maintaining 11i, Administering 11i, Setting Up the Concurrent Manager, Using the Concurrent Manager, Workflow Setup, Using Workflow Builder, Workflow Care and Feeding, and Tuning & Troubleshooting. Co-authored by Barb Matthews, John Stouffer, Karen Brownfield and Randy Giefer. If you are running Release 11.5.10, take a look at "Installing, Upgrading and Maintaining Oracle E-Business Suite Applications Release 11.5.10+"

Upgrading, Installing and Maintaining Oracle E-Business Suite Applications Release 11.5.10+ - This book provides a thorough technical review of Release 11i, Version 11.5.10+. Topics include Release 11i Concepts and Architecture, Oracle10g, Installing Release 11i, Upgrading or Migrating to Release 11i, Maintaining Release 11i, Administering Release 11i, Securing Release 11i, Setting Up the Concurrent Manager, Using the Concurrent Manager, Release 11i Reporting, and Tuning and Troubleshooting. Co-authored by Barbara Matthews, John Stouffer, Randy Giefer, Karen Brownfield, Jeff Holt, James Morrow, Bruno Coon, Tim Sharpe and Faun deHenry.

The ABCs of Workflow for E-Business Suite Release 11i and Release 12 - The long-awaited "The ABCs of Workflow for Oracle E-Business Suite Release 11i and Release 12", written by Karen Brownfield, Susan Behn, Gerald Jones and Jerry Ireland, all experts on Oracle Workflow, is finally available. This book is 700 pages long and covers everything anyone might want to know about Workflow, from how to use Builder to create custom Workflows, to problem solving common (and not so common) Workflow problems. We highly recommend this incredibly thorough book.

The Release 12 Primer - The Release 12 Primer describes the modules that have changed the most between E-Business Suite Release 11i and Release 12. The book also includes chapters that describe the Release 12 technical architecture, security issues and Fusion. This combination of both a technical and functional point of view offers a well-rounded perspective for users who need to decide if they should upgrade to Release 12.

Administering Oracle Applications Releases 10.7/11.0 - If you're still running Oracle Applications Release 10.7 or 11.0, then "Administering Oracle Applications" offers plenty of sound advice and examples for how to administer these releases. Topics include Setting Up the Concurrent Manager, Using the Concurrent Manager, Oracle Applications Reports & Programs, Using Oracle Alerts, and Troubleshooting Oracle Applications Problems. If you're running Release 11i, then you should look at "Installing, Upgrading and Maintaining Oracle Applications 11i" for pre-11.5.9 releases, or "Installing, Upgrading and Maintaining Oracle E-Business Suite Release 11.5.10+" for release 11.5.10.

Oracle Applications DBA Field Guide - There are relatively few books that have been published for DBA's that run the 11i Oracle Applications. Well, now we have a good one for our bookshelves... This book was an easy read and kept me engaged throughout the various topics. I especially appreciated the specific MetaLink note references within the chapters that allowed me to gather more detailed information straight from Oracle. DBAs that have been involved with the Oracle Apps for awhile will get a refresher to things they may have learned and forgotten over the years as well as getting a solid explanation of the newer features for 11i; while newer DBA's with get well written explanations of the components needed to run the Apps. This book can also be a great desk reference for those quick "... how does that work..." questions. We highly recommend this book to anyone wanting to learn more about the Apps DBA job.

Pro Oracle Database 10g RAC on Linux: Installation, Administration, and Performance (Expert's Voice in Oracle) - Julian Dyke and Steve Shaw's well-received book describes Real Application Clusters (RAC) and the Grid architecture, Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many other topics.

The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. The Oracle features RMAN and Data Guard are also discussed, along with available hardware options. The authors include practical examples and configuration information, so that upon reading this book, you'll be armed with the information you need to build an Oracle RAC database on Linux, whether it is on a single laptop or a 64-node Itanium cluster.

Oracle Database 10g High Availability with RAC, Flashback, and Data Guard (Osborne ORACLE Press Series) - Matthew Hart and Scott Jesse's book offers a "DBA-centric" approach to High Availability. This book concentrates on explaining Oracle Database 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions. Hardware and application needs are also taken into account. While Oracle Database 10g is the main focus, many of the options discussed are available in earlier database releases. Organized to provide conceptual understanding of High Availability, included are "HA Workshops," step-by-step instructions to get you through certain implementations, plus real-world inspired case studies.