{"id":2431,"date":"2019-05-31T11:11:23","date_gmt":"2019-05-31T16:11:23","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2431"},"modified":"2026-02-07T15:08:05","modified_gmt":"2026-02-07T21:08:05","slug":"oracle-tidbits-may-2019-oratidbit","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2019\/2431\/","title":{"rendered":"Oracle Tidbits: May 2019 #oratidbit"},"content":{"rendered":"\n<p>  \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> during weekdays in May 2019. Hope you find these helpful to learn something new or to remind you of its existence and use.      <\/p>\n\n\n\n<table class=\"wp-block-table\"><tbody><tr><td>#oratidbit #orcldb Starting with Oracle Grid Infrastructure 19c, the installation wizard (gridSetup.sh) enables you to perform a dry-run mode upgrade to check your system\u2019s upgrade readiness. It helps anticipate potential problems with the system setup and avoids upgrade failures.<\/td><\/tr><tr><td>#oratidbit #orcldb Datapump parameters MAX_DATAPUMP_JOBS_PER_PDB and MAX_DATAPUMP_PARALLEL_PER_JOB give DBAs more control over the number of jobs that can be started in a container DB, and the number of parallel workers that can be used for an individual job, respectively.<\/td><\/tr><tr><td>#oratidbit #orcldb #db19c When INMEMORY_SIZE init parameter is greater than 0, Oracle Database Resource Manager is automatically enabled. The Resource Manager is required to take advantage of In-Memory Dynamic Scans.<\/td><\/tr><tr><td>#oratidbit #oraclecloud The #GlusterFS shared file system creates a high availability storage environment on Oracle Cloud Infrastructure Compute Classic instances using a distributed GlusterFS volume.<\/td><\/tr><tr><td>#oratidbit #OracleOEM You can upgrade your Enterprise Manager Cloud Control installation to Version 13c Release 3 (13.3.0.0) directly from 13c Rel 2 (13.2.0.0), 13c Rel 1 (13.1.0.0) or 12c Rel 5 (12.1.0.5).<\/td><\/tr><tr><td>#oratidbit #OracleOEM Oracle Enterprise Manager Cloud Control Version 13c Release 3 (13.3.0.0) Management Service (OMS) can communicate with Oracle Management Agent versions 13c Rel 3 (13.3.0.0), 13c Rel 2 (13.2.0.0), 13c Rel 1 (13.1.0.0) or 12c Rel 5 (12.1.0.5).<\/td><\/tr><tr><td>#oratidbit #OracleVM (3.4.5+) provides support for Hybrid Columnar Compression (HCC) on Oracle Database Release 18c or higher with Oracle ZFS Storage Appliance and Oracle FS1 Series Flash Storage Systems.<\/td><\/tr><tr><td>#oratidbit #OracleOEM includes a restricted-use license of the Oracle Database Enterprise Edition for use only with the Oracle Management Repository and these complementary repositories: AWR Warehouse, Ops Center, Real User Experience Insight, Load Testing, and Test Manager.<\/td><\/tr><tr><td>#oratidbit #OracleCloud Oracle Cloud Infrastructure Compute offers four shapes designed to meet a range of computing and application requirements: Standard (general purpose), DenseIO (large database and big data), GPU &amp; High-Performance Computing (HPC).<\/td><\/tr><tr><td>#oratidbit #thinkautonomous #OracleATP and #OracleADW support setting a network Access Control List (ACL) to restrict access to a specific ATP database (only accepts connections from addresses specified on the ACL and rejects all other client connections).<\/td><\/tr><tr><td>#oratidbit #thinkautonomous #OracleATP and #OracleADW support cloning where you can choose to clone either the full database or only the database metadata.<\/td><\/tr><tr><td>#oratidbit #OracleASM You can upgrade Oracle ASM 11g 11.2 and later without shutting down an Oracle RAC database by performing a rolling upgrade either of individual nodes or of a set of nodes in the cluster.<\/td><\/tr><tr><td>#oratidbit #db19c Oracle Multimedia is desupported in Oracle Database 19c, and the implementation is removed. The ORDIM component remains in the registry and still has a VALID status. The objects and packages no longer function and raise exceptions when used.<\/td><\/tr><tr><td>#oratidbit #Linux Spacewalk provides a set of tools for managing the Oracle Linux software life cycle. Spacewalk helps to automate a kickstart installation, system configuration, maintenance tasks;  simplifies applying patches and software updates, and auditing system security.<\/td><\/tr><tr><td>#oratidbit Oracle Management Cloud Log Analytics is a unified, integrated cloud solution to monitor, aggregate, index, analyze, search, explore, and correlate all log data from applications and system infrastructure.<\/td><\/tr><tr><td>#oratidbit ALL_TRIGGERS_AE, USER_TRIGGERS_AE and DBA_TRIGGERS_AE are new views in #db19c that describe triggers on tables across all editions.<\/td><\/tr><tr><td>#oratidbit DBA_AUTO_INDEX_CONFIG displays the current configuration parameter settings for automatic indexing in #db19c. Set automatic indexing configuration parameters by using the DBMS_AUTO_INDEX.CONFIGURE procedure.<\/td><\/tr><tr><td>#oratidbit DBA_AUTO_STAT_EXECUTIONS in #db19c displays information about automatic optimizer statistics collection tasks, which are executed by the automated maintenance tasks infrastructure (known as AutoTask).<\/td><\/tr><tr><td>#oratidbit The CLUSTER_DATABASE_INSTANCES parameter is deprecated in #db19c. Starting with Oracle Database release 19c, version 19.1, the number of configurable Oracle RAC instances is derived from Oracle Clusterware.<\/td><\/tr><\/tbody><\/table>\n","protected":false},"excerpt":{"rendered":"<p>\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &amp;Twitter, during weekdays in May 2019. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #orcldb Starting with Oracle Grid Infrastructure 19c, the installation wizard (gridSetup.sh) enables you to perform a dry-run mode upgrade to check your system\u2019s upgrade &#8230; <a title=\"Oracle Tidbits: May 2019 #oratidbit\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2019\/2431\/\" aria-label=\"Read more about Oracle Tidbits: May 2019 #oratidbit\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":2175,"comment_status":"open","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":[58],"class_list":["post-2431","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tidbits","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\/2431","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=2431"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2431\/revisions"}],"predecessor-version":[{"id":2432,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2431\/revisions\/2432"}],"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=2431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}