{"id":2678,"date":"2021-05-31T18:23:45","date_gmt":"2021-05-31T23:23:45","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2678"},"modified":"2026-02-07T15:06:34","modified_gmt":"2026-02-07T21:06:34","slug":"oracle-tidbits-may-2021-oratidbit","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2021\/2678\/","title":{"rendered":"Oracle Tidbits: May 2021 #OraTidbit"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u201c<strong>Oracle *daily* TidBits<\/strong>\u201d (#oratidbit) 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 in May 2021. I hope you find these helpful to learn something new or to remind you of its existence and use. <\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>#OraTidbit #OracleCloud Always Free Oracle Cloud Service includes a maximum of 2 instances of Autonomous Database &#8211; Data Warehouse, Transaction Processing, JSON Database, and APEX Service. JSON Databases and APEX service are new in April.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB New in April. When you create dedicated Autonomous Database deployments on Oracle Public Cloud, you can deploy to X8M Exadata Database Machine systems.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB Graph Studio features include automated modeling to create graphs from database tables, an integrated notebook to run graph queries and analytics, and native graph and other visualizations. Graph Studio is a fully integrated, automated feature with Autonomous Database.<\/td><\/tr><tr><td>#OraTidbit #Middleware Oracle Coherence is a distributed cache and in-memory data grid solution that is used by applications for fast and reliable access to frequently used data.<\/td><\/tr><tr><td>#OraTidbit #OrclDB Oracle Data Pump is used for migrating application data. In the #db21c release, a checksum is added to the dump file to help to confirm that the file is valid after a transfer.<\/td><\/tr><tr><td>#OraTidbit #OrclDB Starting with #db21c release, Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object store. Oracle Data Pump supports dump file export from OCI PaaS database services to the object store.<\/td><\/tr><tr><td>#OraTidbit #OrclDB Starting with #db21c release, Oracle SQL*Loader accesses data in an object store by presenting user-defined credentials. Oracle SQL*Loader can specify credentials that you define to access and read data from files in an object store into Oracle Database.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB Autoscaling is enabled by default when you create an Autonomous Database instance. With auto-scaling enabled the database can use up to three times more CPU and IO resources.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB Autonomous Database CPU scale up or scale down operation does not require any downtime; it is seamless. OCI DBCS, all Public Cloud IaaS, and AWS RDS instance scaling require downtime.<\/td><\/tr><tr><td>#OraTidbit #db21c You can set the TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM dynamic parameter to define the default encryption algorithm for tablespace creation operations. For example if you set TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM to AES256 then future tablespace creation operations will use AES256 as the default encryption algorithm.<\/td><\/tr><tr><td>#OraTidbit #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.<\/td><\/tr><tr><td>#OraTidbit #db21c Oracle Automatic Storage Management Cluster File System (Oracle ACFS) automatic shrinking automatically shrinks an Oracle ACFS file system based on policy providing there is enough free storage in the volume.<\/td><\/tr><tr><td>#OraTidbit #db21c #Exadata Automatic indexing considers more cases for potential indexes and allows inclusion or exclusion of specific tables. An enhancement has been introduced to reduce the overhead of cursor invalidations when a new automatic index is created.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud Oracle provides two core mechanisms to work with data in object stores as part of the DBMS_CLOUD package or manually defining external tables. The DBMS_CLOUD package is available in Oracle Database 19c, starting with version 19.10.<\/td><\/tr><tr><td>#OraTidbit #OrclAPEX Oracle Application Express release 21.1 requires an Oracle Database release 12.1.0.2 or later, including Enterprise Edition (EE) and Express Edition (Oracle Database XE).<\/td><\/tr><tr><td>#OraTidbit #OrclDB Application Continuity masks outages from end-users and applications by recovering the in-flight work for impacted database sessions following outages. Application Continuity performs this recovery beneath the application so that the outage appears to the application as a slightly delayed execution.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB Autonomous Database has full support for data represented as JSON documents. In Autonomous Databases, JSON documents can coexist with relational data.<\/td><\/tr><tr><td>#OraTidbit Oracle Analytics Desktop provides standalone data exploration and visualization in a per-user desktop download. Oracle Analytics Desktop is the tool for quick exploration of sample data from multiple sources or for analyses and investigation of your own local data sets.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud Using Zero Downtime Migration to migrate your database from on-premises to OCI DBCS, Exadata Cloud Service, or Exadata Cloud at Customer involves creating a backup of the source database and restoring it to the target database, followed by an Oracle Data Guard sync and switchover of the primary role from the source database to the target database.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &amp;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 &#8211; Data Warehouse, Transaction Processing, JSON Database, and APEX &#8230; <a title=\"Oracle Tidbits: May 2021 #OraTidbit\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2021\/2678\/\" aria-label=\"Read more about Oracle Tidbits: May 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":[58],"class_list":["post-2678","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tidbits","tag-oratidbit"],"acf":[],"jetpack-related-posts":[{"id":2720,"url":"https:\/\/bijoos.com\/oraclenotes\/2021\/2720\/","url_meta":{"origin":2678,"position":0},"title":"Oracle Tidbits: November 2021 #OraTidbit","author":"biju.thomas","date":"November 30, 2021","format":false,"excerpt":"Oracle *daily* TidBits\u00a0(#oratidbit) were published on\u00a0Facebook &Twitter\u00a0during weekdays\u00a0in November 2021. I hope you find these helpful to learn something new or remind you of its existence and use #OraTidbit #OracleCloud #AutonomousDB You can configure a custom domain name or vanity URL for your APEX apps, Oracle REST Data Services (ORDS),\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":2665,"url":"https:\/\/bijoos.com\/oraclenotes\/2021\/2665\/","url_meta":{"origin":2678,"position":1},"title":"Oracle Tidbits: February 2021 #OraTidbit","author":"biju.thomas","date":"February 28, 2021","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in February 2021. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit Starting #db21c #orcldb Oracle Grid Infrastructure, you must configure the Grid Infrastructure Management Repository (GIMR) in a separate Oracle\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":2678,"position":2},"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":[]},{"id":2708,"url":"https:\/\/bijoos.com\/oraclenotes\/2021\/2708\/","url_meta":{"origin":2678,"position":3},"title":"Oracle Tidbits: September 2021 #OraTidbit","author":"biju.thomas","date":"September 30, 2021","format":false,"excerpt":"Oracle *daily* TidBits\u00a0(#oratidbit) were published on\u00a0Facebook &Twitter\u00a0during weekdays\u00a0in September 2021. I hope you find these helpful to learn something new or remind you of its existence and use #OraTidbit #OCI #AutonomousDB You can configure a custom domain name or vanity URL for your APEX apps, Oracle REST Data Services (ORDS),\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":2678,"position":4},"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":2595,"url":"https:\/\/bijoos.com\/oraclenotes\/2020\/2595\/","url_meta":{"origin":2678,"position":5},"title":"Oracle TidBits &#8211; July 2020 #OraTidBit","author":"biju.thomas","date":"July 31, 2020","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in July 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OrclDB #db20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All\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\/2678","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=2678"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2678\/revisions"}],"predecessor-version":[{"id":2679,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2678\/revisions\/2679"}],"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=2678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}