Login for Oracle employees only

Recent Posts

« previous | home | next »

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

Roller Planet | bundle | May 03, 04:11 AM PDT | By Mike Dietrich-Oracle

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...

Big Data SQL Quick Start. Partition Pruning - Part...

Roller Planet | bds_start | May 02, 04:44 PM PDT | By Alexey Filanovskiy-Oracle

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...

Information on a new feature in Berkeley DB 6.2 - ...

Roller Planet | berkeley | May 02, 08:34 AM PDT | By Michael Schulman-Oracle

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...

Getting a C++11 compiler for Node 4, 5 and 6 on Or...

Roller Planet | linux | May 01, 09:36 PM PDT | By cj

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...

May 2016 - November 2016 => Events where you can f...

Roller Planet | community | April 29, 09:27 AM PDT | By Lenka Kasparova-Oracle

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...

Big Data SQL Quick Start. Predicate Push Down - Pa...

Roller Planet | bds_start | April 29, 08:37 AM PDT | By Alexey Filanovskiy-Oracle

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...

Getting Your DBMS_OUTPUT Super Fast

Roller Planet | template | April 29, 05:27 AM PDT | By thatjeffsmith

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...

Upgrade to Oracle Database 12c: We don't insist :-...

Roller Planet | Oracle Database 12c | April 29, 01:24 AM PDT | By Mike Dietrich-Oracle

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...

Customizing SQL Developer Toolbars

Roller Planet | SQL Developer | April 28, 07:02 AM PDT | By thatjeffsmith

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...

Incremental Statistics Collection in Oracle 12.1.0...

Roller Planet | 12.1.0.2 | April 28, 04:09 AM PDT | By Mike Dietrich-Oracle

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...

Thank You for Attending the MySQL Innovation Day

Roller Planet | community | April 27, 10:23 AM PDT | By Wei-Chen Chiu-Oracle

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...

Incremental Statistics Collection in Oracle 12.1.0...

Roller Planet | 12.1.0.2 | April 27, 08:06 AM PDT | By Mike Dietrich-Oracle

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_statistic...

MOS Note 1454618.1: Quick Reference to Database PS...

Roller Planet | 12.1.0.2 | April 26, 05:00 AM PDT | By Mike Dietrich-Oracle

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...

Greatly Improved SQL Index Performance for Oracle ...

Roller Planet | berkeley | April 25, 08:15 AM PDT | By Michael Schulman-Oracle

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-tech...

SQL Pattern Matching Deep Dive - Part 3, greedy vs...

Roller Planet | matching | April 25, 07:43 AM PDT | By Klaker-Oracle

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...

« previous | home | next »