SOA 11G Database Growth Management Strategy - Oracle

Jan 31, 2012 - Thorough testing will ensure that the tools, the database and hardware ... load testing, so that growth averages can be determined. ..... Oracle FMW 11g R1 SOA with Oracle Database Real Application Clusters Assessment.
435KB Sizes 0 Downloads 147 Views
An Oracle 11g Fusion Middleware SOA White Paper January 2012

SOA 11G Database Growth Management Strategy

Oracle Maximum Availability Architecture

SOA 11G Database Growth Management

Disclaimer The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Oracle Maximum Availabilty Architecture

SOA 11G Database Growth Management

Executive Overview ........................................................................... 1 Introduction ....................................................................................... 1 1. SOA Database Profile ................................................................... 2 1.1. Inflow of data .......................................................................... 3 1.2. Retention Policy ...................................................................... 4 1.3. Outflow of data ....................................................................... 4 1.4. Long Running Composites and Table Partitioning .................. 5 2. SOA Database Growth Management Strategy .............................. 7 2.1. Database Growth Management Challenges ........................... 7 2.2. Quality Assurance Testing ...................................................... 9 2.3. Recommended Strategies. ................................................... 11 2.3.1. Recommendations for Large Database profiles ................. 11 2.3.2. Recommendations for Medium Database profiles .............. 11 2.3.3. Recommendations for Small Database profiles ................. 11 3. Troubleshooting. .......................................................................... 13 3.1. Parallel Purge ....................................................................... 13 3.1.1. Degree of Parallel .............................................................. 13 3.1.2. Parsing Composites to Delete............................................ 14 3.1.3. Parallel Query Slaves ........................................................ 14 3.1.4. Debug and Tracing ............................................................ 15 3.2. SOA Table Partitioning. ........................................................ 17 3.2.1. Referential Integrity and Equi-Partitioning .......................... 17 3.2.2. Composite Range-Hash partitions ..................................... 18 3.2.3. Interval Partitioning. ........................................................... 18 3.2.4. Global Hash Indexes. ........................................................ 18 3.2.5. Partition Pruning ................................................................ 19 3.2.5. Purging Partitions .............................................................. 19 3.3. Reducing Audit levels ........................................................... 19 Conclusion ...................................................................................... 20 References ...................................................................................... 21

Oracle Maximum Availabilty Architecture

SOA 11G Database Growth Management

Appendix A. Monitoring the SOA Installation ................................... 22 A.1. Monitor Space Usage ........................................................... 22 A.1.1. Determine the growth trend of the components. ................ 22 A.1.2. Determine the growth trend of the SOA Schema ............... 23 A.1.3. Determine the largest segments. ....................................... 23 A.1.4. Determine the growth trend of tables and indexes. ............ 24 A.1.5. Estimate Table size. ............................................