Sumário Itens Encontrados: 288ForewordCHAPTER 1 An Overview. 1CHAPTER 2 BEA Tuxedo: PeopleSoftâs Application ServerTechnology 15CHAPTER 3 Database Connectivity 31CHAPTER 4 PeopleSoft Database Structure: A Tale of Two DataDictionaries 55CHAPTER 5 Keys and Indexing 87CHAPTER 6 PeopleSoft DDL 115CHAPTER 7 Tablespaces 149CHAPTER 8 Locking, Transactions, and Concurrency 163CHAPTER 9 Performance Metrics 171CHAPTER 10 PeopleTools Performance Utilities 229CHAPTER 11 SQL Optimization Techniques in PeopleSoft. 263CHAPTER 12 Configuring the Application Server 315CHAPTER 13 Tuning the Application Server 359CHAPTER 14 The Process Scheduler 387INDEX. 407CHAPTER 1 An Overview 1What Is PeopleSoft? 1Components of a PeopleSoft System 2The Database 3Tuxedo Application Server 4PeopleTools 4Evolution of the PeopleSoft Architecture 6The Monolithic Mainframe 6Client/Server Architecture 7Three-Tier Architecture. 8Four-Tier Architecture 10Release History 10Developing and Administering PeopleSoft Systems 13The Developer 13The DBA. 13Relationship Between the Developer and DBA 14Summary 14What Is Tuxedo?. 15The Simple Application Server 18The Simple Client. 18The Simple Server 20The Simple Tuxedo Domain 20vAnatomy of the Application Server 21Processes, Memory, and Messages 21IPC Resources 25tmadmin and ipcs 27PIA Servlets. 28Summary 29CHAPTER 3 Database Connectivity. 31PeopleSoft Database vs. Oracle Database 31Oracle Database Users 32Owner ID/Access ID (SYSADM) 32Connect ID (PEOPLE) 32PS Schema 33Oracle Database Roles 34PSUSER Role. 35PSADMIN Role 35Signing On to a PeopleSoft 8 Database. 37Making the Initial Connection 38Determining the PeopleSoft Schema 43Checking the PeopleTools Release 44Checking the Operator Password 45Obtaining the Access Password 46Reconnecting As Access ID 46Using PeopleSoft Access Profiles and Oracle Resource Profiles 47Signing On to a PeopleSoft 7.5 Database 50Connecting Third-Party Applications 52Crystal Reports. 52SQR Reports 52Changing Database Passwords. 52Connect ID Password 52Owner ID Password 53Summary 53Two Data Dictionaries. 57PSRECDEFN: Record Definition 58PSRECFIELD: Record Field Definition 61PSDBFIELD: Field Definition 64PSSQLDEFN: Definition of SQL Objects 69PSSQLTEXTDEFN 70PSINDEXDEFN: Index Definition. 70PSKEYDEFN: Index Definition. 72Recursive PeopleTools SQL 73Version Numbers and Caching 75Component Definition 75Search Record 76Case-Insensitive Searching 77Component Pages 77Component PeopleCode 78Page Definition 79Page Fields 79Record Definition 80Field Definitions 80Sub-Records. 81Field Labels. 81Record DDL. 82Sub-Record Definition. 83Application SQL 83Data Dictionary Synchronization. 84Summary 86CHAPTER 5 Keys and Indexing 87What Is the Purpose of an Index? 87What Is a Constraint? 88What Is the Purpose of a Unique Constraint? 89Record Field Key Attributes 90Field Attributes and Application Behavior 91Field Attributes and System Index Definitions. 95Custom Key Order 105User-Defined Indexes 106Other Index Issues. 107Views, Keys, and Indexing 107Suppressing Index Creation 109Indexes and Histograms 111Null Columns in PeopleSoft 111Summary 113CHAPTER 6 PeopleSoft DDL. 115PeopleSoft DDL and the DBA. 115DDL Models 116Create Table 117Create Index 119Create Tablespace 120Analyze Table Estimate Statistics 121Analyze Table Compute Statistics 123Sizing Sets 124Overriding DDL Model Defaults. 124Application Designer 124Data Mover 126PeopleTools Tables 126PSDDLMODEL (or PS_DDLMODEL_VW):DDL Model Statement. 127PSDDLDEFPARMS (or PS_DDLDEFPARMS_VW):DDL Model Parameter. 127PSRECDDLPARM: Record DDL Parameter 127PSTBLSPCCAT: Tablespace Catalogue 128PSRECTBLSPC: Record Tablespace Allocation 128PSIDXDDLPARM: Index DDL Parameters 129DDL Model Enhancements. 129Additional DDL Parameters 129Fewer DDL Parameters. 132Multiple Commands 132Global Temporary Tables. 135Limitations of PeopleSoft DDL Models. 137Partitioned Tables. 137Constraints 138Function-Based Indexes 138Index Organized Tables 139Other DDL 140Alter Table in Place 140Alter Table by Re-creation 141Views 142PeopleSoft Temporary Tables. 143Triggers 144Synchronizing PeopleSoft with the Oracle Catalogue 145Feeding Back Tablespaces into PeopleTools 147Summary 148Database Creation. 149Supplied Database Creation Scripts 149Oracle9i Database Configuration Assistant 152PeopleSoft Database Configuration Wizard 154Managing Tablespaces for PeopleSoft 155A Single Index Tablespace: PSINDEX 157Tablespace Creation and Default Storage Options. 159Implementing Local Tablespace Management 159Summary 162Locking 163PIA Transactions. 164Sequence Numbers and Concurrency 168Summary 170CHAPTER 9 Performance Metrics 171Online Monitoring and Metrics 172Application Server 173BEA WebLogic Server Access Log. 180Apache Web Server Access Log 188Query Metrics 191Batch Metrics 195Process Scheduler. 195PeopleSoft Trace Files. 216Application Designer and Client 216Application Server 218PIA Trace 219Analyzing PeopleSoft Trace Files. 223Summary 227CHAPTER 10 PeopleTools Performance Utilities 229Query Metrics in PeopleTools 8.4 229Query Statistics 229Query Logging 231PeopleSoft Ping 232What Does Ping Measure? 234PeopleSoft Ping Case Study 1: Desktop/BrowserPerformance 238PeopleSoft Ping Case Study 2: Application ServerCPU Speed 239Conclusion. 240Performance Monitor 240Architectural Overview 241Metrics. 242Performance Trace. 252Transaction and Events. 253Instrumentation 260Summary 262Enabling Oracle SQL Trace. 263Oracle Initialization Parameters and SQL Trace 264Analyzing SQL Trace Files with TKPROF. 265Enabling SQL Trace for PeopleTools Clients 266Enabling SQL Trace for Application Server Processes. 266Enabling SQL Trace on the Process Scheduler 269Enabling SQL Trace Programmatically 271Where Does This SQL Come From? 274Component Processor. 274PeopleCode 275Query 277COBOL 279SQR 282Application Engine 284Techniques for SQL Optimization 284Hints 285Indexes 285Disabling Indexes Without Using Hints. 285FROM Clause Ordering 286Explicitly Coding Implicit Joins 288Plan Stability (or Stored Outlines) 291Implementing SQL Optimization Techniques 292Views 292Component Processor. 292Query 296Upgrade Considerations 314Summary 314CHAPTER 12 Configuring the Application Server 315Overview of Configuration Files 315psappsrv.ubx 318Features, Settings, and Ports Sections. 320PS_DEFINES Section 321Main Tuxedo Section 324PS_ENVFILE Section 339psappsrv.cfg. 340Startup 341Database Options. 341Security 342Workstation and Jolt Listeners 343Domain Settings. 344Trace 345Cache Settings 346Remote Call. 347PeopleSoft Server Processes 348psappsrv.val 348psappsrv.ubb 349psappsrv.env 352Configuration Template Files 352Tuxedo Administration Console 353Configuring the BEA Administration Console for PeopleSoft 354Configuring PeopleSoft for the BEA Administration Console 356Summary 357Sizing. 359Spawning 360Too Few Server Processes? 361Too Many Server Processes?. 364Multiple Queues 367Kernel Configuration 369Other Tuxedo Options 376Operating System Priority. 376Load Balancing. 377Service Priority 382Other Tips 383Unix User Accounts 383Multiple Domains on Small Production Systems 384Cycling the Application Server Without Shutting It Down 384Reconfiguring Tuxedo with the Administration Console 385Summary 386CHAPTER 14 The Process Scheduler 387Process Scheduler Architecture 387PeopleTools 7.x 388PeopleTools 8.1x 388PeopleTools 8.4x 388Process Monitor 392DBA Issues 392What Happens When a Process Is Scheduled? 392Process Scheduler Activity 396Purging the Process Scheduler Tables 398Lowering Operating System Priority of Batch Processes 399Mutually Exclusive Processing. 402Application Engine Server Considerations. 404Summary 405INDEX 407This book should have been written years ago, but then it would not have been as comprehensiveas it is today. It bridges the gap between the worlds of PeopleSoft and Oracle, explainingwhere and how the two sides meet.My own experience with PeopleSoft began in 1992 as the DBA on a GL 1.1/PeopleTools 2.1implementation project. The DBA is often the only âtechnology-savvyâ person on such a project,with the rest of the team consisting of functional experts, developers and, of course, management.As such, the DBA often is tasked with helping to investigate and solve any technologyrelated