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