By David Kurtz
The latest addition to the OakTable Press sequence, PeopleSoft for the Oracle DBA, will educate you a number suggestions for protecting a PeopleSoft approach. you are going to then develop into in a position to enforce recommendations like indexing, imposing DDL, handling tablespaces, and solving low-performing SQL queries. writer David Kurtz is a box professional and offers solutions to universal questions that come up while utilizing PeopleSoft on an Oracle database. Kurtz starts the publication with an structure review, then proceeds to BEA Tuxedo, PeopleSoft's program server. Kurtz transitions easily among next chapters, explaining database constructions, connectivity, keys and indexing, the PeopleSoft DDL, and tablespaces.
Read or Download PeopleSoft for the Oracle DBA PDF
Best oracle books
This publication lias been written for the next audiences:■ Management-You could have bought Oracle9i for purposes except Java improvement in the database. in spite of the fact that, that allows you to recognize extra approximately Oracle9i Java beneficial properties, see "Overview of Oracle9i Java Documentation" on web page 1-23 for a administration standpoint.
There are few books out that care for Oracle textual content and XSQL. utilizing the methodologies, practices, and so on. i discovered no use to go looking for one more reference.
Oracle functionality Survival consultant a scientific method of Database Optimization the short, whole, start-to-finish consultant to optimizing Oracle functionality Oracle functionality Survival consultant deals a established, systematic, start-to-finish technique for optimizing Oracle functionality as successfully as attainable.
This self-study examination training advisor for the Oracle Database 10g Database Administrator OCP certification examination comprises every little thing you want to try out your self and go the examination. All examination issues are coated and insider secrets and techniques, entire factors of all Oracle Database 10g Database Administrator OCP topics, attempt methods and information, a variety of hugely practical pattern questions, and routines designed to reinforce figuring out of Oracle Database 10g Database Administrator OCP thoughts and get ready you for examination good fortune at the first try are supplied.
- Oracle GoldenGate 12c Implementer's Guide
- Oracle E-Business Suite development & extensibility handbook
- Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting
- Getting started with Oracle BPM Suite 11gR1 : a hands-on tutorial : learn from the experts--teach yourself Oracle BPM Suite 11g with an accelerated and hands-on learning path brought to you by Oracle BPM Suite Product Management team members
- Oracle ADF Enterprise Application Development - Made Simple
Extra resources for PeopleSoft for the Oracle DBA
PSDBOWNER with one row that describes that PeopleSoft database. Listing 3-4. PSDBOWNER VALUES('HR88', 'SYSADM'); UPDATE PSSTATUS SET OWNERID = 'SYSADM'; Note that while it is easy to populate the PSDBOWNER table from SYSADM, this user cannot delete or update those rows because the user only has SELECT privilege, and PS does not even have CONNECT privilege. PSDBOWNER table must exist in the target database before the import is run. Otherwise, the import process will be unable to create the table, because the PS schema does not have RESOURCE privilege any more.
A Tuxedo client making an initial WSL connection The client processes must be told where to find a WSL. They can be configured to load balance or fail over between multiple WSLs. WSL addresses and ports are configured in the Workstation Configuration Manager (Figure 2-7). Figure 2-7. qxd 10/25/04 1:59 PM Page 23 CHAPTER 2 ■ BEA TUXEDO: PEOPLESOFT’S APPLICATION SERVER TECHNOLOGY PeopleSoft delivers various server processes, and each new release of PeopleTools has introduced more. Some server processes are optional and need only be configured when particular functions are required.
Qxd 10/25/04 1:58 PM Page 13 CHAPTER 1 ■ AN OVERVIEW Developing and Administering PeopleSoft Systems The diagram of the PIA (Figure 1-6) illustrates the most important point about PeopleSoft systems: they comprise a chain of linked technologies that stretch between the user and the database. The database is fundamental to the entire structure. It must function efficiently, and it must itself be built upon solid foundations. However, as the PeopleSoft technology has evolved, additional tiers and various layers of software and infrastructure have been inserted between the user and the database.