This Log Buffer Edition covers many aspects discussed this week in the realms of Oracle, SQL Server and MySQL.

Oracle:

• Oracle and Informatica have a very close working relationship and one of the recent results of this collaboration is the joint project done by Informatica and our Oracle ISV Engineering team to test the performance of Informatica software with Oracle Database 12c In-memory on Oracle SPARC systems.
• The only thing you can do easily is be wrong, and that’s hardly worth the effort.
• Enterprise Manager 13c: What’s New in Database Lifecycle Management. …

What better to do during the holiday season than to read the Log Buffer? This log buffer edition is here to add some sparkle to Oracle, MySQL and SQL Server on your days off.

Oracle:

• Ops Center version 12.3.1 has just been released. There are a number of enhancements here.
• Oracle R Enterprise (ORE) 1.5 is now available for download on all supported platforms with Oracle R Distribution 3.2.0 / R-3.2.0. ORE 1.5 introduces parallel distributed implementations of Random Forest, Singular Value Decomposition (SVD), and Principal Component Analysis (PCA) that operate on ore.frame objects.
• Create a SOA Application in JDeveloper 12c Using Maven …

VMware Continuent 5.0 is a complete data replication solution that includes all the functionality you need at one low price. In this webinar-on-demand, you’ll see how VMware Continuent delivers:  Migration. Replicate from an old version of Oracle, often running on non-Linux platform (Windows, AIX, HP-UX, Solaris), to a new version of Oracle (often running in Linux). VMware Continuent supports

This week, the Log Buffer Edition digs deep into the world of Oracle, SQL Server and MySQL and brings you some of the best blog posts around.

Oracle:

• Regardless of what type of industry or business you are involved in, the bottom-line goal is to optimize sales; and that involves replacing any archaic tech processes with cutting-edge technology and substituting any existing chaos with results-driven clarity.
• Oracle Private Cloud Appliance 2.1.1 Released.
• Every version of the optimizer enhances existing mechanisms and introduces new features, while 12c …

The show goes on. This Log Buffer Edition picks some blogs which are discussing new and old features of Oracle, SQL Server and MySQL.

Oracle:

• Directory Usage Parameters (ldap.ora) list the host names and port number of the primary and alternate LDAP directory servers.
• Data Visualization Cloud Service (DVCS) is a new Oracle Cloud Service. It is a subset offering of the currently supported Business Intelligence Cloud Service (BICS).
• ORA-24247: network access denied by access control list (ACL).
• Latches are low level …

This Log Buffer Editions picks few blog posts from Oracle, SQL Server and MySQL.

Oracle:

• If you grant the DBA role to a user, Oracle also grants it the UNLIMITED TABLESPACE system privilege. If you then revoke the DBA role from this user, Oracle also revokes its UNLIMITED TABLESPACE system privilege.
• Lost SYSMAN password OEM CC 12gR5.
• How Terminal Emulation Assists Easy Data Management.
• Using EMCLI List Verb …

http://www.itnews.com/article/3004953/use-oracles-database-watch-out-for-this-dec-1-deadline.html

Companies that use a standard edition of Oracle’s database software should be aware that a rapidly approaching deadline could mean increased licensing costs.

Speaking from experience (at both MySQL AB and Open Query), typically, licensing/pricing changes such as these act as a motivator for migrations.

Migrations are a nuisance (doesn’t matter from/to what platform) and are best avoided as they’re intrinsically painful, costly and time-consuming. Smart companies know this.

When asked in generic terms, we generally recommend against migrations (even to MySQL/MariaDB) for the above-mentioned practical and business reasons. There are also technical reasons. I’ll list a …

This Log Buffer Edition covers some of the niftiest blog posts from Oracle, SQL Server and MySQL.

Oracle:

• OBIEE 11g and Essbase – Faking Federation Using the GoURL.
• You can use one of these to link an exception name with an Oracle error number. Once you have done this, you can use the exception name in the exception block which follows the declaration.
• This is a short post to help out any “googlers” looking for an answer to why their 12.1.0.5 EM Cloud …

This Log Buffer is dedicated to the top quality news from the arena of Oracle, SQL Server and MySQL.

Oracle:

• We had a question on AskTom the other day, asking us to explain what a “latch” was.
• Jonathan Lewis thinks column groups can be amazingly useful in helping the optimizer to generate good execution plans because of the way they supply better details about cardinality.
• Today it’s all about developing software that makes access to your product easier.
• …

This Log Buffer Edition covers the weekly blog posts of Oracle, SQL Server and MySQL.

Oracle:

• An Index or Disaster, You Choose (It’s The End Of The World As We Know It).
• SQL Monitoring in Oracle Database 12c.
• RMAN Full Backup vs. Level 0 Incremental.
• Auto optimizer stats after CTAS or direct loads in #Oracle 12c.
• How to move …