PeopleSoftEnterprisePerformanceonOracle10G资源-CSDN文库

需积分: 3 76 浏览量 2010-01-29 06:23:51 上传评论收藏 335KB PDF 举报

资源推荐

资源详情

资源评论

PeopleSoft Enterprise Performance

on Oracle 10g Database

Table of Contents

Table of Contents........................................................................................................................................................4

Chapter 1 - Introduction.............................................................................................................................................6

Structure of this Red Paper 6

Related Materials 6

Chapter 2 - Generating Statistics.............................................................................................................................7

Manually Gathering Table Statistics 7

Sample DBMS_STATS Command............................................................................................................................................8

Generating Statistics for Data dictionary tables 9

Generating System Statistics...................................................................................................................................................... 9

Statistics at Runtime for Temporary Tables 9

Example ..................................................................................................................................................................................... 9

Turning off %UpdateStats .......................................................................................................................................................10

Modify %UpdateStats to Use Analyze Command................................................................................................................... 10

Turning Off Dynamic Sampling ..............................................................................................................................................14

Histograms 14

What Are Histograms?............................................................................................................................................................. 14

Candidate Columns for Histograms within PeopleSoft Applications...................................................................................... 14

Creating Histograms.................................................................................................................................................................15

Viewing Histograms.................................................................................................................................................................15

Chapter 3 - Reviewing Dedicated Temporary Tables............................................................................................16

What are Dedicated Temp Tables? 16

Performance Tips for Dedicated Temp Tables......................................................................................................................... 16

Application Engine Performance with Dedicated Temporary Tables 17

How Do Temp Tables Work in AE?........................................................................................................................................17

Test Case Explaining Temp Table Behavior............................................................................................................................ 17

Drawbacks of Using Base Temp Table.................................................................................................................................... 18

Recommendations.................................................................................................................................................................... 18

Creating PeopleSoft Temporary Tables as Oracle Global Temp Tables 19

What are Global Temporary Tables? .......................................................................................................................................19

Can GTTs Be Used in Place of Dedicated Temp Tables? ....................................................................................................... 19

Chapter 4 - Selecting Tablespaces ........................................................................................................................21

Locally Managed Tablespaces 21

Advantages of Locally Managed Tablespaces......................................................................................................................... 21

Space Management .................................................................................................................................................................. 21

Locally Managed - AUTO ALLOCATE ................................................................................................................................. 21

Locally Managed - UNIFORM EXTENT ............................................................................................................................... 22

Temporary Tablespaces 22

Tempfile Based ........................................................................................................................................................................ 22

UNDO Management 22

Automatic Undo Management ................................................................................................................................................. 23

9/4/2008 PeopleSoft Enterprise CRM Red Paper

Table/Index Partitioning 23

What Is Partitioning? ...............................................................................................................................................................23

Chapter 5 - Maintaining Indexes.............................................................................................................................24

Index Tips 24

Rebuilding of Indexes 24

Function-Based Indexes 25

Chapter 6 - Using Cursor Sharing..........................................................................................................................27

Use of Bind Variables 27

AE - Reuse Flag....................................................................................................................................................................... 27

SQR/COBOL - CURSOR_SHARING 30

Example ................................................................................................................................................................................... 30

Pros and Cons of CURSOR_SHARING.................................................................................................................................. 31

Chapter 7 - Selecting Batch Servers......................................................................................................................33

Scenario 1: Process Scheduler And Database Server on Different Boxes 33

Scenario 2: Process Scheduler and Database Server on one BOX 33

What is the recommended scenario? 34

Chapter 8 - Capturing Traces .................................................................................................................................35

Online Performance Issues 35

Settings for Single User Online Session Trace ........................................................................................................................36

Application Server Settings for Tracing an Online Process..................................................................................................... 37

AE Performance Issues 38

Configuration Settings for Tracing an AE Process on the AE................................................................................................. 38

Configuration Settings for Tracing an AE Process on the Database........................................................................................39

COBOL Performance Issues 41

SQR Reports Performance Issues 41

ORACLE Performance Issues 41

Generating Explain Plan for SQL Using sqltexplain.sql 42

Automatic Workload Repository 42

Generating a HTML or Text AWR Report:............................................................................................................................. 43

AWR Report Analysis ............................................................................................................................................................. 43

Appendix A – Validation and Feedback..................................................................................................................48

Appendix B – Sample Script to Gather Statistics on Tables................................................................................53

Customer Validation 53

Field Validation 53

Appendix C – References ........................................................................................................................................54

Appendix B – Revision History................................................................................................................................55

Authors..................................................................................................................................................................................... 55

Revision History ......................................................................................................................................................................55

剩余55页未读，继续阅读

评论收藏

内容反馈