Using the Free Tier of Oracle Cloud I created one Autonomous DB of each type – one Autonomous Transaction Processing and one Autonomous Data Warehouse (Autonomous JSON are not yet available). Then did run<\/p>\n\n\n\n
on each of the DBs, I got the follow differences (empty means not set):<\/p>\n\n\n\n Both the databases (PDB) share the same Container (CDB).<\/p>\n\n\n\n I did check also<\/p>\n\n\n\n but there are no initial state differences.<\/p>\n\n\n\n Something I found interesting. I had a 2-month old ATP when I created the ADW. Immediately I saw that my old ATP was not using ASM, compared to the ADW, also that ADW was a cluster DB while the old ATP was single instance. <\/p>\n\n\n\n I recreated the ATP to check if this remained. But no. My new ATP was co-located on the same database as the ADW, so parameters are mostly the same as we could see above. <\/p>\n\n\n\n For historical reasons, I leave here the parameter changes between ATP created in June and end-August 2020. For paths, only the differences are highlighted:<\/p>\n\n\n\n Using the Free Tier of Oracle Cloud I created one Autonomous DB of each type – one Autonomous Transaction Processing and one Autonomous Data Warehouse (Autonomous JSON are not yet available). Then did run select name, display_value from v$parameter where isdefault=’FALSE’order by 1; on each of the DBs, I got the follow differences (empty means […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51,52,39],"tags":[],"class_list":["post-382","post","type-post","status-publish","format-standard","category-cloud","category-oci","category-oracle-19c","czr-hentry"],"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=382"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/382\/revisions"}],"predecessor-version":[{"id":383,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/382\/revisions\/383"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}select name, display_value <\/code>from v$parameter <\/code>where isdefault='FALSE'<\/code>order by 1;<\/code><\/p>\n\n\n\nParameter<\/th> ATP<\/th> ADW<\/th><\/tr><\/thead> optimizer_ignore_hints<\/td> <\/td> TRUE<\/td><\/tr> optimizer_ignore_parallel_hints<\/td> <\/td> TRUE<\/td><\/tr> parallel_degree_policy<\/td> <\/td> AUTO<\/td><\/tr> parallel_min_degree<\/td> <\/td> CPU<\/td><\/tr> pdb_lockdown<\/td> OLTP<\/td> DWCS<\/td><\/tr> pga_aggregate_target<\/td> 3000M<\/td> 5100M<\/td><\/tr> resource_manager_plan<\/td> FORCE:OLTP_PLAN<\/td> FORCE:DWCS_PLAN<\/td><\/tr> result_cache_max_result<\/td> <\/td> 1<\/td><\/tr> result_cache_mode<\/td> MANUAL<\/td> FORCE<\/td><\/tr> sga_target<\/td> 8000M<\/td> 3400M<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n select * <\/code>from database_properties;<\/code><\/p>\n\n\n\nparameter<\/th> ATP June 2020<\/th> ATP August 2020<\/th><\/tr><\/thead> audit_file_dest<\/td> \/u01\/…<\/td> \/u02\/…<\/td><\/tr> cluster_database<\/td> FALSE<\/td> TRUE<\/td><\/tr> control_files<\/td> \/u01\/…,\/u05\/…<\/td> +DATA\/…,+RECO\/….<\/td><\/tr> db_create_file_dest<\/td> \/u01\/app\/oracle\/oradata<\/td> +DATA<\/td><\/tr> db_name<\/td> FBPOD1<\/td> feio1pod<\/td><\/tr> db_recovery_file_dest<\/td> \/u05\/fra<\/td> +RECO<\/td><\/tr> de_recovery_file_dest_size<\/td> 5715584748749<\/td> 21167764M<\/td><\/tr> diagnostic_dest<\/td> \/u01\/app\/oracle<\/td> \/u02\/app\/oracle<\/td><\/tr> drcp_connection_limit<\/td> <\/td> 600<\/td><\/tr> external_keystore_credential<\/td> \/u01\/…\/wallets\/tde_seps<\/td> +DATA\/encrypt_wallet\/tde_seps<\/td><\/tr> gcs_server_processes<\/td> 0<\/td> 4<\/td><\/tr> instance_number<\/td> <\/td> 2<\/td><\/tr> log_archive_dest_1<\/td> <\/td> LOCATION=USE_DB_RECOVERY_FILE_DEST MANDATORY<\/td><\/tr> log_archive_dest_state_4<\/td> <\/td> ENABLE<\/td><\/tr> log_archive_dest_state_5<\/td> <\/td> ENABLE<\/td><\/tr> log_archive_dest_state_6<\/td> <\/td> ENABLE<\/td><\/tr> max_pdbs<\/td> 4096<\/td> <\/td><\/tr> processes<\/td> 20000<\/td> 40000<\/td><\/tr> sga_max_size<\/td> 321G<\/td> 301G<\/td><\/tr> thread<\/td> <\/td> 2<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"