{"id":2314,"date":"2018-10-02T22:18:44","date_gmt":"2018-10-03T03:18:44","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2314"},"modified":"2026-02-07T15:26:16","modified_gmt":"2026-02-07T21:26:16","slug":"exploring-autonomous-database-the-cdb","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2018\/2314\/","title":{"rendered":"Exploring Autonomous Database &#8211; The CDB"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I am the new kid in the block, wandering around the autonomous database cloud. Let me share something I found interesting. Though on Oracle Cloud Infrastructure, the ATP (Autonomous Transaction Processing) and the ADW (Autonomous Data Warehouse) have two different higher level menu and they appear to be different, they are not.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here are two ADW databases I created:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"842\" height=\"177\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/image.png?resize=842%2C177&#038;ssl=1\" alt=\"\" class=\"wp-image-2315\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/image.png?w=842&amp;ssl=1 842w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/image.png?resize=300%2C63&amp;ssl=1 300w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/image.png?resize=768%2C161&amp;ssl=1 768w\" sizes=\"auto, (max-width: 842px) 100vw, 842px\" \/><figcaption>Autonomous Data Warehouse Instances Created on 10 Sep and 2 Oct.\u00a0<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Here are two ATP databases created:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"863\" height=\"182\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/image-1.png?resize=863%2C182&#038;ssl=1\" alt=\"\" class=\"wp-image-2316\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/image-1.png?w=863&amp;ssl=1 863w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/image-1.png?resize=300%2C63&amp;ssl=1 300w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/image-1.png?resize=768%2C162&amp;ssl=1 768w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\" \/><figcaption>Autonomous Transaction Processing Instances Created on 10 Sep and 2 Oct.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Each instance of the ADW and ATP\u00a0 is a pluggable database. The (pluggable) databases created on Sep 10th &#8211; one ATP and one ADW &#8211; belonged to the same CDB. Similarly<g class=\"gr_ gr_8 gr-alert sel gr_gramm gr_replaced gr_inline_cards gr_disable_anim_appear Punctuation only-ins replaceWithoutSep\" id=\"8\" data-gr-id=\"8\">,<\/g> the (pluggable) databases created on Oct 2 &#8211; again one ATP and one ADW &#8211; belonged to the same CDB. So, it appears that at the CDB level, both ATP and ADW have the same configuration. The differences are only in the PDB. And my guess is that Oracle creates the new instances (ATP and ADW) in a CDB until that CDB reaches its capacity threshold, then moves to the next CDB.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The database properties are same as well for ATP and ADW. The only (obviously) difference is the GLOBAL_DB_NAME value.\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Each instance of the ADW and ATP  is a pluggable database. It appears that at the CDB level, both ATP and ADW have the same configuration. The differences are only in the PDB. <\/p>\n","protected":false},"author":1,"featured_media":2317,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[4],"tags":[101,55],"class_list":["post-2314","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-autonomous","tag-autonomous-database","tag-oracle-cloud"],"acf":[],"jetpack-related-posts":[{"id":2492,"url":"https:\/\/bijoos.com\/oraclenotes\/2019\/2492\/","url_meta":{"origin":2314,"position":0},"title":"Oracle Autonomous Database: A DBA Perspective","author":"biju.thomas","date":"September 20, 2019","format":false,"excerpt":"When more people started using Autonomous Database services, more Admin tools are made available as well. When ADW was introduced, all the DBA had for monitoring or diagnosis or utilization was only the Service Console. Here are some administrative enhancements in ATP\/ADW we saw in the past 1+ year. July\u2026","rel":"","context":"In &quot;Certification &amp; Learning&quot;","block_context":{"text":"Certification &amp; Learning","link":"https:\/\/bijoos.com\/oraclenotes\/category\/certification-learning\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":2328,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2328\/","url_meta":{"origin":2314,"position":1},"title":"Exploring Autonomous Databases &#8211; Client Credentials","author":"biju.thomas","date":"October 4, 2018","format":false,"excerpt":"The wallet zip file from ATP or ADW includes the connection information for all the ATP and ADW databases you have created under the cloud account, even though the credential zip file name is \"wallet_.zip\".","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":2319,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2319\/","url_meta":{"origin":2314,"position":2},"title":"Exploring Autonomous Database &#8211; Init Parameters","author":"biju.thomas","date":"October 3, 2018","format":false,"excerpt":"ATP has a minimum number of initialization parameters configured, whereas ADW has several initialization parameters. Though my ATP and ADW databases are both 1 oCPU \/ 1 TB size, the SGA and PGA values are different. ADW has a bigger PGA, ATP has bigger SGA.","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":2462,"url":"https:\/\/bijoos.com\/oraclenotes\/2019\/2462\/","url_meta":{"origin":2314,"position":3},"title":"Oracle Tidbits: July 2019 #oratidbit","author":"biju.thomas","date":"July 31, 2019","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter, during weekdays in July 2019. Hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit You can create Autonomous Database dedicated deployments. The order of deployment is Autonomous Exadata Infrastructure (#Exadata), Autonomous Container Database\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2558,"url":"https:\/\/bijoos.com\/oraclenotes\/2020\/2558\/","url_meta":{"origin":2314,"position":4},"title":"Oracle Tidbits &#8211; March 2020 #OraTidbit","author":"biju.thomas","date":"March 31, 2020","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in March 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #Db20c Initialization parameters AUDIT_FILE_DEST, AUDIT_SYS_OPERATIONS, AUDIT_SYSLOG_LEVEL, AUDIT_TRAIL (Traditional auditing parameters) are deprecated in Oracle Database 20c.#OraTidbit #db20c Traditional auditing\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2622,"url":"https:\/\/bijoos.com\/oraclenotes\/2020\/2622\/","url_meta":{"origin":2314,"position":5},"title":"Oracle Tidbits &#8211; October 2020 #OraTidbit","author":"biju.thomas","date":"October 31, 2020","format":false,"excerpt":"Happy Halloween! \u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in October 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #AutonomousDB The default operation mode of Autonomous Database is Read\/Write. If you select Read-Only mode users can\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=2314"}],"version-history":[{"count":3,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2314\/revisions"}],"predecessor-version":[{"id":2322,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2314\/revisions\/2322"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media\/2317"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=2314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}