CHAPTER 6PeopleSoft DDL
So far I have described how the PeopleSoft and Oracle data dictionaries are related, and how the specification of keys on PeopleSoft records controls both the SQL that is generated by the panel processor and the indexes that are built.
This chapter describes how the Application Designer dynamically builds DDL statements, and in particular where some of the physical attributes are defined and how these models can be enhanced to handle some, but not all, Oracle features. This chapter also covers additional PeopleTools tables that correspond to parts of the Oracle catalogue.
PeopleSoft DDL and the DBA
DBAs will usually have a range of responsibilities, including managing growth and change (capacity planning) and performance ...
Get PeopleSoft for the Oracle DBA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.