OOW 2019 - Significant Oracle Multitenant Announcements
OracleDBPro - Pini Dibask Blog
by
4y ago
BackgroundDuring Oracle OpenWorld 2019, there were significant announcements related to my favorite Oracle option in recent years - the Oracle Multitenant option. In this blog post I will summarize the highlights. Oracle 19c Exciting News Prior to Oracle 19c (Oracle 12c through 18c), in order to use pluggable databases (usually for consolidation purposes), one had to own the multitenant option which is an extra option (=cost) on top of the oracle enterprise edition. There was also a single-tenant option which allows running the multitenant architecture but with only one pluggable database; he ..read more
Visit website
Oracle 19c - Automation and Manageability Enhancements
OracleDBPro - Pini Dibask Blog
by
5y ago
Introduction DBAs should always aim to automate their tasks and avoid as much as possible manual repetitive tasks. This was always true; however, not always implemented; now with the new DevOps era, I see more and more Database teams who have been "hit" by the DevOps trend which demands more automation and collaboration in order to accelerate application updates & delivery DBCA Silent Mode  One of the common and popular ways to achieve automation when it comes to installation, configuration, and patching, is to leverage Oracle DBCA (Database Configuration Assistant) tool with the silent m ..read more
Visit website
Oracle 19c New Features - Automatic flashback standby database when Primary database is flashed back
OracleDBPro - Pini Dibask Blog
by
5y ago
Prior to Oracle 19c, when using the "Flashback Database" feature on a primary database in a data guard environment would result in a standby database which is no longer in sync with the primary database; in previous releases, in order to ensure both primary and secondary are synced, then a manual procedure to flash back to standby database was required. Starting with Oracle 19c, a standby database that is in a mounted state can automatically follow the primary database after a RESETLOGS operation on the primary. This simplifies standby management after a RESETLOGS operation on the primary. T ..read more
Visit website
Oracle 19c Privilege Analysis - Positive Licensing Update!
OracleDBPro - Pini Dibask Blog
by
5y ago
Introduction One of the most valuable security related features which have been introduced recently (in Oracle 12c to be specific) is the Privilege Analysis feature. Using this feature, the DBA can easily understand which privileges are actually being used by users. Once the analysis has been completed, the DBA can revoke all of the unnecessary privileges/roles. I actually wrote a dedicated blog post about this topic with some code examples. See: http://oracledbpro.blogspot.com/2015/12/oracle-12c-privilege-analysis.html Oracle Database 19c Positive Licensing Update! Prior to version 19c, thi ..read more
Visit website
Oracle RAC with Standard Edition (SE) 2 is not supported in 19c
OracleDBPro - Pini Dibask Blog
by
5y ago
Introduction For so many years (starting in the early 2000's, when 10g was released) Oracle RAC option (Real Application Clusters) was available with Oracle Standard Editions; even when Oracle introduced Oracle Standard Edition 2 (SE2) back in version 12.1.0.2 (see my blog post about SE2 here), they offered the RAC option. 19c Update With the introduction of the recent 19c release, Oracle did a pretty significant change with SE2 which I believe is worthy of a blog post. Oracle RAC has been de-supported effective with Oracle Database 19c. According to Oracle, "SE2 Socket requirements are hard ..read more
Visit website
Oracle Database 19c is Live!
OracleDBPro - Pini Dibask Blog
by
5y ago
I hope that by now most of you already heard the exciting news that Oracle 19c is GA on Linux x86-64 (since 25-Apr-2019) and on Oracle Solaris SPARC 64-bit (since 26-Apr-2019). Other platforms such as Windows, HP UX, IBM AIX, etc. are targeted to be release in Q2CY19 according to Document ID 742060.1 on MOS (My Oracle Support) titled "Release Schedule of Current Database Releases" Where should I test some of the cool new features and enhancements? You can access LiveSQL which is a cloud-based, free platform to rung and share SQL and PL/SQL. For more info, see: https://blogs.oracle.com/oracle ..read more
Visit website
How to mitigate the performance/protection trade-off in Oracle Data Guard - Part 2 (Axxana)
OracleDBPro - Pini Dibask Blog
by
5y ago
IntroductionIn the previous blog post titled "How to mitigate the performance/protection trade-off in Oracle Data Guard"  I reviewed the common performance vs. protection trade-off between the various data protection modes in Data Guard : Maximum performance (default), maximum availability and maximum protection. In that blog post I mentioned how far syn can be used in order to achieve both performance (due to the smaller network latency between primary and local far sync instance) while allowing for higher data protection as the far sync instance is always synced with the primary database ..read more
Visit website
How to mitigate the performance/protection trade-off in Oracle Data Guard
OracleDBPro - Pini Dibask Blog
by
5y ago
Introduction The most know trade-off in Oracle Data Guard is the performance vs. protection. Oracle Data Guard brings several protection modes, which brings companies the flexibility in choosing the right configuration in order to meet the application SLA policies. Data Protection Modes There are 3 protection modes in Oracle Data Guard, which can be summarized in the following table: Data Protection Modes - Key Considerations  Maximum Performance = compromise on protection  Maximum Protection = compromise on performance (usually) Better to use at least 2 standby databases whe ..read more
Visit website

Follow OracleDBPro - Pini Dibask Blog on FeedSpot

Continue with Google
Continue with Apple
OR