Can I apply a BP on top of a PSU? Or vice versa?

Can I apply a Bundle Patch on top of a Patch Set Update?  This question was in my inbox this morning raised by a customer via a colleague.Our feeling said: Yes, but you'll have to deinstall the PSU first before applying the BP. Having a feeling is one thing, knowing the truth is better. And as I have so much... [Read More]

Big Data SQL Quick Start. Partition Pruning – Part7.

partitioning is very common technique in data warehousing and all kind of databases. I assume that reader know what partitioning is and I will not explain theoretical part. If you want you could consider Oracle RDBMS example. But I directly start with the practical. Hive partitioning. Hive originaly was...... [Read More]

Information on a new feature in Berkeley DB 6.2 – BDB Server

Information on a new feature in Berkeley DB 6.2  (courtesy of Yong Li) BDB Server (aka. BDB as standalone server or thrift) Beyond being an industry-leading embedded key-value database, BDB Server turns BDB into a key-value database server which supports a client-server style of access. User applications...... [Read More]

Getting a C++11 compiler for Node 4, 5 and 6 on Oracle Linux 6

| May 1, 2016
A newer compiler is needed on Oracle Linux 6 when you want to use add-ons like node-oracledb with Node 4 or later. This is because add-ons for those versions need to be built with a C++11 compatibile compiler. The default compiler on OL 6 doesn't have this support. OL 7 does have such a compiler, so these... [Read More]

May 2016 – November 2016 => Events where you can find MySQL

As an update to the blog posted on Mar 15, 2016, please find below list of events where you can find either MySQL Community team or MySQL experts at.  Please find more details at each conference below.  New events are marked with NEW! Any update to already announced event is marked as UPDATE!: ... [Read More]

Big Data SQL Quick Start. Predicate Push Down – Part6.

Since 3.0 version Big Data SQL has awesome feature - Predicate Push Down (PPD). It works over ORC files, Parquet Files and few NoSQL Databases (like HBase). I plan to devote separate topic for NoSQL databases and Big Data SQL, today i'm going to explain ORC and Parquet file case. For both files there is using the same... [Read More]

Getting Your DBMS_OUTPUT Super Fast

SQL Developer has a DBMS Output panel you can open and add to your desktop. You then add a connection you want to poll, and then you enable polling. It’s about 4 clicks. If you want to increase the default buffer size from 20,000 characters, then that’s a few more clicks and keystrokes. A friend of the... [Read More]

Upgrade to Oracle Database 12c: We don’t insist :-)

It's so funny - for years I discuss with customers minimal downtime upgrade strategies back and forth, up and down. I saw DBAs really hunting to save a few seconds potential downtime - and I always take this serious as there is usually a real reason behind that. Just to learn a few days later by repeating experience... [Read More]

Customizing SQL Developer Toolbars

We already have some pretty Spartan toolbars. We aim for fewer buttons, not less. But maybe you want to go SUPER Spartan. Even fewer buttons! Yeah, you can do that. View > Show Toolbars > Customize Main Toolbar > Customize I’m going to take a few things off the main editor and data modeler toolbars. Click,... [Read More]

Incremental Statistics Collection in Oracle 12.1.0.2 – A True Story

Recently I came across a really interesting customer case in the UK dealing with Incremental Statistics Collection issues in regards to an upgrade to Oracle Database 12.1.0.2. This is the follow-up blog post to:  Incremental Statistics Collection in Oracle 12.1.0.2 - Upgrade Pitfalls (Apr 27....... [Read More]

Thank You for Attending the MySQL Innovation Day

The MySQL Innovation Day took place on Monday, April 25, at the Oracle Conference Center in Redwood Shores, California. Jam-packed with 9 sessions delivered by Oracle's MySQL team, the event offered great opportunity for the attendees to learn the latest products and features in MySQL 5.7, including replication,...... [Read More]

Incremental Statistics Collection in Oracle 12.1.0.2 – Upgrade Pitfalls

A while back I blogged already about Incremental Statistics collection in Oracle Database 12.1.0.2:  Incremental Statistics Collection Improved in Oracle Database 12c - Nov 13, 2014https://blogs.oracle.com/UPGRADE/entry/incremental_statistics_collection_improved_in. And you'll find more...... [Read More]

MOS Note 1454618.1: Quick Reference to Database PSUs, CPUs, BPs and Patchsets

Sometimes my mouse arm gets tired by clicking myself through MOS notes just to download a specific PSU or BP - and as I experiment a lot with PSUs and BPs right now I clicked a lot in the past days and nights.  Usually I'd start with either MOS Note:161818.1 - then click on the release link (e.g. 12.1.0.x)... [Read More]

Greatly Improved SQL Index Performance for Oracle Berkeley Database, Version 6.2

A new whitepaper has been published, "Greatly Improved SQL Index Performance for Oracle Berkeley Database, Version 6.2". Learn how to increase the performance of SQL Queries using BDB. Go to: http://www.oracle.com/technetwork/database/database-technologies/berkeleydb/learnmore/index.html   ... [Read More]

SQL Pattern Matching Deep Dive – Part 3, greedy vs. reluctant quantifiers

Picture courtesy of Pixabay Welcome to the third post in this deep-dive series on SQL pattern matching using the MATCH_RECOGNIZE feature that is part of Database 12c.  In the first part of this series we looked at a wide range of topics including ensuring query consistency, how to...... [Read More]

Common Distribution Methods in Parallel Execution

Parallel execution uses the producer/consumer model when executing a SQL statement. The execution plan is divided up into DFOs, each DFO is executed by a PX server set. Data is sent from one PX server set (producer) to another PX server set (consumer) using different types of distribution methods. In this post we... [Read More]

Oracle Database BP April16 applied successfully

Usually I don't post twice a day but as my post scriptum for the previous blog post got longer and longer I decided to write an entry about it - maybe simply because I feel soooo happy that my patch application succeeded flawless. For many of you the following steps may look very boring as you have done this many... [Read More]

Oracle April 2016 PSU and Proactive BPs are there

Hurray, it's Patching Day! Sounds a bit like D-Day But April 19, 2016 the most recent April PSUs (Patch Set Updates) and BPs (Bundle Patches) got released. Find all the necessary information with the below links:  Critical Patch Update - April 2016 Patch Availability Database The... [Read More]

Data Pump – Exclude Stats differently for TTS and FTEX

Nice little best practice for statistics and Data Pump when doing either Transportable Tablespaces or Full Transportable Export-Import (credits to Roy and Dean Gagne).. Transport Statistics via a Staging Table First of all we always recommend to exclude statistics when doing a Data Pump export as the import of...... [Read More]

RMAN Catalog Upgrade fails – ORA-02296 – error creating modify_ts_pdbinc_key_not_null

This issue got raised to my via a customer I know for quite a while - all credits go to Andy Kielhorn for digging down into that issue and solving it. , Failed RMAN Catalog Upgrade from 11.2.0.4 to 12.1.0.2 The RMAN catalog upgrade: SQL> @?/rdbms/admin/dbmsrmansys.sql $ rman CATALOG... [Read More]