{"id":2702,"date":"2021-08-31T22:55:36","date_gmt":"2021-09-01T03:55:36","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2702"},"modified":"2026-02-07T15:06:33","modified_gmt":"2026-02-07T21:06:33","slug":"oracle-tidbits-august-2021-oratidbit","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2021\/2702\/","title":{"rendered":"Oracle Tidbits: August 2021 #OraTidbit"},"content":{"rendered":"\n

Oracle *daily* TidBits<\/strong> (#oratidbit) were published on\u00a0Facebook &<\/a>Twitter<\/a>\u00a0during weekdays in August 2021. I hope you find these helpful to learn something new or remind you of its existence and use <\/p>\n\n\n\n

#OraTidbit #NewFeature #db19c #db21c You can use the -switchGridHome option with gridSetup. sh to switch from one Oracle Grid Infrastructure home to another. This #db21c feature is available from 19.9.<\/td><\/tr>
#OraTidbit #NewFeature #db19c #db21c To securely capture and replicate individual pluggable database (PDB) changes to Oracle Autonomous Database, you can now use Oracle GoldenGate to provide per-PDB capture. This #db21c feature is available from 19.10.<\/td><\/tr>
#OraTidbit #NewFeature #db19c #db21c You can create SQL Macros (SQM) to factor out common SQL expressions and statements into reusable, parameterized constructs that can be used in other SQL statements. This #db21c feature is available from 19.7.<\/td><\/tr>
#OraTidbit #NewFeature #db19c #db21c Blockchain tables are append-only tables in which only insert operations are allowed. Rows in a blockchain table are made tamper-resistant by special sequencing and chaining algorithms. Deleting rows is either prohibited or restricted based on time. This #db21c feature is available from 19.10.<\/td><\/tr>
#OraTidbit #NewFeature #db19c #db21c New database initialization parameters MIN_AUTH_SERVERS, MAX_AUTH_SERVERS, and DRCP_DEDICATED_OPT have been added to configure Database Resident Connection Pooling (DRCP). This #db21c feature is available from 19.10.<\/td><\/tr>
#OraTidbit #AutonomousDB #NewFeature When you provision or clone an Autonomous Database instance you can select a patch level to apply upcoming patches. There are two patch-level options: Regular and Early.<\/td><\/tr>
#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>
#OraTidbit #NewFeature #db19c #db21c Database In-Memory “Base Level” feature allows the use of Database In-Memory with up to a 16GB column store without having to license the option. This #db21c feature is available from 19.8.<\/td><\/tr>
#OraTidbit #NewFeature #db19c #db21c Gradual Database Password Rollover for Applications feature allows an application can change its database passwords without an administrator having to schedule downtime. Use the PASSWORD_ROLLOVER_TIME password profile parameter. This #db21c feature is available from 19.12.<\/td><\/tr>
#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>
#OraTidbit #AutonomousDB #New When you provision or clone an Autonomous Database instance you can select a patch level to apply upcoming patches. There are two patch-level options: Regular and Early. The Early patch level allows you to use and to test upcoming patches before they are applied to all systems.<\/td><\/tr>
#OraTidbit #AutonomousDB #New When you enable Autonomous Data Guard, the system creates a standby database that is continuously updated with the changes from the primary database. You can enable Autonomous Data Guard with standby in the current region, a local standby, or with standby in a different region, a cross-region standby. You can also enable Autonomous Data Guard with both a local standby and a cross-region standby.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

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 home to another. This #db21c … 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_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[27],"tags":[101,102,58],"class_list":["post-2702","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tidbits","tag-autonomous-database","tag-oracle-21c","tag-oratidbit"],"acf":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/04\/oratidbit.jpg?fit=273%2C91&ssl=1","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2702","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=2702"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2702\/revisions"}],"predecessor-version":[{"id":2703,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2702\/revisions\/2703"}],"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=2702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}