Using Real Application Testing Functionality in Earlier Releases_560977.1
In this Document
| Details |
| Ask Questions, Get Help, And Share Your Experiences With This Article |
| Actions |
| Real Application Testing on Earlier Releases |
| Database Replay |
| Table 1: Database Replay Availability Information for All Platforms except Windows |
| Table 2: Database Replay Availability Information Windows Platform |
| Enabling Workload Capture (Only Required for 10.2.0.4.0) |
|
SQL Performance Analyzer |
| Table 3: SQL Performance Analyzer Availability Information |
| EM Grid control |
| Windows Platforms |
| 11.1.0.7.0 Database |
| Contacts |
| Discuss Real Application Testing! |
| References |
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.8 and laterInformation in this document applies to any platform.
9.2.X TO 11.2.X
Details
Oracle Database 11g introduces Database Replay and SQL Performance Analyzer as part of the Real Application Testing option. Real Application Testing provides businesses with the the capability of identifying issues with system and database changes before production deployment. The main goal of making Real Application Testing functionality available in earlier releases is to enable customers to upgrade to higher database releases.
This note provides information on the Real Application Testing functionality available for pre-11g database releases as well as mandatory patches that are required for 11g databases.
SQL Performance Analyzer allows users to identify SQL performance regressions caused by system changes such as adding an index, gathering optimizer statistics, implementing partitioning, RDBMS upgrades, etc. SQL Performance Analyzer assesses the impact of change on SQL response times by executing each SQL serially with production context (bind variables, optimizer environment, etc.) before and after a change and then providing a report highlighting any performance divergences.
Database Replay allows users to perform comprehensive testing of database and infrastructure changes using real application workloads. It allows capture of production workload including concurrency, think time, and transactions dependencies, and allows users to replay the workload on a test system with the exact same production characteristics so that all problems can be identified and remediated in test before deploying the change to production.
Please check the Licensing Information manual on OTN for details regarding licensing of Real Application Testing Option.
Ask Questions, Get Help, And Share Your Experiences With This Article
Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?
Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.
Actions
Real Application Testing on Earlier Releases
To install Real Application Testing functionality on pre-11g database releases, opatch utility should be used. Follow the instructions for the generic and platform specific README for the patches. If you want to only use Database Replay or SQL Performance Analyzer, then only the patch(es) for that particular functionality need to be applied. If you want to use both Database Replay and SQL Performance Analyzer, the patches for both the functionalities need to be applied.
Database Replay
To assist customers in upgrading to Oracle Database 11g and higher, the capture functionality of Database Replay has been made available in previous releases as shown in the table below.
Note: The replay of the captured workload can only be done on Oracle Database 11g and higher.
Please refer to Oracle documentation on OTN for information on the capture part of Database Replay available for the earlier releases.
Note:
- These are mandatory patches.
- Table may not show all possible combinations.
| Source DB Upgrade from release | Destination DB Upgrade to any release | What patch you need to apply? | Download Information | Comments |
|---|---|---|---|---|
| 9.2.0.8.0 | >=11.1.0.6.0 |
9.2.0.8.0 + one-off patch 9373986 For AIX platform one-off patch 13370576 (it includes 9373986) |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded from MOS |
| 9.2.0.8.0 | >=11.1.0.7.0 |
9.2.0.8.0 + one-off patch 9373986 + For AIX platform one-off patch 13370576 (it includes 9373986) one-off patch 8712466 on top of 11.1.0.7.0 |
One-off patch can be downloaded or requested from MOS | 8712466 is a merge patch on top of 11.1.0.7.0 |
| 9.2.0.8.0 | >=11.2.0.1.0 |
9.2.0.8.0 + one-off patch 9373986 For AIX platform one-off patch 13370576 ( it includes 9373986) |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded from MOS |
| 9.2.0.8.0 | >=11.2.0.2.0 |
9.2.0.8.0 + one-off patch 9373986 (13947480 includes 11870615) |
One-off patch can be downloaded from MOS |
One-off patch can be downloaded from MOS
|
| 9.2.0.8.0 | >=11.2.0.3.0 |
9.2.0.8.0 + one-off patch 9373986 or 16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS
For patch 16086826 please check Doc ID 1573521.1 proactively
|
| 9.2.0.8.0 | >=11.2.0.4.0 |
9.2.0.8.0 + one-off patch 9373986 |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS |
| 10.2.0.2.0 | >=11.1.0.6.0 | 10.2.0.2.0 + one-off patch 9373986 | One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 10.2.0.2.0 | >=11.1.0.7.0 |
10.2.0.2.0 + one-off patch 9373986 and one-off patch 8712466 on top of 11.1.0.7.0 |
One-off patch can be downloaded or requested from MOS | 8712466 is a merge patch on top of 11.1.0.7.0 |
| 10.2.0.2.0 | >=11.2.0.1.0 | 10.2.0.2.0 + one-off patch 9373986 | One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 10.2.0.2.0 | >=11.2.0.2.0 |
10.2.0.2.0 + one-off patch 9373986 (13947480 includes 11870615) |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 10.2.0.2.0 | >=11.2.0.3.0 |
10.2.0.2.0 + one-off patch 9373986 or 16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS For patch 16086826 please check Doc ID 1573521.1 proactively |
| 10.2.0.2.0 | >=11.2.0.4.0 |
10.2.0.2.0 + one-off patch 9373986 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 10.2.0.3.0 | >=11.1.0.6.0 | 10.2.0.3.0 + one-off patch 9373986 | One-off patch can be downloaded from MOS | One-off patch can be downloaded from MOS |
| 10.2.0.3.0 | >=11.1.0.7.0 | 10.2.0.3.0 + one-off patch 9373986+ one-off patch 8712466 on top of 11.1.0.7.0 | One-off patch can be downloaded from MOS | 8712466 is a merge patch on top of 11.1.0.7.0 |
| 10.2.0.3.0 | >=11.2.0.1.0 | 10.2.0.3.0 + one-off patch 9373986 | One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 10.2.0.3.0 | >=11.2.0.2.0 |
10.2.0.3.0 + one-off patch 9373986 (13947480 includes 11870615) |
One-off patch can be downloaded from MOS | One-off patch can be downloaded from MOS |
| 10.2.0.3.0 | >=11.2.0.3.0 |
10.2.0.3.0 + one-off patch 9373986 or 16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS For patch 16086826 please check Doc ID 1573521.1 proactively |
| 10.2.0.3.0 | >=11.2.0.4.0 |
10.2.0.3.0 + one-off patch 9373986 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 10.2.0.4.0 | >= 11.1.0.6.0 | 10.2.0.4.0 Patchset + one-off patch 10239989 | Patchset can be downloaded from MOS |
Functionality already exists in Patchset, download from MOS Enable workload capture by following instructions below |
| 10.2.0.4.0 | >=11.1.0.7.0 | 10.2.0.4.0 patchset+ one-off patch 10239989 + one-off patch 8712466 on top of 11.1.0.7.0 | Patchset can be downloaded from MOS |
Functionality already exists in Patchset, download from Metalink
8712466 is a merge patch on top of 11.1.0.7.0 |
| 10.2.0.4.0 | >=11.2.0.1.0 | 10.2.0.4.0 Patchset + one-off patch 10239989 | Patchset can be downloaded from MOS |
Functionality already exists in Patchset, download from MOS Enable workload capture by following instructions below |
| 10.2.0.4.0 | >=11.2.0.2.0 |
10.2.0.4.0 Patchset + one-off patch 10239989 and 11.2.0.2.0 + one-pff patch 11870615 or 13947480 (13947480 includes 11870615) |
Patchset can be downloaded from MOS |
Functionality already exists in Patchset, download from MOS Enable workload capture by following instructions below |
| 10.2.0.4.0 | >=11.2.0.3.0 |
10.2.0.4.0 Patchset + one-off patch 10239989
or 16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
Patchset can be downloaded from MOS |
Functionality already exists in Patchset, download from MOS For patch 16086826 please check Doc ID 1573521.1 proactively |
| 10.2.0.4.0 | >=11.2.0.4.0 |
10.2.0.4.0 Patchset + one-off patch 1023998
|
Patchset can be downloaded from MOS |
Functionality already exists in Patchset, download from MOS |
| 10.2.0.5.0 | >=11.2.0.1.0 |
10.2.0.5.0 Patchset + one-off patch 9373986 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 10.2.0.5.0 | >=11.2.0.2.0 |
10.2.0.5.0 Patchset + one-off patch 9373986 and 11.2.0.2.0 + one-off patch 11870615 or 13947480 (13947480 includes 11870615) |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 10.2.0.5.0 | >=11.2.0.3.0 |
10.2.0.5.0 Patchset + one-off patch 9373986 or 16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS
For patch 16086826 please check Doc ID 1573521.1 proactively |
| 10.2.0.5.0 | >=11.2.0.4.0 |
10.2.0.5.0 Patchset + one-off patch 9373986
11.2.0.4.0 + 17411249 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.1.0.6.0 | >=11.2.0.1.0 | 11.1.0.6.0 + one-off patch 8712466 + 9373986 | One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.1.0.6.0 | >=11.2.0.2.0 |
11.1.0.6.0 + one-off patch 8712466 + 9373986 and 11.2.0.2.0 + one-off patch 11870615 or 13947480 (13947480 includes 11870615) |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.1.0.6.0 | >=11.2.0.3.0 |
11.1.0.6.0 + one-off patch 8712466 + 9373986 or 16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS
For patch 16086826 please check Doc ID 1573521.1 proactively |
| 11.1.0.6.0 | >=11.2.0.4.0 |
11.1.0.6.0 + one-off patch 8712466 + 9373986 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.1.0.7.0 | >=11.2.0.1.0 | 11.1.0.7.0 + one-off patch 8712466 + 9373986 | One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.1.0.7.0 | >=11.2.0.2.0 |
11.1.0.7.0 + one-off patch 8712466 + 9373986 and 11.2.0.2.0 + one-off patch 11870615 or 13947480 (13947480 includes 11870615) |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.1.0.7.0 | >=11.2.0.3.0 |
11.1.0.7.0 + one-off patch 8712466 + 9373986 or 16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS For patch 16086826 please check Doc ID 1573521.1 proactively |
| 11.1.0.7.0 | >=11.2.0.4.0 |
11.1.0.7.0 + one-off patch 8712466 + 9373986 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.2.0.1.0 | >=11.2.0.2.0 |
11.2.0.1.0 + one-off patch 9373986 and 11.2.0.2.0 + one-off patch 11870615 or 13947480 (13947480 includes 11870615) |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.2.0.1.0 | >=11.2.0.3.0 |
11.2.0.1.0 + one-off patch 9373986
16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS
For patch 16086826 please check Doc ID 1573521.1 proactively |
| 11.2.0.1.0 | >=11.2.0.4.0 |
11.2.0.1.0 + one-off patch 9373986 11.2.0.4.0 + 17411249 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.2.0.2.0 | >= 11.2.0.2.0 |
Capture side No capture side patches is needed for 11.2.0.2.0 and Replay Side
11.2.0.2.0 (13947480 includes 11870615) |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.2.0.2.0 | >=11.2.0.3.0 |
Capture side No capture side patches is needed for 11.2.0.2.0 and Replay Side
11.2.0.3.0 or 16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS
For patch 16086826 please check Doc ID 1573521.1 proactively |
| 11.2.0.2.0 | >=11.2.0.4.0 |
Capture side No capture side patches is needed for 11.2.0.2.0 and Replay Side 11.2.0.4.0 + 17411249 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.2.0.3.0 | >=11.2.0.3.0 |
Capture side No capture side patch is needed for 11.2.0.3.0 and Replay side
11.2.0.3.0 or 16086826 (16086826 includes 13947480) or 17411249 (17411249 includes 16086826 and all other previous patches) |
One-off patch can be downloaded or requested from MOS |
One-off patch can be downloaded or requested from MOS
For patch 16086826 please check Doc ID 1573521.1 proactively |
| 11.2.0.3.0 | >=11.2.0.4.0 |
Capture side No capture side patch is needed for 11.2.0.3.0 and Replay side 11.2.0.4.0 + 17411249 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
| 11.2.0.4.0 | >=11.2.0.4.0 |
Capture side No capture side patch is needed for 11.2.0.4.0 and Replay side 11.2.0.4.0 + 17411249 |
One-off patch can be downloaded or requested from MOS | One-off patch can be downloaded or requested from MOS |
Note:
- These are mandatory patches.
- Table may not show all possible combinations.
| Source DB Upgrade from release | Destination DB Upgrade to any release | What patch you need to apply? | Download Information | Comments |
|---|---|---|---|---|
| 9.2.0.8.0 For Windows 32-bit |
>=11.1.0.6.0 including 11.2.X |
9.2.0.8.0 + patch bundle 7047008 | Patch bundle can be downloaded from MOS | Patch Available as part of Bundle 18. |
| 9.2.0.8.0 For Windows Itanium 64-bit |
>=11.1.0.6.0 including 11.2.X |
9.2.0.8.0 + patch bundle 7047015 | Patch bundle can be downloaded from MOS | Patch Available as part of Bundle 18. |
| 10.2.0.3.0 For Windows 32-bit |
>=11.1.0.6.0 including 11.2.X |
10.2.0.3.0 + patch bundle 6998002 | Patch bundle can be downloaded from MOS | Patch Available as part of Bundle 23. |
| 10.2.0.3.0 For Windows Itanium 64-bit |
>=11.1.0.6.0 including 11.2.X |
10.2.0.3.0 + patch bundle 6998003 | Patch bundle can be downloaded from MOS | Patch Available as part of Bundle 23. |
|
10.2.0.3.0 For Windows 64-bit AMD64 AND Intel EM64T XP AND 2003 |
>=11.1.0.6.0 including 11.2.X |
10.2.0.3.0 + patch bundle 6998004 | Patch bundle can be downloaded from MOS | Patch Available as part of Bundle 23. |
|
10.2.0.4.0 (Windows 32-bit, Windows Itanium Windows 64-bit AMD64 AND Intel EM64T XP AND 2003) |
>= 11.1.0.6.0 including 11.2.X |
10.2.0.4.0 Patchset + one-off patch 8542772 | Patchset can be downloaded from MOS: 6810189 |
Functionality already exists in Patchset, download from MOS.
Enable workload capture by following instructions |
| 10.2.0.5.0 ( all windows platform ) |
>=11.1.0.6.0 including 11.2.X |
No mandatory patches needed. Functionality already exists in Patchset. |
Patchset can be downloaded from MOS | Functionality already exists in Patchset, download from MOS. |
By default, the workload capture is disabled on the pre-11g database releases. Database workload capture functionality is enabled on the system by specifying the PRE_11G_ENABLE_CAPTURE initialization parameter. In order to enable workload capture on 10.2.0.4 run the wrrenbl.sql script at the SQL prompt as SYS or SYSTEM as follows:
The wrrenbl.sql script calls the ALTER SYSTEM SQL statement to set the PRE_11G_ENABLE_CAPTURE initialization parameter to TRUE.
This step is NOT required for version lower then 10.2.0.4.0
Please check the OTN documentation mentioned above for more details.
SQL Performance Analyzer
SQL Performance Analyzer functionality has been enhanced and made available in earlier releases to help customers upgrade their databases from Oracle 9.x, 10.1.x, and 10.2.x to higher releases. Applying the one-off patches shown below will install the SQL Performance Analyzer functionality for that release. After the functionality has been installed, customers can then leverage Oracle Database 11g SQL Performance Analyzer functionality to upgrade from any database releases 9.x, 10.1.x, 10.2.x to 10.2 or higher release. The one-off patches that need to be applied depend on the version of the source and the destination databases as indicated in the table below.
Further information on this topic is available in the technical white paper:
It is recommended to review this document before using SQL Performance Analyzer functionality for earlier releases.
-
If an Oracle 11.1.0.6 database is to be used to orchestrate SPA on Oracle Database 10.2, please apply the following patch:
Patch 6865809 RAT/SPA MISSING KEY FUNCTIONALITIES TO SUPPORT TEST UPGRADE FROM 9I TO 10.2
This patch enables Oracle 11.1.0.6 test database to consume SQL trace files from previous database releases and generate a SQL Tuning Set (STS). The STS can then be used as input for the SQL Performance Analyzer task.
- Patches applied on Oracle Database 10.2 source or destination databases enable Remote SQL Test Execution functionality on that release for more accurate analysis of performance data.
Note:
- These are mandatory patches.
- Table may not show all possible combinations.
- The table below will not be updated from 11.2.0.2.0 and above for source as well as destination side as there is no mandatory patches required for it.
| Source DB Upgrade from release | Destination DB Upgrade to release | What patch you need to apply? | Download | Comments |
|---|---|---|---|---|
| 9.x | 10.2.0.2.0 |
i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809
Using the latest version of Oracle database is Recommended.
|
One-off patch can be Downloaded from MOS |
No patches are needed on the source side 9.x 11g test database does not need to have application schema /data |
| 9.x | 10.2.0.3.0 |
i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809
|
One-off patch can be Downloaded from MOS |
No patches are needed on the source side 9.x 11g test database does not need to have application schema /data |
| 9.x | 10.2.0.4.0 |
i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809 Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
|
One-off patch can be Downloaded from MOS |
No patches are needed on the source side 9.x 11g test database does not need to have application schema /data |
| 9.x | 10.2.0.5.0 |
i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809 Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
|
One-off patch can be Downloaded from MOS |
No patches are needed on the source side 9.x 11g test database does not need to have application schema /data |
| 9.x | 11.1.0.6.0 | i) 11.1.0.6 DB with Real Application Testing Option + one-off patch: 6865809 | One-off patch can be Downloaded from MOS |
No patches are needed on the source side 9.x Test DB not required, 11.1.0.6 is the destination db upgraded to |
| 9.X | 11.1.0.7.0 | Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594 | One-off patch can be Downloaded from MOS |
No patches are needed on the source side 9.x Test DB not required, 11.1.0.7 is the destination db upgraded to |
| 9.X | 11.2.0.1.0 | Use 11.2.0.1.0 with Real Application Testing option +8867819 | One-off patch can be Downloaded or requested from MOS |
No patches are needed on the source side 9.x Test DB not required, 11.2.0.1 is the destination db upgraded to |
| 9.X | 11.2.0.2.0 | Use 11.2.0.2.0 with Real Application Testing option |
No patches are needed on the source side 9.x Test DB not required, 11.2.0.2 is the destination db upgraded to |
|
| 9.X | 11.2.0.2.0 | Use 11.2.0.3.0 with Real Application Testing option |
No patches are needed on the source side 9.x Test DB not required, 11.2.0.3 is the destination db upgraded to |
|
| 10.1.0.x | 10.2.0.2.0 |
i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809 Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
|
One-off patch can be Downloaded from MOS |
No patches are needed on the source side 10.1.x 11g test database does not need to have application schema /data |
| 10.1.0.x | 10.2.0.3.0 |
i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809 Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
|
One-off patch can be Downloaded from MOS |
No patches are needed on the source side 10.1.x 11g test database does not need to have application schema /data |
| 10.1.0.x | 10.2.0.4.0 |
i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809
|
One-off patch can be Downloaded from MOS |
No patches are needed on the source side 10.1.x. 11g test database does not need to have application schema /data |
| 10.1.0.x | 10.2.0.5.0 |
i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809 Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
|
One-off patch can be Downloaded from MOS |
No patches are needed on the source side 10.1.x. 11g test database does not need to have application schema data |
| 10.1.0.x | 11.1.0.6.0 | i) 11.1.0.6 DB with Real Application Testing Option + one-off patch: 6865809 | One-off patch can be Downloaded from MOS | No patches are needed on the source side 10.1.x |
| 10.1.0.x | 11.1.0.7.0 | 11.1.0.7.0 with Real Application Testing Option + one-off patch:8756594 | One-off patch can be Downloaded from MOS | No patches are needed on the source side 10.1.x |
| 10.1.0.x | 11.2.0.1.0 | Use 11.2.0.1.0 with Real Application Testing option+8867819 | One-off patch can be Downloaded or requested from MOS | No patches are needed on the source side 10.1.x |
| 10.1.0.x | 11.2.0.2.0 | Use 11.2.0.2.0 with Real Application Testing option | No patches are needed on the source side 10.1.x | |
| 10.1.0.x | 11.2.0.3.0 | Use 11.2.0.3.0 with Real Application Testing option | No patches are needed on the source side 10.1.x | |
| 10.2.0.2.0 | 10.2.0.3.0 |
i) 11.1.0.6 + one-off patch: 6865809
|
One-off patch can be Downloaded from MOS |
Patch Required for source, destination and test databases. 11g test database does not need to have application schema data |
| 10.2.0.2.0 | 10.2.0.4.0 |
i) 11.1.0.6 + one-off patch: 6865809 Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
|
One-off patch can be Downloaded from MOS |
Patch Required for source, destination and test databases 11g test database does not need to have application schema /data |
| 10.2.0.2.0 | 10.2.0.5.0 |
i) 11.1.0.6 + one-off patch: 6865809 Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
|
One-off patch can be Downloaded from MOS | 11g test database does not need to have application schema data |
| 10.2.0.2.0 | 11.1.0.6.0 |
) 11.1.0.6 + one-off patch: 6865809 AND ii) 10.2.0.2 + one-off patch: 6903322 |
One-off patch can be Downloaded from MOS | Test DB not required, 11.1.0.6.0 is the destination db upgraded to |
| 10.2.0.2.0 | 11.1.0.7.0 |
11.1.0.7.0 db with Real Application Testing Option + one-off patch:8756594 AND ii) 10.2.0.2 + one-off patch: 6903322 |
One-off patch can be Downloaded from MOS | Test DB not required, 11.1.0.7.0 is the destination db upgraded to |
| 10.2.0.2.0 | 11.2.0.1.0 |
Use 11.2.0.1.0 with Real Application Testing option +8867819 AND ii) 10.2.0.2 + one-off patch: 6903322 |
One-off patch can be Downloaded from MOS | Test DB not required, 11.2.0.1 is the destination db upgraded to |
| 10.2.0.2.0 | 11.2.0.2.0 |
Use 11.2.0.2.0 with Real Application Testing option
No patch is needed on 11.2.0.2.0
|
One-off patch can be Downloaded from MOS | Test DB not required, 11.2.0.2 is the destination db upgraded to |
| 10.2.0.2.0 | 11.2.0.3.0 |
Use 11.2.0.3.0 with Real Application Testing option ,
No patch is needed on 11.2.0.3.0 |
One-off patch can be Downloaded from MOS | Test DB not required, 11.2.0.3 is the destination db upgraded to |
| 10.2.0.3.0 | 10.2.0.4.0 |
i) 11.1.0.6 + one off patch: 6865809 or
Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594 or Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
ii) 10.2.0.3 + one off patch 6903335 AND ii) 10.2.0.4 + one off patch: 6893073 |
One-off patch can be Downloaded from MOS | 11g test database does not need to have application schema /data |
| 10.2.0.3.0 | 10.2.0.5.0 |
i) 11.1.0.6 + one off patch: 6865809
|
One-off patch can be Downloaded from MOS |
11g test database does not need to have application schema data |
| 10.2.0.3.0 | 11.1.0.6.0 |
10.2.0.3 + one off patch 6903335 and 11.1.0.6 db with Real Application Testing Option + one off patch: 6865809 |
One-off patch can be Downloaded from MOS | Test DB not required, 11.1.0.6.0 is the destination db upgraded to |
| 10.2.0.3.0 | 11.1.0.7.0 |
10.2.0.3 + one off patch 6903335 11.1.0.7.0 db with Real Application Testing Option + one-off patch:8756594 |
One-off patch can be Downloaded from MOS | Test DB not required, 11.1.0.7.0 is the destination db upgraded to |
| 10.2.0.3.0 | 11.2.0.1.0 |
10.2.0.3 + one off patch 6903335 and Use 11.2.0.1.0 with Real Application Testing option +8867819
|
One-off patch can be Downloaded from MOS | Test DB not required, 11.2.0.1.0 is the destination db upgraded to. |
| 10.2.0.3.0 | 11.2.0.2.0 |
10.2.0.3 + one off patch 6903335 Use 11.2.0.2.0 with Real Application Testing option No patch is needed on 11.2.0.2.0
|
One-off patch can be Downloaded from MOS |
One-off patch can be Downloaded from MOS Test DB not required, 11.2.0.2.0 is the destination db upgraded to. |
| 10.2.0.3.0 | 11.2.0.3.0 |
10.2.0.3 + one off patch 6903335 Use 11.2.0.3.0 with Real Application Testing option No patch is needed on 11.2.0.3.0 |
One-off patch can be Downloaded from MOS |
One-off patch can be Downloaded from MOS Test DB not required, 11.2.0.3.0 is the destination db upgraded to |
| 10.2.0.4.0 | 10.2.0.5.0 |
i) 10.2.0.4 + one-off patch: 6893073 Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
|
One-off patch can be Downloaded from MOS | 11g test database does not need to have application schema /data |
| 10.2.0.4.0 | 11.1.0.6.0 |
i) 11.1.0.6 + one off patch: 6865809 AND ii) 10.2.0.4 + one-off patch: 6893073 |
One-off patch can be Downloaded from MOS | Test DB not required, 11.1.0.6.0 is the destination db upgraded to |
| 10.2.0.4.0 | 11.1.0.7.0 |
11.1.0.7.0 db with Real Application Testing Option + one-off patch:8756594 AND 10.2.0.4 + one-off patch: 6893073 |
One-off patch can be Downloaded from Metalink | Test DB not required, 11.1.0.7.0 is the destination db upgraded to |
| 10.2.0.4.0 | 11.2.0.1.0 |
Use 11.2.0.1.0 with Real Application Testing option +8867819 AND 10.2.0.4 + one-off patch: 6893073 |
One-off patch can be Downloaded or requested from MOS | Test DB not required, 11.2.0.1.0 is the destination db upgraded to |
| 10.2.0.4.0 | 11.2.0.2.0 |
i Use 11.2.0.2.0 with Real Application Testing option No patch required for 11.2.0.3.0
|
One-off patch can be Downloaded or requested from MOS | Test DB not required, 11.2.0.2.0 is the destination db upgraded to |
| 10.2.0.4.0 | 11.2.0.3.0 |
i Use 11.2.0.3.0 with Real Application Testing option No patch required for 11.2.0.3.0
|
One-off patch can be Downloaded or requested from MOS | Test DB not required, 11.2.0.3.0 is the destination db upgraded to |
| 10.2.0.5.0 | 11.1.0.6.0 | 11.1.0.6 + one off patch: 6865809 | One-off patch can be Downloaded or requested from MOS | Test DB not required, 11.1.0.6.0 is the destination db upgraded to |
| 10.2.0.5.0 | 11.2.0.1.0 |
Use 11.2.0.1.0 with Real Application Testing option +8867819 |
One-off patch can be Downloaded or requested from MOS | Test DB not required, 11.2.0.1.0 is the destination db upgraded to |
| 10.2.0.5.0 | 11.2.0.2.0 | Use 11.2.0.2.0 with Real Application Testing option | Test DB not required, 11.2.0.2.0 is the destination db upgraded to | |
| 10.2.0.5.0 | 11.2.0.3.0 | Use 11.2.0.3.0 with Real Application Testing option | Test DB not required, 11.2.0.3.0 is the destination db upgraded to | |
| 11.1.0.6.0 | 11.1.0.7.0 |
i) 11.1.0.6 + one off patch: 6865809 and 11) 11.1.0.7.0 db with Real Application Testing Option + one-off patch:8756594 |
One-off patch can be Downloaded or requested from MOS | |
| 11.1.0.6.0 | 11.2.0.1.0 |
i) 11.1.0.6 + one off patch: 6865809 and ii) Use 11.2.0.1.0 with Real Application Testing option +8867819 |
One-off patch can be Downloaded or requested from MOS | |
| 11.1.0.6.0 | 11.2.0.2.0 |
i) 11.1.0.6 + one off patch: 6865809 and ii)Use 11.2.0.2.0 with Real Application Testing option |
One-off patch can be Downloaded or requested from MOS | |
| 11.1.0.7.0 | 11.2.0.1.0 |
i) 11.1.0.7.0 db with Real Application Testing Option and ii) Use 11.2.0.1.0 with Real Application Testing option +8867819 |
One-off patch can be Downloaded or requested from MOS | |
| 11.1.0.7.0 | 11.2.0.2.0 |
i) 11.1.0.7.0 db with Real Application Testing Option and ii) Use 11.2.0.2.0 with Real Application Testing option |
One-off patch can be Downloaded or requested from MOS | |
| 11.1.0.7.0 | 11.2.0.3.0 |
i) 11.1.0.7.0 db with Real Application Testing Option and ii) Use 11.2.0.3.0 with Real Application Testing option |
||
| 11.2.0.1.0 | 11.2.0.2.0 |
i) Use 11.2.0.1.0 with Real Application Testing option +8867819 and ii) Use 11.2.0.2.0 with Real Application Testing option |
One-off patch can be Downloaded or requested from MOS |
If using EM Grid control for Sql Performance Analyzer with 11.2.0.2.0 database it is recommended to apply:
Patch 10402264 ORA-00911 WHEN CLICKING ON LINK ON SPA COMPARISON REPORT WITH 9I GENERATED STS
11.1.0.6 Patch 4 or higher should be applied on Windows: For details on Windows patches see:
Please check the following note:
For more information on Real Application see:
Document 1453789.1 Real Application Testing: Consolidated Database Replay Feature
Document 787658.1 SCALE_UP_MULTIPLIER:DATABASE CAPTURE AND REPLAY
Document 1287620.1 Database Replay Diagnostic information
Document 1536143.1 Slow DBMS_Workload_Replay.Process_Capture
Document 463263.1 DATABASE CAPTURE AND REPLAY COMMON ERRORS AND REASONS
Document 760402.1 SCRIPTS TO DEBUG SLOW REPLAY
Document 1388309.1 How To Find Database Replay Divergence Details
Document 1538269.1 Slow Database Replay with Waits on "WCR: replay clock"
Document 1268920.1 Real Application Testing:Workload Analyzer
Document 1535885.1 Real Application Testing: Best Practices
Contacts
Please create a Service Request with Oracle Support.
If any of these patches are not available for the specific platform or Database version or if a patch conflicts with existing applied patches, please create an SR for versions listed on this note with Oracle Support providing the details of the operating system platform,database version, current list of patches applied using opatch -detail lsinventory.
Discuss Real Application Testing!
The window below is a live discussion of this article (not a screenshot). We encourage you to join the discussion by clicking the "Reply" link below for the entry you would like to provide feedback on. If you have questions or implementation issues with the information in the article above, please share that below.
ReferencesNOTE:1453789.1 - Real Application Testing: Consolidated Database Replay FeatureNOTE:1287620.1 - Database Replay Diagnostic information NOTE:785351.1 - Oracle 11gR2 Upgrade Companion NOTE:601807.1 - Oracle 11gR1 Upgrade Companion NOTE:1268920.1 - Real Application Testing:Workload Analyzer NOTE:562899.1 - Using SQL Performance Analyzer to Test SQL Performance Impact of an Upgrade NOTE:1573521.1 - Postinstall.sql for Patch 16086826 DBREPLAY Patch Bundle 2 and Database Replay Workload Consolidation Feature NOTE:1536143.1 - Troubleshooting: Slow DBMS_Workload_Replay.Process_Capture NOTE:1538269.1 - Slow Database Replay with Waits on "WCR: replay clock" |
|
|
-
One Page Best Practice(38.93 KB)
-
SPA_WHITE_PAPER(389.4 KB)
|
|
- Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > RDBMS > Manageability SQL Tuning
- Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > RDBMS > Manageability SQL Perf Impact Analyzer
- Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > RDBMS > Manageability Workload Capture & Replay
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1332171/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle Real Application Testing之DB Replay實踐案例OracleAPP
- RAT（Oracle Real Application Testing）時ORA 600報錯處理OracleAPP
- 【RAT】Oracle Real Application Testing（真用應用測試）介紹OracleAPP
- Real Application Test（RAT）APP
- Oracle Real Application Clusters GFSOracleAPP
- How a Database Is Mounted with Real Application Clusters (294)DatabaseAPP
- CRS and 10g Real Application ClustersAPP
- Split Brain in Oracle Clusterware and Real Application ClusterAIOracleAPP
- oracle real cluster application install on windows with VMweaverOracleAPPWindows
- Deinstallation Tool for Oracle Clusterware and Oracle Real Application ClustersOracleAPP
- ORA-00439: feature not enabled: Real Application ClustersAPP
- INE - Advanced Web Application Penetration Testing （eWPTx）WebAPP
- nxlog4go Simplest: Using for Testing EnvironmentGo
- Read Consistency with Real Application Clusters (314)APP
- INE - Web Application Penetration Testing Professional (萌新級)WebAPP
- oracle real application clusters and administration and deployment guide 7-13OracleAPPGUIIDE
- Configuring Raw Devices for Real Application Clusters on Linux_246205.1devAPPLinux
- zt_real application cluster恢復為單例項single instanceAPP單例
- zt_oracle10g rac real application cluster+asm修改spfile到新路徑OracleAPPASM
- 10g Hp-ux Oracle Real Application Clusters 安裝和配置指南(1)UXOracleAPP
- OpenCV Core functionality翻譯總結OpenCVFunction
- zt_oracle10g rac real application cluster ocr and voting disk備份恢復OracleAPP
- Enterprise Library 6——Using the Logging Application BlockAPPBloC
- Testing
- Exception testingException
- 對於診斷Oracle Clusterware CRS或GI和Real Application Cluster RAC問題的資料收集OracleAPP
- Unit testing frameworkFramework
- Database Unit TestingDatabase
- google friendly testingGo
- android-Purchasing In-app Billing Products,Testing Your In-app Billing ApplicationAndroidAPP
- New I/0 Functionality for JavaTM 2 Standard Edition 1.4 (轉)FunctionJava
- 11g 新特性 real time apply ＋real time queryAPP
- 基於輪廓線索的實時人體檢測 Real-Time Human Detection Using Contour Cues
- Android testing toolsAndroid
- Oracle Performance Testing PrincipleOracleORM
- Approaches to Performance TestingAPPORM
- 查詢real-time apply、real-time query的檢視APP
- Joe Harris is a real problem with this team