Peoplesoft for the Oracle DBA
A PeopleSoft Survival Guide for Oracle DBAs
David Kurtz, Wolfgang Breitling - Collection The Expert's Voice in PeopleSoft
Résumé
BOOKS FOR PROFESSIONALS BY PROFESSIONALS®
OakTable Press
Apress and the OakTable Network have joined forces to define a radical new direction in Oracle publishing: the OakTable Press. Apress is dedicated to bringing you the insights and experience of acknowledged experts in their field. The OakTable Network is a group of renowned Oracle scientists, dedicated to finding ever better ways of administering and developing Oracle-based systems. Together, we provide books that are rigorous and accurate, that solve real problems, challenge accepted wisdom, and inspire innovation.
PeopleSoft for the Oracle DBA
This book is a survival guide for the Oracle DBA who is responsible for the configuration, administration, and performance of a PeopleSoft system. The database is at the core of any such system, but the DBA must also understand how the PeopleSoft application is using the database and how other parts of the PeopleSoft architecture interact with the database. Therefore, this book
- Demonstrates how to effectively implement common Oracle database administration techniques and strategies (indexing, DDL, managing tablespaces, and so on) specifically for a PeopleSoft system, using the PeopleSoft toolset
- Shows how to analyze application activity and obtain the critical data that will allow you to track down the causes of poor performance
- Provides essential details on the configuration and tuning of the Tuxedo Application Server and how it works with the database
This book is a reflection of what I have been doing most days for many years: helping customers get sufficient performance out of their PeopleSoft business systems. It provides the answers to the questions that I am still repeatedly asked by DBAs, developers, and end users about what is going on inside these systems, for example:
- How do I measure what part of the application response time is spent in which tier of the system, and thus determine whether the database or another tier is the most significant performance issue?
- Who is running this piece of SQL, where does it come from, and what can I do about it?
- What changes can I safely make to the system via the PeopleSoft development tools, without creating an administrative nightmare? Ultimately, I hope this book will demonstrate how an Oracle DBA can work effectively with PeopleSoft, instead of continually fighting against it.
L'auteur - David Kurtz
DAVID KURTZ studied physics at the University College London. He has worked with Oracle since 1989, spending six years as an Oracle developer and DBA working on assurance, insurance, and actuarial software. In 1996 he joined PeopleSoft, starting out in support and moving into consultancy. In 2000 he set up Go-Faster Consultancy Ltd. (www.go-faster.co.uk), an organization that provides specialist performance and technical consultancy to PeopleSoft users.
A member of the UK Oracle User Group since 1994, David became chairman of the Unix SIG in 2000. He presents regularly at PeopleSoft and Oracle user group conferences and SIG meetings. He is also a member of the OakTable network (www.oaktable.net).
Sommaire
- Foreword
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- An Overview
- BEA Tuxedo: PeopleSoft's Application Server Technology
- Database Connectivity
- PeopleSoft Database Structure: A Tale of Two Data Dictionaries
- Keys and Indexing
- PeopleSoft DDL
- Tablespaces
- Locking, Transactions, and Concurrency
- Performance Metrics
- PeopleTools Performance Utilities
- SQL Optimization Techniques in PeopleSoft
- Configuring the Application Server
- Tuning the Application Server
- The Process Scheduler
- Index
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Apress |
| Auteur(s) | David Kurtz, Wolfgang Breitling |
| Collection | The Expert's Voice in PeopleSoft |
| Parution | 29/12/2004 |
| Nb. de pages | 433 |
| Format | 17,5 x 23,5 |
| Couverture | Broché |
| Poids | 731g |
| Intérieur | Noir et Blanc |
| EAN13 | 9781590594223 |
| ISBN13 | 978-1-59059-422-3 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
