SearchOracle.com Book Chapter Download Library

Here you can download free chapter excerpts from books written by highly-regarded Oracle gurus and authors. Check back to this page frequently as it's being regularly updated.

Here you can download free chapter excerpts from books written by highly-regarded Oracle gurus and authors. Check

back to this page frequently as it's being regularly updated.


TABLE OF CONTENTS

   Application Server
   Database Administration
   Data Warehousing and Business Intelligence
   E-Business Suite
   Grid Computing
   Languages
   Web services


Application Server
[ Return to Table of Contents ]

Oracle Application Server 10g administration handbook
This six-part series of chapter excerpts are taken from "Oracle Application Server 10g administration handbook," written by John Garmany and Don Burleson, courtesy of Osborne Oracle Press. This book is an architectural and technical reference on how to use Oracle Application Server 10g to Web-enable Oracle databases for application server systems. Each excerpt focuses on a different aspect of Oracle Application Server administration. Check back next week for a new excerpt:
1. Planning for installation
2. Managing the Oracle HTTP server
3. The Web Cache
4. Cache invalidation
5. Deploying applications using Enterprise Manager
6. Distributed Configuration Management


Database Administration
[ Return to Table of Contents ]

Oracle disk I/O tuning
This series of book excerpts is from the soon-to-be-released Rampant TechPress book "Oracle disk I/O tuning," written by Mike Ault. Each excerpt in this series focuses on a different aspect of disk I/O performance and optimization for Oracle databases. Check back frequently for new excerpts.
1. General disk architecture
2. Disk layout
3. Disk performance statistics
4. Disk capacity -- The two-edged sword
5. Optimizing ATA performance
6. ATA tuning in Linux, part 1
7. ATA tuning in Linux, part 2
8. ATA tuning in Linux, part 3
9. ATA tuning in Linux, part 4
10. ATA tuning in Windows
11. Tuning the SCSI interface in Windows
12. SCSI tuning under Linux and Unix
13. The SCSI bus, part 1
14. The SCSI bus, part 2
15. HP-UX SCSI tuning, part 1
16. HP-UX SCSI tuning, part 2
17. SCSI tuning under AIX
18. Automated storage management, part 1
19. Automated storage management, part 2
20. Automated storage management, part 3

Oracle SQL and index internals
This 12-part series of book excerpts are taken from soon-to-be-released "Oracle SQL and index internals," written by Kimberly Floss and Donald K. Burleson, courtesy of Rampant TechPress. This book explores important internal mechanisms within Oracle and illustrates the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Each excerpt focuses on a different aspect of Oracle10g CBO internals and SQL tuning optimization. Check back frequently for new excerpts:
1. High performing SQL -- where do you start?
2. New performance views to identify problem SQL
3. Identify the resource-intensive code
4. Tune the code/database for better performance
5. Methods for creating high-quality code
6. Know thy database
7. EXPLAIN and understand
8. Try different combinations
9. Revisit when necessary
10. And if you can't change the code...
11. Index rebuilds
12. Histograms and finding the poorly running SQL

Oracle Database 10g high availability with RAC, Flashback and Data Guard (Chapter 8)
Chapter 8, "Backup and recovery for high availability environments," helps dispel the myth that backing up a database is not an HA technique -- that backups are the fallback when the database has already gone down, is unavailable, and there is no other choice but to wait for the files to restore from a backup location. Instead, it explains how to get the most from an RMAN backup strategy, and not just for recovery but for assisting with load balancing, maintaining uptime and minimizing downtime, as well as chipping in with RAC and DG maintenance.
Take our Know-IT-all Quiz based on this chapter and get a chance to win a free copy of "Oracle Database 10g high availability with RAC, Flashback and Data Guard." NOTE: Prize drawing is now closed. Congratulations to Patrick M. and Karen R.!

Oracle Database 10g new features (Chapter 1)
Chapter 1, "Getting started," is the place to start in your effort to learn all about Oracle Database 10g. This chapter will first look at the "grid" and explain what it's all about. Then it moves on to explain how to upgrade to Oracle Database 10g. Specific topics covered include the "grid," upgrading to 10g, the SYSAUX tablespace and Automatic Storage Management (ASM).

Oracle9i: The complete reference (Chapter 2)
Chapter 2, "The dangers in a relational database," discusses some of the dangers that both developers and users need to consider when working with a relational database. Combine a relational database with a series of powerful and easy-to-use tools, as Oracle does, and the possibility of being seduced into disaster by its simplicity becomes real. Add in object-oriented and Web capabilities, and the dangers increase. Get help avoiding these dangers and learn the ten commandments of humane design in this chapter.

Optimizing Oracle performance (Chapter 1)
This introductory chapter, "Optimizing Oracle performance," discusses what you're doing wrong in performance tuning. It covers some of the root causes of performance issues, problems with commonly-used tuning techniques, requirements of a good method, advances in performance improvements, tools for analyzing response time, an overview of Method R -- a response-based performance improvement method that yields maximum economic value -- evaluation of effectiveness and more.

Effective Oracle by design (Chapter 7)
This is Chapter 7 from the McGraw-Hill/Osborne book "Effective Oracle by design" by Tom Kyte. Your application will live and die based on its physical implementation. Choose the wrong data structures, and performance will be crippled and flexibility limited. Choose the correct data structures, and you could have great performance. This chapter looks at some of the things you need to consider when designing your schema. It will then focus on table types, some useful index types, and finally, compression.
Also check out Tom Kyte's SearchOracle.com webcast, "Efficient schema design."

Oracle Database 10g new features: 12 new 10g features in a nutshell
Learn more about 10g's new features and enhancements with these 12 excerpts from the only 10g new features book yet published, "Oracle Database 10g new features" by Mike Ault, Daniel Liu and Madhu Tumma.

Introduction to Oracle design (Chapter 1)
This is Chapter 1 from the O'Reilly book "Oracle design" by Dave Ensor and Ian Stevenson. Performance usually makes or breaks a computer system, and design is central to good performance. If your database isn't well-designed from the start, it will be almost impossible for your applications to run efficiently. This chapter explains what is Oracle database design, offers a case study, takes a look at alternative methods and approaches, describes how to plan the design phase and outlines design tasks.


Data Warehousing and Business Intelligence
[ Return to Table of Contents ]

Crystal Reports 9 on Oracle (Chapter 3)
This is Chapter 3 from the McGraw-Hill Osborne Media book "Crystal Reports 9 on Oracle" by Marie Annette Harper. If you need help exploring connectivity options, then delve into optimization methods that can be implemented in the Crystal environment, including the use of SQL expressions and SQL commands. This download covers Oracle SQL basics as they relate to Crystal Reports.


E-Business Suite
[ Return to Table of Contents ]

Oracle E-Business Suite 11i: Implementing core financial applications (Chapter 1)
This is introductory Chapter 1 from the John Wiley & Sons book "Oracle E-Business Suite 11i: Implementing core financial applications" by Susan Foster. To implement Oracle E-Business Suite 11i as efficiently and effectively as possible, each and every Oracle project team member needs to understand the concepts of a successful business system and a software project. The concepts shared in this chapter hold true for any software project regardless of whether the organization is implementing or upgrading Oracle E-Business Suite 11i. Tune in to a SearchOracle.com webcast with "Oracle E-Business Suite 11i" author Susan Foster. Listen to the webcast now.

Oracle E-Business Suite 11i: Implementing core financial applications (Chapter 2)
This is Chapter 2 from the John Wiley & Sons book "Oracle E-Business Suite 11i: Implementing core financial applications." This chapter, entitled "Oracle applications navigation," explains how to navigate through an application, and be comfortable with the data entry and query capabilities. Tune in to a SearchOracle.com webcast with "Oracle E-Business Suite 11i" author Susan Foster. Listen to the webcast now.

Oracle E-Business Suite Manufacturing & Supply Chain Management (Chapter 8)
This is Chapter 8 from the McGraw-Hill book "Oracle E-Business Suite Manufacturing & Supply Chain Management" by Bastin Gerald, Nigel King and Dan Natchek. The Oracle Applications suite currently offers two products for material and capacity planning in a manufacturing or distribution environment: Master Scheduling/MRP (MRP) offers single-organization, unconstrained planning of material and resources. Advanced Supply Chain Planning (ASCP) is the next-generation planning tool; it offers multiorganization planning and the option of constraint-based and optimized plans. This chapter, entitled "Planning fundamentals," describes the basic logic common to both planning methods and details the common setup needed by both methods.


Grid Computing
[ Return to Table of Contents ]

Grid computing: Making the global infrastructure a reality (Chapter 11)
This is Chapter 11 from the John Wiley & Sons book "Grid computing: Making the global infrastructure a reality," edited by Fran Berman, Geoffrey Fox and Tony Hey. Entitled "Condor and the grid," it describes how computer scientists were working to access to large amounts of computing power since the 1960s. But, in the early days, researchers noticed that distributed computing would be difficult; messages would be lost, corrupted or delayed, and precise algorithms had to be used to build an understandable system. It wasn't long after that the Condor project was born: a new system for distributed computing created by Miron Livny at the University of Wisconsin. Tune in to a SearchOracle.com webcast with "Grid computing" editor Geoffrey Fox. Listen to the webcast now.

The Grid: Blueprint for a new computing infrastructure (Chapter 2)
This is Chapter 2 from the Morgan Kaufmann book "The Grid: Blueprint for a new computing infrastructure" by Ian Foster and Carl Kesselman. In this introductory chapter, entitled "Computational grids," the authors provide a detailed picture of the expected purpose, shape and architecture of future grid systems. It is structured according to six questions: Why do we need computational grids? What types of applications will grids be used for? Who will use grids? How will grids be used? What is involved in building a grid? And, what problems must be solved to make grids commonplace?


Languages
[ Return to Table of Contents ]

Oracle SQL and index internals
This 12-part series of book excerpts are taken from soon-to-be-released "Oracle SQL and index internals," written by Kimberly Floss and Donald K. Burleson, courtesy of Rampant TechPress. This book explores important internal mechanisms within Oracle and illustrates the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Each excerpt focuses on a different aspect of Oracle10g CBO internals and SQL tuning optimization. Check back frequently for new excerpts:
1. High performing SQL -- where do you start?
2. New performance views to identify problem SQL
3. Identify the resource-intensive code
4. Tune the code/database for better performance
5. Methods for creating high-quality code
6. Know thy database
7. EXPLAIN and understand
8. Try different combinations
9. Revisit when necessary
10. And if you can't change the code...
11. Index rebuilds
12. Histograms and finding the poorly running SQL

Programming Oracle triggers and stored procedures (Chapter 3)
This is Chapter 3 from the Prentice Hall Professional Technical Reference book "Programming Oracle triggers and stored procedures" by Kevin Owens. It is one of several chapters that covers how to enforce business rules with constraints. Declarative constraints provide a core and traditional strategy for business rule enforcement. This chapter explains the how and why of declarative constraints.

Crystal Reports 9 on Oracle (Chapter 3)
This is Chapter 3 from the McGraw-Hill Osborne Media book "Crystal Reports 9 on Oracle" by Marie Annette Harper. If you need help exploring connectivity options, then delve into optimization methods that can be implemented in the Crystal environment, including the use of SQL expressions and SQL commands. This download covers Oracle SQL basics as they relate to Crystal Reports.

Analytical processing with Oracle SQL (Chapter 9)
This is Chapter 9 from the 2002 Addison-Wesley book "Oracle SQL & PL/SQL Handbook" by John Palinski. This chapter, entitled "Analytical processing with Oracle SQL," discusses Oracle analytic functions and their place in developing business intelligence and data warehousing solutions.

XML for data architects: Designing for reuse and integration (Chapter 8)
This is Chapter 8 from the Morgan Kaufmann book "XML for data architects: Designing for reuse and integration" by James Bean. This chapter, entitled "W3C XML schemas and reuse," explains what reuse is all about -- a concept that is often misunderstood in information technology -- and describes the syntactical and functional capabilities afforded by W3C XML schemas, which provide support and opportunities for metadata reuse.

PL/SQL: What, when, and where (Chapter 1)
This is Chapter 1 from the O'Reilly book "Learning Oracle PL/SQL" by Bill Pribyl and Steven Feuerstein. This chapter offers an introductory look at Procedural Language/Structured Query Language (PL/SQL), explaining what it really is, what it is good for and how it fits into the world.

PERL meets Oracle (Chapter 1)
This is Chapter 1 from the 2002 O'Reilly book "PERL for Oracle DBAs" by Andy Duncan and Jared Still. Perl is the world's number one solution for transforming and gluing data together, and Oracle is the world's number one solution for storing that data. How do Oracle DBAs, developers, and users take advantage of everything that Perl has to offer? This chapter sets the scene by introducing you to Perl and how it connects to Oracle.

PL/SQL control structures: Best practices (Chapter 4)
This is Chapter 4 from the O'Reilly book "Oracle PL/SQL best practices" by Steven Feuerstein. It identifies a range of PL/SQL constructs that allow you to control the flow of processing -- including the IF statement, FOR, WHILE and simple loops, and the GOTO statement -- and details several best practices you should take into account when you work with these kinds of statements.

Working with queries at runtime (Chapter 14)
This is Chapter 14 from the McGraw-Hill book "Oracle 9i JDeveloper Handbook" by Peter Koletzke, Dr. Paul Doresey and Dr. Avrom Faderman. This chapter, entitled "Working with queries at runtime," gives a detailed technical explanation on how to code directly to the BC4J API, how to access an application module and view usages, how to use those usages to retrieve, update and insert data and more.


Web services
[ Return to Table of Contents ]

Oracle9i Web development (Chapter 3)
This is Chapter 3 from the McGraw-Hill/Osborne book "Oracle9i Web development" by Bradley D. Brown. Entitled "iAS configuration and tuning," this chapter explains why configuring iAS requires an understanding of the configuration of the Apache Web server and its various modules, such as mod_jserv and mod_plsql. To take advantage of features in iAS while maximizing performance, the iAS administrator should be well versed in all the features, and their associated costs and benefits. This chapter will help you understand those features, and explains configuration and tuning techniques.
Take our Know-IT-all Quiz to test what you've learned in this chapter.

XML for data architects: Designing for reuse and integration (Chapter 8)
This is Chapter 8 from the Morgan Kaufmann book "XML for data architects: Designing for reuse and integration" by James Bean. This chapter, entitled "W3C XML schemas and reuse," explains what reuse is all about -- a concept that is often misunderstood in information technology -- and describes the syntactical and functional capabilities afforded by W3C XML schemas, which provide support and opportunities for metadata reuse.


Last updated: June 10, 2004

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close