Search

OakieTags

Who's online

There are currently 0 users and 48 guests online.

Recent comments

Affiliations

Books

  • Practical Oracle Database Appliance

    Book: 
    Image of Practical Oracle Database Appliance
    Author: Erik Benner, Fuad Arshad, Bobby Curtis
    Publisher: Apress (2014)
    Binding: Paperback, 272 pages
  • Expert Oracle Enterprise Manager 12c

    Book: 
    Image of Expert Oracle Enterprise Manager 12c (Expert Apress)
    Author: Anand Akela, Alex Gorbachev, Niall Litchfield
    Publisher: Apress (2013)
    Binding: Paperback, 534 pages

    Enterprise Manager 12c (EM12c), Oracle’s newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today’s increasingly chaotic and change-driven IT environment.

    Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins.  Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager. 
     

  • Oracle Web Application Programming for PL/SQL Developers

    Book: 
    Image of Oracle 9i Web Application Programming for PL/SQL Development (Prentice Hall PTR Oracle)
    Author: Benjamin Rosenzweig, Solomon Morse, Melanie Caffrey, Susan Boardman
    Publisher: Prentice Hall (2002)
    Binding: Paperback, 745 pages
  • Expert PL/SQL Practices: for Oracle Developers and DBAs

    Book: 
    Image of Expert PL/SQL Practices: For Oracle Developers and Dbas
    Author: Lewis Cunningham, Dominic Delmolino, Michael Rosenblum
    Publisher: Springer Verlag GmbH (2011)
    Binding: Paperback, 514 pages
  • Oracle Core - Essential Internals for DBAs and Developers (Jonathan Lewis)

    Book: 
    Image of Oracle Core: Essential Internals for Dbas and Developers (Expert's Voice in Databases)
    Author: Jonathan Lewis
    Publisher: Springer Verlag GmbH (2011)
    Binding: Paperback, 282 pages

     Oracle Core: Essential Internals for Troubleshooting by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less.
     
    Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data.
    Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book.

    • Provides proven content from a world-renowned performance and troubleshooting expert
    • Emphasizes the significance of internals knowledge to rapid identification of database performance problems
    • Covers the core essentials and does not waste your time with esoterica

    What you’ll learn

    • Oracle's core architectural foundations
    • How much overhead is reasonable
    • How to recognize when you're doing too much work
    • How to predict bottlenecks and why they will happen
    • How to minimise contention and locking
    • Why concurrency can slow things down significantly

    Who this book is for
     Oracle Core: Essential Internals for Troubleshooting is aimed at database administrators ready to move beyond the beginning stage of doing work by rote towards the mastery stage, in which knowledge of what needs to be done comes not from a set of recipe-style instructions, but rather from the intimate knowledge and understanding of the system to be managed. Experienced database administrators will also find the book useful in solidifying their knowledge and filling in any missing pieces of the Oracle Database puzzle.
     

  • Applied Mathematics for Database Professionals

    Book: 
    Image of Applied Mathematics for Database Professionals (Expert's Voice)
    Author: Toon Koppelaars, Lex de Haan
    Publisher: Springer (2007)
    Binding: Hardcover, 412 pages

    This book is about the mathematical foundation of relational databases; it demonstrates how logic and set theory can be used as tools to formally specify database designs, including the data integrity constraints (a main topic of this book). Don't let this scare you of; the book explains the required mathematical concepts with many examples and should be accessible for the regular database professional. It does assume that you are familiar with designing a database.

    You'll find three parts in this book:

    • Part 1 provides the mathematics. It covers those parts of logic and set theory that are both necessary and sufficient to formally specify database designs and their constraints.
    • Part 2 demonstrates the application of these subjects. It gradually develops the formal specification of a ten-table database design that includes over seventy data integrity constraints. You'll also find a treatment of formal query and transaction specification in this part.
    • Part 3 is the Oracle specific part. You'll discover that due to poor support of declarative constraints, implementing these in today's SQL DBMS's still poses quite a few challenges. It demonstrates a method—based on database triggers—to implement (multi-row) constraints procedurally. This method has evolved for over 12 years; it is an efficient one and one that cannot be subverted.

     
    It is important to understand the mathematical foundation of our database profession. The knowledge contained in this book will, in the end, enable you to better design and implement databases

  • PeopleSoft for the Oracle DBA

    Book: 
    Image of PeopleSoft for the Oracle DBA (Oaktable Press)
    Author: David Kurtz
    Publisher: Springer (2004)
    Binding: Paperback, 406 pages

    A PeopleSoft Survival Guide for DBAs and other technicians

    A part of the OakTable Press series, PeopleSoft for the Oracle DBA, will teach you a range of techniques for maintaining a PeopleSoft system. You will then become able to implement techniques like indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. It provides answers to common questions that arise when using PeopleSoft on an Oracle database.

    The book begins with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Subsequent chapters explain database structures, connectivity, keys and indexing, the PeopleSoft DDL generation, tablespaces organisation, performance metrics, performance monitoring utilities, and SQL optimization techniques.

  • Troubleshooting Oracle Performance

    Book: 
    Image of Troubleshooting Oracle Performance (Expert's Voice in Oracle)
    Author: Christian Antognini
    Publisher: Springer (2008)
    Binding: Hardcover, 620 pages

    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.
     
    This book shows you how to do the following:

    • Identify performance problems using a systematic and repeatable approach.
    • Configure the query optimizer to meet your application performance goals.
    • Obtain and interpret execution plans as well as assess whether they are inefficient.
    • Apply SQL tuning techniques such as hints, SQL profiles, stored outlines and SQL plan baselines.
    • Minimize the impact of parsing without jeopardizing performance.
    • Optimize data access, joins and the physical design.
    • Improve performance through parallel processing, materialized views, and result caching.

    This book is intended for performance analysts, application developers and database administrators who are involved in troubleshooting performance problems of applications based on the Oracle database engine.
    No specific knowledge in optimization is required. However, readers are expected to have a working knowledge of the Oracle database engine and to be proficient with SQL.
     
     

  • Mastering Oracle PL/SQL: Practical Solutions

    Book: 
    Image of Mastering Oracle PL/SQL : Practical Solutions
    Author: David C. Knox, Joel R. Kallman, Christopher Beck, Connor McDonald
    Publisher: Springer (2004)
    Binding: Paperback, 652 pages

     This the first book of many to be published under the OakTable Press Label. The lead author, Connor McDonald is a respected member of the OakTable and is a well-known personality both on the Oracle speaker circuit and in online Oracle forums. This book is targeted primarily toward the DBA or developer charged with the implementation of effective data handling, security, and database administration mechanisms in the Oracle database. However, it will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL effectively.If you’re brand new to PL/SQL, then you’ll want to take some time to get familiar with the language before tackling this book

  • Expert One-on-One Oracle

    Book: 
    Image of Expert One-on-One Oracle (The Expert's Voice)
    Author: Thomas Kyte
    Publisher: APress (2003)
    Binding: Paperback, 1300 pages

     Tom Kyte's first book is packed with lots of Oracle insider knowledge including, among other topics, what the various Oracle server processes and files do, what's happening inside the database during a transaction, and the real meaning of the various options available in Oracle's DML and DDL SQL statements. The likely impact of design decisions on application behaviour and performance is also discussed, particularly where this relates to using, or not using, a database feature.