{"id":2696,"date":"2021-07-31T22:01:00","date_gmt":"2021-08-01T03:01:00","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2696"},"modified":"2026-02-07T15:06:33","modified_gmt":"2026-02-07T21:06:33","slug":"oracle-tidbits-july-2021-oratidbit","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2021\/2696\/","title":{"rendered":"Oracle Tidbits: July 2021 #OraTidbit"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Oracle *daily* TidBits<\/strong> (#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 in July 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\"><table><tbody><tr><td>#OraTidbit #db21c The attention log is a structured, externally modifiable file that contains information about critical and highly visible database events. Use the attention log to quickly access information about critical events that need action. One attention log for each DB.<\/td><\/tr><tr><td>#OraTidbit V$DIAG_ALERT_EXT view shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR) for the current container (PDB). A message_level of 1 corresponds to critical errors that need immediate action.<\/td><\/tr><tr><td>#OraTidbit #db21c With dynamic cache resizing the sequence cache size is auto-tuned based on the rate of consumption of sequence values. This means the cache can automatically grow and shrink over time depending on usage while never falling below the DDL specified cache size.<\/td><\/tr><tr><td>#OraTidbit #db21c Read-only Oracle homes where all configuration data and log files reside outside of the read-only Oracle home are the default option for Oracle Database installations and upgrades.<\/td><\/tr><tr><td>#OraTidbit To securely capture and replicate individual PDB changes to Oracle Autonomous Database, in #db21c, you can use Oracle GoldenGate per-PDB capture. Provide local user credentials to connect to an individual PDB and replicate the data from just that PDB to ADB or ATP.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud Oracle Machine Learning for Python (#OML4Py) on Autonomous Database provides a Python API to explore and prepare data, and build and deploy machine learning models using the database as a high-performance compute engine.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB Oracle will generate one-off patches for critical service requests filed with MOS for Oracle Autonomous DB on Dedicated Exadata Infrastructure when you and Oracle agree that the problem is critical and requires a one-off patch for immediate resolution.<\/td><\/tr><tr><td>#OraTidbit #orcldb Oracle Enterprise Manager Cloud Management Pack for Oracle Database helps to set up a Database Cloud and operate the Database as a Service model.<\/td><\/tr><tr><td>#OraTidbit #db21c Starting with Oracle Database 21c Oracle Data Pump expdp and impdp support use of object store URIs for the DUMPFILE parameter. To use this feature for exports or imports from an object store the CREDENTIAL parameter must be set.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud The Fusion Analytics Warehouse service includes Oracle Analytics Cloud powered by Oracle Autonomous Data Warehouse. The service extracts and loads data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB New in July 2021. You can view Autonomous Database patch information, including a list of resolved issues and components. The view DBA_CLOUD_PATCH_INFO is available to the ADMIN user.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud Oracle Machine Learning for Python (#OML4Py) on Autonomous Database provides a Python API to explore and prepare data, and build and deploy machine learning models using the database as a high-performance compute engine.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB Oracle will generate one-off patches for critical service requests filed with MOS for Oracle Autonomous DB on Dedicated Exadata Infrastructure when you and Oracle agree that the problem is critical and requires a one-off patch for immediate resolution.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud The Fusion Analytics Warehouse service includes Oracle Analytics Cloud powered by Oracle Autonomous Data Warehouse. The service extracts and loads data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud EPM Automate Cloud Service enables users to remotely perform tasks within Oracle Enterprise Performance Management Cloud environments. EPM Cloud Service Administrators can automate many repeatable tasks.<\/td><\/tr><tr><td>#OraTidbit #db21c Starting with Oracle Database 21c Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object-store.<\/td><\/tr><\/tbody><\/table><figcaption>#OraTidbit July Edition<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Oracle *daily* TidBits (#oratidbit) were published on\u00a0Facebook &amp;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 events. Use the attention log &#8230; <a title=\"Oracle Tidbits: July 2021 #OraTidbit\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2021\/2696\/\" aria-label=\"Read more about Oracle Tidbits: July 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-2696","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tidbits","tag-oratidbit"],"acf":[],"jetpack-related-posts":[{"id":1761,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1761\/","url_meta":{"origin":2696,"position":0},"title":"Oracle Tidbits &#8211; September 2016","author":"Biju","date":"October 3, 2016","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published at\u00a0https:\/\/www.facebook.com\/oraclenotes\u00a0on weekdays\u00a0in September\u00a02016. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you of its existence and use\u2026\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":"Oracle TidBit","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2014\/05\/TidBit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1624,"url":"https:\/\/bijoos.com\/oraclenotes\/2015\/1624\/","url_meta":{"origin":2696,"position":1},"title":"Oracle Tidbits \u2013 October 2015 #oratidbit","author":"Biju","date":"November 2, 2015","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published at\u00a0https:\/\/www.facebook.com\/oraclenotes\u00a0on weekdays\u00a0in October\u00a02015. There were no tidbits during the week of OOW15. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new\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":2053,"url":"https:\/\/bijoos.com\/oraclenotes\/2017\/2053\/","url_meta":{"origin":2696,"position":2},"title":"Oracle Tidbits &#8211; April 2017 #oratidbit","author":"Biju","date":"May 1, 2017","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on Facebook, Twitter and Google+\u00a0during weekdays\u00a0in April 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you\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\/2017\/02\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2672,"url":"https:\/\/bijoos.com\/oraclenotes\/2021\/2672\/","url_meta":{"origin":2696,"position":3},"title":"Oracle Tidbits: April 2021 #OraTidbit","author":"biju.thomas","date":"May 1, 2021","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in April 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 #AutonomousDB Database Actions Data Load option\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":2174,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2174\/","url_meta":{"origin":2696,"position":4},"title":"Oracle Tidbits &#8211; April 2018 #oratidbit","author":"biju.thomas","date":"April 30, 2018","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on Facebook, Twitter, and Google+\u00a0during weekdays\u00a0in April 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c #Dataguard Broker 18c VALIDATE DATABASE SPFILE performs a comparison of server parameter file (SPFILE) entries between the\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\/2018\/04\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2144,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2144\/","url_meta":{"origin":2696,"position":5},"title":"Oracle Tidbits &#8211; February 2018 #oratidbit","author":"Biju","date":"March 1, 2018","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on Facebook, Twitter, and Google+\u00a0during weekdays\u00a0in February 2018. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you\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\/2017\/02\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"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\/2696","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=2696"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2696\/revisions"}],"predecessor-version":[{"id":2697,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2696\/revisions\/2697"}],"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=2696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}