Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you'll find that there are few information managem ent problems that you cannot solve quickly and elegantly. This fully revised second edition covers the latest developments in Oracle Database 11g. 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.

Covering all areas of Oracle Grid computing, this guide is indispensable for any Oracle DBA who is charged with configuring and implementing Oracle 11g Grid with server blades. This comprehensive manual presents a complete method for the installation, configuration and design of Oracle Grid and 11g RAC. It supplies expert internals of shared disk technology, raw devices and RAID, and exposes the internal configuration methods for server blades. Also demonstrated is the use of Oracle Grid using t he Enterprise Manager Grid control utility.

The Topics Covered In This Book Are: Visualizing the Complete Oracle Environment, SQL: Structured Query Language, Oracle Database Concepts, Oracle Instance Concepts, Oracle in Action, Complete Oracle System Design: Steps of Implementation, Oracle Database Design, Oracle Network Administration, Oracle Database Management, Oracle Backup & Recovery Techniques, Oracle Performance Tuning. Everything in this book is covered in a step by step manner by first building reader s concept using analogi es, real world examples and then taking him/her to the steps of design implementation. The book covers Oracle 10g Database Administration for both Unix as well as Windows OS. The concepts and most of the stuff discussed in this book are equally good for other Oracle versions including 11g.

The Essential Resource for Oracle DBAs--Fully Updated and Expanded. Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and rec overy process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces. Optimize disk allocation, CPU usage, I/O throughput, and SQL queries. Develop powerful database management applications. Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management. Diagnose and tune system performance using Oracle Automatic Workload Repository and SQ L Tuning Sets. Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control. Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard. Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor. Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import. Work with ne tworked databases, data warehouses, and VLDBs. Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more.

The Essential Resource for Oracle DBAs--Fully Updated and Expanded. Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and rec overy process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces. Optimize disk allocation, CPU usage, I/O throughput, and SQL queries. Develop powerful database management applications. Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management. Diagnose and tune system performance using Oracle Automatic Workload Repository and SQ L Tuning Sets. Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control. Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard. Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor. Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import. Work with ne tworked databases, data warehouses, and VLDBs. Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more.

Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management. Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource, written by a team of database experts. Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Ins ide, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance.

Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management. Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource, written by a team of database experts. Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Ins ide, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance.

Physical Database Design Using Oracle correlates logical data models with the physical implementation structures that Oracle provides. It allows students to learn how to take logical data models and convert them into a series of data structures that permit fast and easy logical access to data. This textbook is targeted at undergraduate and graduate IS students studying to become the Oracle professionals of the near future. It is expected that they already have exposure to basic Oracle database a dministration. The expert guidance provided by this textbook provides the insight needed to choose appropriate physical models for mission-critical applications.

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly. Each feature is taught in a proof-by-example manner, n ot only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book. Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focus es solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you. In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.

Physical Database Design Using Oracle correlates logical data models with the physical implementation structures that Oracle provides. It allows students to learn how to take logical data models and convert them into a series of data structures that permit fast and easy logical access to data. This textbook is targeted at undergraduate and graduate IS students studying to become the Oracle professionals of the near future. It is expected that they already have exposure to basic Oracle database a dministration. The expert guidance provided by this textbook provides the insight needed to choose appropriate physical models for mission-critical applications.

Refined to focus on the newest and most important practical features in Oracle Database 10g, this new edition of the most popular Oracle book of all time will thoroughly cover the most meaningful aspects with a straightforward combination of prose, conceptual diagrams, and code listings.

Revealing the secrets for quickly implementing and tuning Oracle RAC database systems, this book covers all areas of Oracle Real Application Clusters including Oracle10g new features. Oracle DBAs who are charged with configuring and implementing a RAC clusters database will benefit from this complete guide to the installation as well as configuration and design of Oracle Real Application Clusters. Information is supplied on expert internals of shared disk technology, raw devices and RAID with RA C, the internal concurrency, resource coordination, and the locking mechanism within RAC. Also explained are Transparent Application Failover (TAF) and monitoring and tuning Oracle10g RAC applications.

Grid Computing has at its foundation the necessity that all computing components be readily available at all times, so they can be used when needed. Therefore, the ultimate success of any grid implementation must have at its core the resources to always be up. As such, the Oracle's High Availability offerings are a central component to its future strategy. This will be the first comprehensive book available on this core topic.

The new edition of this classic book, Oracle Essentials 3rd Edition: Oracle Database 10g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database. Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more. Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracl e's Database 10g--the industry's first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered. More comprehensible than a large reference, and more detailed than mot primers, this book covers all the information you'll need to install and run the Oracle databases, as well as the conceptual background you'll want to understand how they work. If you're new to Oracle or upgrading to Oracle 10g, you'll find this all-in-one guide essential.

For those database administrators intending to upgrade or those who need to know the new features that will affect the entire Oracle database world, this book relates all of the features of this new database. The complete details of the database's new features, including database management and administration enhancements, are discussed. Improvements and additions to security, architecture, Internet features, real application clusters, and performance are also detailed.

A reference for RAC and TAF technology, this book demonstrates how to optimize Oracle clustered server environment for optimal performance and flexibility. Covering all areas of RAC continuous availability and transparent application failover, this book is indispensable for any Oracle DBA who is charged with configuring and implementing a RAC clusters database. Described are the secrets for successful design of RAC clusters and the expert internals of shared disk technology, raw devices and RAID with RAC. Exposed is the internal concurrency and PCM locking mechanisms within RAC and the configuration of Transparent Application Failover is explained. Also provided are tips for monitoring and tuning RAC applications as well as tricks for using Oracle9i RAC Cluster Guard.

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: s cope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book. Kyte - it's very tempting to call him an Oracle oracle - seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is em inently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment - and alternative ways of looking at the more familiar ones - solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Orac le databases.

Oracle database administration goes far beyond installation and tuning of the database - topics covered by the majority of books on the market. As DBAs become more involved in the business process, architecture, and planning, there may be more to do up front, but the end result is less chaotic. To better prepare those who are up to the new eBusiness challenges, the chapters in this book have been organized with information to not only provide IT professionals with information that can be applied for a more challenging and successful career, but also for those companies who are trying to attract and retain them.

A lot of books seem to give canned explanations of how oracle works - geared towards rote memorization as opposed to understanding. This book does a great job of taking the next step. For example, The detail with which the author goes through the process of how updating a row actually works in an Oracle database was tremendous. His explanation of how a select statement could actually cause a row to be marked as committed ( i.e. a read causes a write ) was great. I've only been a DBA (or pseudo-D BA) for about 6 months now, so I'm certainly no expert in this area. Yet I found all of his explanations very clear and easy to understand. If you're looking for a new Oracle book, get this one.

A soup-to-nuts guide to building and managing high-performance Oracle8i data warehouses In an effort to help companies manage what Information Week has referred to as the "Web Data Deluge," Oracle has released Oracle8i (the "i" stands for "Internet"), a major upgrade to their flagship database product that provides powerful new data warehousing capabilities. In this updated and expanded edition of their critically acclaimed Oracle8 Data Warehousing, Gary Dodge and Tim Gorman provide database dev elopers and administrators with complete, detailed coverage of all they need to know to build and manage a fast, high-performance data warehouse using the Oracle8i technology. Step-by-step, they cover all the bases, including designing a data warehouse for optimum performance, building a data warehouse, loading data into the data warehouse, improving warehouse performance with aggregate data, and administering data warehouse performance.

As open systems continue to replace traditional mainframe systems, system scalability is becoming an increasingly important topic. Although far more flexible than mainframe systems, open systems applications tend to be less reliable and more difficult to scale. There is no cookbook approach to solving this challenge: A thorough understanding of the technologies involved is essential for designing scalable solutions that meet long-term business needs. Scaling Oracle8i(tm) offers valuable insights and techniques for designing reliable and scalable online transaction processing (OLTP) applications using Oracle. This book focuses on providing the in-depth information about Oracle and the underlying hardware required to build systems that scale effectively. You will find coverage of relevant hardware and I/O operation; benchmark and database monitoring systems; Oracle internals, operation, and implementation; and UNIX operating system issues that impact Oracle performance and scalability.

Time-tested information--Strategies come straight from an Oracle DBA who's worked in the trenches for the Quatar Government keeping systems online 24x7. 8i Coverage--Version 8i's web functionality makes working in 24x7 mode available to a wider spectrum of corporations. Specific discussions--Covers areas of database installation, configuration, and management of security, performance, and recoverability. Diagnostic and database monitoring scripts--Scripts can be deployed immediately to help DBAs achieve high-availability databases.

Most organizations that use the Oracle relational database management system (RDBMS) these days need to use multiple databases. There are many reasons to use more than a single database in a distributed database system: Different databases may be associated with particular business functions, such as manufacturing or human resources. Databases may be aligned with geographical boundaries, such as a behemoth database at a headquarters site and smaller databases at regional offices. Two different d atabases may be required to access the same data in different ways, such as an order entry database whose transactions are aggregated and analyzed in a data warehouse. A busy Internet commerce site may create multiple copies of the same database to attain horizontal scalability. A copy of a production database may be created to serve as a development test bed.

Data warehouses store millions of records, allowing managers to ask the big-picture questions about their businesses. The authors of Data Warehouse Design Solutions share their expertise in designing successful data warehouses and concentrate on understanding business processes within a variety of industries. First, the authors outline the promise--and potential hurdles--of data warehousing. They thoroughly explain the idea of dimensional data, which is used to represent the quantities or attrib utes that can be queried in a data warehouse. The authors argue that data warehouses need to adapt to changing business conditions and often must be more flexible than planned. They advise building the Enterprise Data Warehouse (EDW) as a series of interlocking data marts (which contain different dimensions). Developers can build part of a solution and add new data marts later. The result is a more adaptable approach to warehousing data. The heart of Data Warehouse Design Solutions is the descri ptions of data warehouses tailored to specific industries--sales, marketing, fulfillment, production, inventory, and capacity--using real-world businesses. The authors offer business models, sample dimensions, database schema, and sample reports for each business area. Later chapters discuss more advanced areas for data warehousing, including budget tracking, financial reporting (and managerial accounting), and even how to look at profitability and intellectual capital. The authors round out the ir nuts-and-bolts tour of today's businesses with a summary of the various measures that fit each type of organization. Finally, the authors come back to theory, with some ideas on building effective systems that are fast and that generate easy-to-read reports. The last chapter argues convincingly that their incremental approach to building data warehousing has some distinct advantages.

The book design has two primary goals. First, the book is a basic/intermediate level presentation of the primary concepts and software architecture of Oracle8. After reading this book, any type of Oracle8 user will have a solid, big-picture understanding of how Oracle8 fits into the world of serious data management applications. Second, the book is an excellent planning guide that will help a current Oracle user server to migrate Oracle7 databases and corresponding database server administrators and application developers need to understand to work with Oracle8.

2001-2011 Oracle-Books.com