{"id":2526,"date":"2019-11-30T23:23:51","date_gmt":"2019-12-01T05:23:51","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2526"},"modified":"2026-02-07T15:08:04","modified_gmt":"2026-02-07T21:08:04","slug":"oracle-tidbits-november-2019-oratidbit","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2019\/2526\/","title":{"rendered":"Oracle Tidbits &#8211; November 2019 #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 November 2019. 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 class=\"\"><tbody><tr><td>#OraTidbit Init parameter ADG_ACCOUNT_INFO_TRACKING controls login attempts of users on Oracle Active Data Guard standby databases. Value GLOBAL maintains a single global copy of users&#8217; account information across all databases (primary and standby). Login failures across all databases count towards the maximum count and logins anywhere will be denied when the count is reached.<\/td><\/tr><tr><td>#OraTidbit Oracle Database Personal Edition includes all of the Enterprise Edition components except Oracle RAC. Oracle PE is available on Linux and Windows platforms only and Oracle management packs cannot be used.<\/td><\/tr><tr><td>#OraTidbit #DB19c If you are not licensed for Oracle Multitenant, you may have up to 3 user-created PDBs in a container database. If you are licensed for Oracle Multitenant, you can create up to 252 PDBs on non-Exadata Enterprise Edition platforms, and 4096 PDBs on Exadata.<\/td><\/tr><tr><td>#OraTidbit Many #OrclDB performance features are available only on Exadata &#8211; Automatic Indexing, SQL Quarantine, Real-time statistics, High-frequency automatic optimizer statistics collection, In-Memory Column Store support for External Tables, MemOptimized Row Store, etc.<\/td><\/tr><tr><td>#OraTidbit Oracle Enterprise Edition security options such as Column-level encryption, Tablespace encryption, and redaction are available with the Advanced Security Option.<\/td><\/tr><tr><td>#OraTidbit The Oracle TimesTen Application-Tier Database Cache (TimesTen Cache) is a Database option for caching subsets of the database in the application tier. TimesTen Cache is included in Oracle Database Personal Edition.<\/td><\/tr><tr><td>#OraTidbit #AWS #OracleRDS Amazon RDS supports Oracle Database versions 19c (19.0.0), 18c (18.0.0) &amp; 12c (12.2.0.1 and 12.1.0.2). You can not create DB instances that use Oracle version 11.2.0.2 or lower.<\/td><\/tr><tr><td>#OraTidbit #AWS #OracleRDS There are two licensing options available on Amazon RDS: License Included and Bring Your Own License (BYOL). The License Included model is supported for Oracle Database Standard Edition One &amp; Two (SE1 &amp; SE2).<\/td><\/tr><tr><td>#OraTidbit #AWS #OracleRDS Amazon RDS supports Multi-AZ deployments for Oracle as a high-availability, failover solution. If you use the Bring Your Own License model, you must have a license for both the primary DB instance and the standby DB instance in a Multi-AZ deployment.<\/td><\/tr><tr><td>#OraTidbit #AWS #OracleRDS Several privileges are not available for the DBA role on an Amazon RDS DB instance &#8211; Alter database, Alter system, Create any directory, Drop any directory, Grant any privilege, Grant any role.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud #OrclDB For 1-node virtual machine DB systems, Oracle Cloud Infrastructure provides a &#8220;fast provisioning&#8221; option to create a DB system using Logical Volume Manager (LVM) as your storage management software instead of Automatic Storage Management (ASM).<\/td><\/tr><tr><td>#OraTidbit #OracleCloud #OrclDB Oracle Cloud Infrastructure offers 1-node DB systems on either bare metal or virtual machines and 2-node RAC DB systems on virtual machines. Bare metal DB systems have locally attached NVMe storage. VM DB system uses OCI block storage.<\/td><\/tr><tr><td>#OraTidbit Oracle database automatic block repair feature: the primary database automatically attempts to repair the corrupted block in real-time by fetching a good version of the same block from a physical standby database as soon as the corruption is detected. Requires the Oracle Active Data Guard option.<\/td><\/tr><tr><td>#OraTidbit #OrclDB Global Data Services is a highly effective solution for automatic workload management across a set of replicated databases. Oracle Data Guard, Oracle GoldenGate, or any other database replication technology, can be used to synchronize the databases. Requires the Oracle Active Data Guard license.<\/td><\/tr><tr><td>#OraTidbit #OrclDB Heat Map tracks data access and modification. Provides data access tracking at the segment-level and data modification tracking at the segment and row level. Enable with the HEAT_MAP initialization parameter. Requires the Oracle Advanced Compression option or the Oracle Database In-Memory option.<\/td><\/tr><tr><td>#OraTidbit Implement ILM strategy using the Automatic Data Optimization (ADO) feature &#8211; automate the compression and movement of data between different tiers of storage within the database. Requires the Oracle Advanced Compression option or the Oracle Database In-Memory option.<\/td><\/tr><tr><td>#OraTidbit Enabling block change tracking (BCT) facilitates fast incremental backups. Using BCT for Fast Incremental Backup on Physical Standby requires Oracle Active Data Guard option.<\/td><\/tr><tr><td>#OraTidbit ORAchk, EXAchk and Trace File Analyzer (TFA) are now combined into a single installer called Autonomous Health Framework (AHF 19.3). There is no change to the command-line tools. Use Oracle Support Doc ID 2550798.1 to download AHF.<\/td><\/tr><tr><td>#OraTidbit Install the Autonomous Health Framework (AHF) using command &#8220;ahf_setup&#8221;. TFA will be automatically started after install. ORAchk or EXAchk can be can be started to run automatic compliance check &#8220;orachk|exachk -autostart&#8221;.<\/td><\/tr><tr><td>#OraTidbit ORAchk\/EXAchk -autostart will perform compliance checks for the most severe problems at 2am, once a day; and all known problems once a week at 3am on a Sunday.<\/td><\/tr><tr><td>#OraTidbit Certain ORAchk and EXAchk checks have the capability to automatically fix problems when found. Use &#8220;orachk -showrepair {check_id}&#8221; to see what the repair command actually does.<\/td><\/tr><tr><td>#OraTidbit ORAchk and EXAchk are integrated with Database AutoUpgrade &amp; Cluster Verification Utility (CVU). They run ORAchk &amp; EXAchk in -preupgrade mode.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &amp;Twitter,\u00a0during weekdays in November 2019. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit Init parameter ADG_ACCOUNT_INFO_TRACKING controls login attempts of users on Oracle Active Data Guard standby databases. Value GLOBAL maintains a single global copy of users&#8217; &#8230; <a title=\"Oracle Tidbits &#8211; November 2019 #OraTidbit\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2019\/2526\/\" aria-label=\"Read more about Oracle Tidbits &#8211; November 2019 #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-2526","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tidbits","tag-oratidbit"],"acf":[],"jetpack-related-posts":[{"id":2534,"url":"https:\/\/bijoos.com\/oraclenotes\/2019\/2534\/","url_meta":{"origin":2526,"position":0},"title":"Oracle Tidbits &#8211; December 2019 #OraTidbit","author":"biju.thomas","date":"December 31, 2019","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in December 2019. December Tidbits are a repeat of the popular tidbits from 2019. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit DBA_AUTO_STAT_EXECUTIONS view in #db19c displays information about automatic\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":2225,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2225\/","url_meta":{"origin":2526,"position":1},"title":"Oracle Tidbits &#8211; August 2018 #oratidbit","author":"biju.thomas","date":"September 3, 2018","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0\u00a0Facebook,\u00a0Twitter,\u00a0and\u00a0Google+\u00a0during weekdays\u00a0in August 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit When the value of UNIFORM_LOG_TIMESTAMP_FORMAT init parameter is FALSE, trace files include a mix of timestamps using different precisions, with some timestamps\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":2174,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2174\/","url_meta":{"origin":2526,"position":2},"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":2595,"url":"https:\/\/bijoos.com\/oraclenotes\/2020\/2595\/","url_meta":{"origin":2526,"position":3},"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":[]},{"id":1761,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1761\/","url_meta":{"origin":2526,"position":4},"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":2058,"url":"https:\/\/bijoos.com\/oraclenotes\/2017\/2058\/","url_meta":{"origin":2526,"position":5},"title":"Oracle Tidbits &#8211; May 2017 #oratidbit","author":"Biju","date":"June 1, 2017","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on Facebook, Twitter and Google+\u00a0during weekdays\u00a0in May 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":[]}],"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\/2526","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=2526"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2526\/revisions"}],"predecessor-version":[{"id":2527,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2526\/revisions\/2527"}],"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=2526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}