1 / 4

GG test

GG test. Zbigniew Baranowski. I. Preparation. Preparation of the hardware at T1s (in progress) Installation of 11.2.0.4 ( RAC or single instance) Create GGADMIN schema (a script to be executed) Create GGUSER test schema (with standard application grants + ~100GB tablespace).

saima
Download Presentation

GG test

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GG test Zbigniew Baranowski

  2. I. Preparation • Preparation of the hardware at T1s (in progress) • Installation of 11.2.0.4 (RAC or single instance) • Create GGADMIN schema (a script to be executed) • Create GGUSER test schema (with standard application grants + ~100GB tablespace)

  3. II. Generic workload tests (March) • Remote configuration • All config to be done at T0 (SW& HW is ready) • Run worklload and measure throughputs (at T0 and T1s) • Local configuration • Installation of GG binaries on db system • ~100GB is needed for TRAIL FILES • Setting up processes at T0 and T1s • Run worklload and measure throughputs (at T0 and T1s)

  4. III. Tests with production workload (April – May) • Remote all local config (depending which worked better in previous test) • Set up of GG process (start of extract) • Dupliaction of T1s COOL replica to 11.2.0.4 db (expdp/impdp) • Start the rest of the GG processes • Run it for couple of weeks • Measure performance • Check data consistancy (Veridata)

More Related