PeopleSoft for the Oracle DBA

Author: David Kurtz

Publisher: Apress

ISBN:

Category: Computers

Page: 548

View: 102

PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment. You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment. Explains PeopleSoft’s technical architecture as it relates to Oracle Database Demonstrates how to instrument and measure the performance of PeopleSoft Provides techniques to troubleshoot and resolve performance problems What you’ll learn Understand PeopleSoft’s technical architecture and the structure of a PeopleSoft database Measure performance of the various tiers in the application Pinpoint and resolve performance problems within the code Configure server processes for optimal performance Monitor and manage your PeopleSoft installation using Oracle Enterprise Manager Take full advantage of the PeopleTools Performance Monitor that is new in version 8.44 Who this book is for PeopleSoft for the Oracle DBA is written for database administrators charged with supporting a PeopleSoft system, and especially those administrators responsible for troubleshooting and resolving PeopleSoft performance issues. PeopleSoft for the Oracle DBA also appeals to PeopleSoft administrators and developers who desire a better understanding of how PeopleSoft functions in an Oracle Database environment. Table of Contents 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 PeopleSoft Performance Utilities SQL Optimization Techniques in PeopleSoft Configuring the Application Server Tuning the Application Server The Process Scheduler

Oracle Applications DBA Field Guide

Author: Paul Jackson

Publisher: Apress

ISBN:

Category: Computers

Page: 264

View: 845

Expert guidance on administering the highly complex Oracle E-Business Suite Time-proven best practices Tried and tested scripts, notes, and references Covers all vital admin tasks, including configuration, monitoring, performance tuning, troubleshooting, and patching

Expert Oracle JDBC Programming

Author: R.M. Menon

Publisher: Oaktable Press

ISBN:

Category: Computers

Page: 708

View: 501

* First book on the market that covers building high-performance Java applications on the Oracle database--using the latest versions of both the Oracle database (10g) and the JDBC API (3.0). * Promotes and explains an "anti black box" approach to Oracle development complete with benchmark code) that will allow developers to write highly efficient, high performance Oracle JDBC applications. * A new book from the prestigious OakTable Press, which Apress will be strongly promoting and supporting throughout 2004.

PeopleSoft PeopleTools Data Management and Upgrade Handbook

Author: Paula Dean

Publisher: McGraw Hill Professional

ISBN:

Category: Computers

Page: 352

View: 428

Master Oracle’s PeopleSoft PeopleTools Data Administration and Upgrade Toolset Maximize data integrity, maintain peak application performance, and keep your PeopleSoft environment up to date. PeopleSoft PeopleTools Data Management and Upgrade Handbook explains the latest techniques and provides best practices, case studies, and programming examples. Find out how to develop and deploy data mover scripts, audit database health, apply patches, and generate project comparison reports. This Oracle Press guide offers thorough coverage of Oracle’s PeopleSoft life cycle management tools. Understand PeopleSoft PeopleTools architecture Manage metadata using PeopleSoft Application Designer Create and execute PeopleSoft Data Mover scripts Learn how to use PeopleSoft Data Archive Manager Read best practices for applying updates, patches, and fixes Implement PeopleSoft change control features Build automated functional tests Plan and execute application and platform upgrades

Pro Peoplesoft Database Administration

Author: David Kurtz

Publisher:

ISBN:

Category:

Page: 456

View: 924

The newest addition to the OakTable Press series, Pro PeopleSoft Database Administration, 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. Author, Kurtz, is a field expert and thus, provides answers to common questions that arise when using PeopleSoft on an Oracle database.Kurtz begins the book with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Kurtz transitions smoothly between subsequent chapters, explaining 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 R12 Applications DBA Field Guide

Author: Elke Phelps

Publisher: CreateSpace

ISBN:

Category: Computers

Page: 282

View: 269

Oracle R12 Applications DBA Field Guide is the second edition of the guide updated to provide the details needed to administer Oracle E-Business Suite Release 12. The book includes guidelines and references to guide you through the management and deployment of Oracle Applications Release 12. Included in the guide are topics ranging from architecture, configuration, installation, cloning, patching, monitoring, troubleshooting to performance tuning. The new edition provides essentials for administering the updated Applications tier and technology stack, including Oracle 10gAS and Oracle Database 11g. Even for the experienced database administrator, Oracle Applications are complicated to administer, and most documentation that is available is difficult to find and understand. Whether you're an experienced Oracle Applications DBA or a new to Oracle Applications, (perhaps experienced with PeopleSoft, JD Edwards, or Siebel), this book will enable and ease the administration and efficiency of your day-to-day tasks.

Network World

Author:

Publisher:

ISBN:

Category:

Page: 48

View: 102

For more than 20 years, Network World has been the premier provider of information, intelligence and insight for network and IT executives responsible for the digital nervous systems of large organizations. Readers are responsible for designing, implementing and managing the voice, data and video systems their companies use to support everything from business critical applications to employee collaboration and electronic commerce.

Informationweek

Author:

Publisher:

ISBN:

Category: Computer service industry

Page:

View: 643

Computerworld

Author:

Publisher:

ISBN:

Category:

Page: 124

View: 493

For more than 40 years, Computerworld has been the leading source of technology news and information for IT influencers worldwide. Computerworld's award-winning Web site (Computerworld.com), twice-monthly publication, focused conference series and custom research form the hub of the world's largest global IT media network.

Computerworld

Author:

Publisher:

ISBN:

Category:

Page: 104

View: 110

For more than 40 years, Computerworld has been the leading source of technology news and information for IT influencers worldwide. Computerworld's award-winning Web site (Computerworld.com), twice-monthly publication, focused conference series and custom research form the hub of the world's largest global IT media network.

Dataquest

DQ.

Author:

Publisher:

ISBN:

Category: Computer software

Page:

View: 661

IBM DB2 9.7 Advanced Administration Cookbook

Author: Adrian Neagu

Publisher: Packt Pub Limited

ISBN:

Category: Computers

Page: 480

View: 387

This cookbook has recipes written in a simple, easy to understand format, with lots of screenshots and insightful tips and hints. If you are a DB2 Database Administrator who wants to understand and get hands on with the underlying aspects of database administration, then this book is for you. This book assumes that you have a basic understanding of DB2 database concepts.

Essential Guide to PeopleSoft Development and Customization

Author: Tony DeLia

Publisher: Manning Publications Company

ISBN:

Category: Computers

Page: 1074

View: 241

This practical guide for both novice and experienced programmers includes details on design and development in a project life cycle. Online and batch development are also covered. This guide also provides customization alternatives of delivered online applications through real examples. Authors include Galina Landres, Isidor Rivera, and Prakash Sankaran.

Oracle Data Guard 11gR2 Administration Beginner's Guide

Author: Emre Baransel

Publisher: Packt Publishing Ltd

ISBN:

Category: Computers

Page: 404

View: 321

Using real-world examples and hands-on tasks, Oracle Data Guard 11gR2 Administration Beginner's Guide will give you a solid foundation in Oracle Data Guard. It has been designed to teach you everything you need to know to successfully create and operate Data Guard environments with maximum flexibility, compatibility, and effectiveness.If you are an Oracle database administrator who wants to configure and administer Data Guard configurations, then "Oracle Data Guard 11gR2 Administration Beginner's Guide" is for you. With a basic understanding of Oracle database administration, you'll be able to easily follow the book.

E-Business for the Oracle DBA

Author: Meghraj Thakkar

Publisher: Que Publishing

ISBN:

Category: Computers

Page: 361

View: 569

This book focuses on discussing the issues that a DBA would face in extending existing systems for eBusiness. The book also discusses how DBAs can prepare themselves for the challenge. An example business 'DOeBIZ Corporation' is used to help the reader understand the various issues involved and how an Oracle DBA can deal with them.

Oracle 11G Administration In Simple Steps

Author: Kogent Solutions Inc.

Publisher: Dreamtech Press

ISBN:

Category:

Page: 264

View: 778

This book contains the step by step information about the Oracle 11g database Administration. This book is for you if you are familiar with SQL and are looking for a book that effectively explains the concepts of the Oracle 11g database Administration. It gives the core information about administrating the Oracle 11g database using the new and improved Enterprise Manager GUI. The book contains lots of examples and helps you to perform the Oracle 11g administration in an easier way. You will also find information about the Grid Architecture in this book.

Business 2.0

Author:

Publisher:

ISBN:

Category: Electronic commerce

Page:

View: 916

Mastering Oracle SQL and SQL*Plus

Author: Lex deHaan

Publisher:

ISBN:

Category: Computers

Page: 468

View: 117

*Ideal for anyone who wants to learn SQL programming for Oracle database. *Author has 25 years of teaching experience; 14 years of curriculum develoment experience; 14 years of experience with the Orcle database. *Book can be used as collateral/handouts for SQL training courses at universities/ high schools.

Everyday Oracle DBA

Author: April Wells

Publisher: McGraw-Hill Osborne Media

ISBN:

Category: Computers

Page: 344

View: 561

A guide to the administration of an Oracle database covers such topics as user management, database setup, backup, PL/SQL, and restoration.