Note: You can use following DB templates only with EM 13.3.0.0 release. Refer to the EM 13.3.0.0 Install guide to learn how to use these DB templates to setup database that will house the EM repository 13.3.0.0 DB templates are only for 12.1.0.2.0 and 18.1.0.0.0 version of DB with config types [ Single Instance and PDB ]
Download |
Release Notes |
---|---|
376397006 bytes, cksum 1824416891 | |
900604503 bytes, cksum 2887109592 | |
368522154 bytes, cksum 2545989106 | |
787525959 bytes, cksum 2605546908 | |
359309202 bytes, cksum 2595116940 | |
718950063 bytes, cksum 1860162161 | |
339664703 bytes, cksum 3474501962 | |
685664296 bytes, cksum 2662237155 | |
388715677 bytes, cksum 3437758646 | |
832313070 bytes, cksum 3770426584 | |
333621085 bytes, cksum 958325402 | |
732918546 bytes, cksum 1347522026 |
Instructions:
The following DB parameters need to set once the DB instance is created using the DB templates using 18.1 PDBs for all platforms.
SMALL:
alter system set parallel_max_servers=8 SCOPE=SPFILE;
alter system set session_cached_cursors=200 SCOPE=SPFILE;
alter system set sga_target=3000000000 SCOPE=SPFILE;
alter system set pga_aggregate_target=1000000000 SCOPE=SPFILE;
alter system set shared_pool_size='600000000';
alter system set "_allow_insert_with_update_check"=TRUE scope=both sid='*';
MEDIUM:
alter system set parallel_max_servers=8 SCOPE=SPFILE;
alter system set session_cached_cursors=200 SCOPE=SPFILE;
alter system set sga_target=5000000000 SCOPE=SPFILE;
alter system set pga_aggregate_target=1340000000 SCOPE=SPFILE;
alter system set shared_pool_size='600000000';
alter system set "_allow_insert_with_update_check"=TRUE scope=both sid='*';
LARGE:
alter system set parallel_max_servers=8 SCOPE=SPFILE;
alter system set session_cached_cursors=200 SCOPE=SPFILE;
alter system set sga_target=8000000000 SCOPE=SPFILE;
alter system set pga_aggregate_target=1600000000 SCOPE=SPFILE;
alter system set shared_pool_size='600000000';
alter system set "_allow_insert_with_update_check"=TRUE scope=both sid='*';
Download |
Release Notes |
---|---|
371403798 bytes, cksum 4182361443 | |
614938630 bytes, cksum 1569589975 | |
339226455 bytes, cksum 2161920127 | |
607811784 bytes, cksum 2748449434 | |
302604987 bytes, cksum 623884414 | |
628831666 bytes, cksum 3581230851 | |
382846420 bytes, cksum 2618167356 | |
719536187 bytes, cksum 2865626327 | |
348329640 bytes, cksum 2703701316 | |
616647862 bytes, cksum 3001348554 | |
324041965 bytes, cksum 4108087392 | |
622378173 bytes, cksum 1373343895 |