{"id":2726,"date":"2021-12-31T23:11:00","date_gmt":"2022-01-01T05:11:00","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2726"},"modified":"2026-02-07T15:09:44","modified_gmt":"2026-02-07T21:09:44","slug":"oracle-tidbits-december-2021-oratidbit","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2021\/2726\/","title":{"rendered":"Oracle Tidbits: December 2021 #OraTidbit"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">  <strong>Oracle *daily* TidBits<\/strong>\u00a0(#oratidbit) were published on\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.facebook.com\/hashtag\/oratidbit\" target=\"_blank\">Facebook &amp;<\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/twitter.com\/search?q=%23oratidbit\" target=\"_blank\">Twitter<\/a>\u00a0during weekdays\u00a0in December 2021. I hope you find these helpful to learn something new or remind you of its existence and use.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-pale-ocean-gradient-background has-background\"><tbody><tr><td>#OraTidbit #NewFeature #db19c #db21c Gradual Database Password Rollover feature allows an application to change its database passwords without scheduling downtime. Use the PASSWORD_ROLLOVER_TIME password profile parameter. This #db21c feature is available from 19.12.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB #New When you provision or clone an Autonomous Database instance you can select a patch level to apply upcoming patches. Regular and Early. The Early patch level allows you to use and test upcoming patches before they are applied to all systems.<\/td><\/tr><tr><td>#OraTidbit #NewFeature #db19c #db21c Application Continuity Protection Check (ACCHK) provides guidance on the level of protection for each application that uses Application Continuity and assists you to increase protection if required. This #db21c feature is available from 19.11.<\/td><\/tr><tr><td>#OraTidbit #NewFeature #db19c #db21c Immutable tables are insert-only tables in which existing data cannot be modified. Deleting rows is either prohibited or restricted based on the insertion time of the rows. This #db21c feature is available from 19.11.<\/td><\/tr><tr><td>#OraTidbit #OrclAPEX Oracle APEX Application Development (APEX Service) is a feature-scoped service of Autonomous Database that enables developers to rapidly build and deploy low-code APEX applications. APEX Service supports Oracle REST Data Services endpoints.<\/td><\/tr><tr><td>#OraTidbit #OracleXE Oracle Advanced Compression, Advanced Security, Database In-Memory, Database Vault, Label Security, Multitenant and Partitioning options are included with the Oracle XE release.<\/td><\/tr><tr><td>#OraTidbit Restricted use licenses for Oracle Advanced Compression and Oracle Advanced Security are granted when performing a migration to OCI using Oracle Zero Downtime Migration or Oracle Cloud Infrastructure Database Migration (DMS).<\/td><\/tr><tr><td>#OraTidbit #OCI #AutonomousDB You can configure a custom domain name or vanity URL for your APEX apps, Oracle REST Data Services (ORDS), and developer tools by placing an Oracle Cloud Infrastructure Load Balancer directly in front of your Autonomous Database.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB #OCI Oracle Cloud Infrastructure Console provides information on Autonomous Database maintenance windows and patch level and provides a customer contacts area to manage the contacts to receive information on operational issues and service announcements.<\/td><\/tr><tr><td>#OraTidbit #OracleXE Multitenancy is included in XE and you are licensed to create up to 252 PDBs, however, the actual number of PDBs you can create might be less due to XE resource limits.<\/td><\/tr><tr><td>#OraTidbit #db21c A temporary tablespace can grow to a very large size due to spikes in temporary space usage by queries. Automatic temporary tablespace shrink is a feature that shrinks the temporary tablespace in the background when temporary space usage has subsided.<\/td><\/tr><tr><td>#OraTidbit The #db21c database incorporates workload monitoring to establish what materialized views are needed. Based on the decisions it makes, materialized views and materialized view logs are created and maintained automatically without any manual interaction.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud #OCI Oracle Cloud Infrastructure Operations Insights is an OCI native service that provides 360-degree insight into the database and host resource utilization and capacity.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud In metric-based autoscaling, when system usage meets a specific defined metric threshold, autoscaling dynamically resizes the instance pool in near-real-time. As load increases, the pool scales out. As load decreases, the pool scales in.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud Shielded instances harden the firmware security on bare metal hosts and virtual machines (VMs) to defend against malicious boot-level software. They use the combination of Secure Boot, Measured Boot, and the Trusted Platform Module (TPM) to harden.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud A cluster network is a pool of high-performance computing (HPC), GPU, or Optimized instances connected with a high-bandwidth, ultra-low-latency network. Each cluster node is a bare metal machine located in close physical proximity to the other nodes.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Oracle *daily* TidBits\u00a0(#oratidbit) were published on\u00a0Facebook &amp;Twitter\u00a0during weekdays\u00a0in December 2021. I hope you find these helpful to learn something new or remind you of its existence and use. #OraTidbit #NewFeature #db19c #db21c Gradual Database Password Rollover feature allows an application to change its database passwords without scheduling downtime. Use the PASSWORD_ROLLOVER_TIME password profile parameter. This &#8230; <a title=\"Oracle Tidbits: December 2021 #OraTidbit\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2021\/2726\/\" aria-label=\"Read more about Oracle Tidbits: December 2021 #OraTidbit\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":2175,"comment_status":"closed","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":[27],"tags":[102,58],"class_list":["post-2726","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tidbits","tag-oracle-21c","tag-oratidbit"],"acf":[],"jetpack-related-posts":[{"id":2702,"url":"https:\/\/bijoos.com\/oraclenotes\/2021\/2702\/","url_meta":{"origin":2726,"position":0},"title":"Oracle Tidbits: August 2021 #OraTidbit","author":"biju.thomas","date":"August 31, 2021","format":false,"excerpt":"Oracle *daily* TidBits (#oratidbit) were published on\u00a0Facebook &Twitter\u00a0during weekdays in August 2021. I hope you find these helpful to learn something new or remind you of its existence and use #OraTidbit #NewFeature #db19c #db21c You can use the -switchGridHome option with gridSetup. sh to switch from one Oracle Grid Infrastructure\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":2668,"url":"https:\/\/bijoos.com\/oraclenotes\/2021\/2668\/","url_meta":{"origin":2726,"position":1},"title":"Oracle Tidbits: March 2021 #OraTidbit","author":"biju.thomas","date":"April 2, 2021","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in March 2021. I hope you find these helpful to learn something new or to remind you of its existence and use. It's a shorter list this month, as I did not tweet every day. #OraTidbit #OracleCloud Oracle Machine Learning for Python\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":2696,"url":"https:\/\/bijoos.com\/oraclenotes\/2021\/2696\/","url_meta":{"origin":2726,"position":2},"title":"Oracle Tidbits: July 2021 #OraTidbit","author":"biju.thomas","date":"July 31, 2021","format":false,"excerpt":"Oracle *daily* TidBits (#oratidbit) were published on\u00a0Facebook &Twitter\u00a0during weekdays in July 2021. I hope you find these helpful to learn something new or remind you of its existence and use. #OraTidbit #db21c The attention log is a structured, externally modifiable file that contains information about critical and highly visible 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":2658,"url":"https:\/\/bijoos.com\/oraclenotes\/2021\/2658\/","url_meta":{"origin":2726,"position":3},"title":"Oracle Tidbits &#8211; January 2021 #OraTidbit","author":"biju.thomas","date":"February 1, 2021","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in January 2021. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #Exadata The Oracle Database 21c incorporates workload monitoring to establish what materialized views are needed. Based on the decisions,\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":2641,"url":"https:\/\/bijoos.com\/oraclenotes\/2020\/2641\/","url_meta":{"origin":2726,"position":4},"title":"Happy New Year 2021! &#8211; Oracle Tidbits December 2020 #OraTidbit","author":"biju.thomas","date":"December 31, 2020","format":false,"excerpt":"Wishing everyone a very Happy New Year! 2020 was challenging for all of us and full of uncertainties. I pray the coming year is the opposite, filled with hope and good health. I want to thank all of you for the love and support. God bless us all and hope\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":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2020\/12\/Happy-New-Year-2021.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2020\/12\/Happy-New-Year-2021.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2020\/12\/Happy-New-Year-2021.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2020\/12\/Happy-New-Year-2021.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2020\/12\/Happy-New-Year-2021.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":2678,"url":"https:\/\/bijoos.com\/oraclenotes\/2021\/2678\/","url_meta":{"origin":2726,"position":5},"title":"Oracle Tidbits: May 2021 #OraTidbit","author":"biju.thomas","date":"May 31, 2021","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in May 2021. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #OracleCloud Always Free Oracle Cloud Service includes a maximum of 2 instances of Autonomous Database - Data Warehouse, Transaction\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\/04\/oratidbit.jpg?fit=273%2C91&ssl=1","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2726","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=2726"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2726\/revisions"}],"predecessor-version":[{"id":2727,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2726\/revisions\/2727"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media\/2175"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=2726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}