Oracle Real Application Testing 10g

Only available on StudyMode
  • Topic: Oracle Database, SQL, Oracle Corporation
  • Pages : 40 (11145 words )
  • Download(s) : 53
  • Published : October 24, 2011
Open Document
Text Preview
REAL APPLICATION TESTING ON 10G – STEP BY STEP
Alejandro Vargas Principal Support Consultant Oracle Advanced Customer Services

Summary............................................................................................................................................................................3 Patches Required for RAT.................................................................................................................................................. 4 Project Implementation Steps............................................................................................................................................. 5 Clone production database on test server, start it up.........................................................................................................6 Create 11g database on test server on Windows...............................................................................................................6 Download patches for RAT................................................................................................................................................. 6 Download RAT scripts and docs from OTN........................................................................................................................7 Patches Installation............................................................................................................................................................. 7 Install patch 6998002 on Windows 10g database..............................................................................................................9 Install patch 6903335 on Windows 10g clone database................................................................................................... 7 1 Install patch 7044721 on Windows 11g test database.....................................................................................................22 Configure and execute functional RAT tests on Windows................................................................................................36 Create A Small Test Inside To Clone Of Production To Test On Linux............................................................................36 Test Capture On The Production Clone...........................................................................................................................36 Create a filter for the session to capture...........................................................................................................................38 Create a Directory to store the captured load...................................................................................................................39 Start the Capture process................................................................................................................................................. 9 3 Stopping a Workload Capture..........................................................................................................................................41 Check capture process ID and status...............................................................................................................................41 Exporting AWR Data for Workload Capture.....................................................................................................................43 After completing the run gather awr statistics...................................................................................................................45 1/74

REAL APPLICATION TESTING ON 10G – STEP BY STEP
Generating a Workload Capture Report Using APIs........................................................................................................46 Workload Preprocessing..................................................................................................................................................47 Workload...
tracking img