Login for Oracle employees only

Recent Posts

« previous | home | next »

Global Temporary Tables and Upgrading to Oracle Da...

DBAPlanet | gtt | May 24, 06:23 AM PDT | By nbayliss-Oracle

Prior to Oracle Database 12c, global temporary tables (GTTs) shared statistics between sessions, so each GTT had one set of statistics visible to all sessions using it. Of course, gathering statistics on GTTs can be very useful because it will help the...

BDB User Authentication

DBAPlanet | user | May 23, 03:16 PM PDT | By Michael Schulman-Oracle

BDB User Authentication (courtesy of  Brayden Zhang) Introduction In Berkeley DB 6.2, user authentication extension is added into the SQL interface. The new user authentication layer is both secure and easy to use. In this article, we...

Charting Values over Time in a SQL Developer Repor...

DBAPlanet | chart | May 23, 08:34 AM PDT | By thatjeffsmith

Today’s post is courtesy of this question from a reader: Can the SQLDeveloper Report/Chart feature create a line chart where x contains date/time and y the values to be plotted? The answer is ‘Yes!’ I’m going to use HR.EMPLOYEES to...

Big Data SQL Quick Start. Data types - Part8.

DBAPlanet | bds_start | May 19, 01:10 PM PDT | By Alexey Filanovskiy-Oracle

Today I'm going to share one of the easiest way to improve overall Big Data SQL performance. Big Data SQL is the complex system, which contains two main pieces - Database and Hadoop. Each system has own datatypes - Oracle RDBMS and Java. Every time when you...

Messed-Up App of the Day: Tables of Numbers

DBAPlanet | ink | May 19, 12:51 PM PDT | By Cary Millsap

Quick, which database is the biggest space consumer on this system?Database Total Size Total Storage-------------------- --------------- ---------------SAD99PS 635.53 GB 1.24 TBANGLL 9.15 TB ...

MOS Note:136697.1 - New HCHECK.SQL for Oracle Data...

DBAPlanet | Best Practice | May 18, 08:00 PM PDT | By Mike Dietrich-Oracle

A while back we added this slide to our big slide deck: The story behind this slide A large and important customer in the US tested a patch set upgrade - but when they approached the production upgrade from 11.2.0.2 to 11.2.0.3 on a large RAC...

Node-oracledb 1.9.1 with Promises and Node 6 Suppo...

DBAPlanet | node | May 18, 03:14 AM PDT | By cj

Top features: Promise support. Node 6 support. The new node-oracledb 1.9.1 release adds Promise support, it now supports the new Node 6 (as well as previous releases), and it has some welcome stability fixes. Other nice goodies are mentioned below. Thanks...

Single PX Server Execution

DBAPlanet | parallel_processing | May 17, 03:13 PM PDT | By Yasin.Baskan-Oracle

I recently helped a customer tune a few queries in their Oracle Database In Memory POC. I want to talk about a simplified version of one of their queries as it is a nice tuning example and also a good opportunity to talk about a new parallel execution feature...

Recap - OTN Tour EMEA - Baku, Azerbaijan - 2016

DBAPlanet | 2016 | May 16, 08:00 PM PDT | By Mike Dietrich-Oracle

Working on a Saturday is not common for me but happens from time to time mostly when I travel abroad or when a customer has a critical upgrade or migration on a weekend. Having 120 skilled and enthusiastic people in a conference day on a Saturday is VERY...

Slices in BDB

DBAPlanet | slices | May 16, 10:30 AM PDT | By Michael Schulman-Oracle

Slices in Berkeley DB (courtesy of Charles Koester)  With the new Berkeley DB 6.2 release, there are a number of new features.  One of the more exciting ones is the use of Slices. It is possible to improve the multiprocessor scaling of your DB...

Fail Fast

DBAPlanet | lean startup | May 13, 03:22 PM PDT | By Cary Millsap

Among movements like Agile, Lean Startup, and Design Thinking these days, you hear the term fail fast. The principle of failing fast is vital to efficiency, but I’ve seen project managers and business partners be offended or even agitated by the term fail...

Multiple Ways to Edit in SQLcl

DBAPlanet | sqlcl | May 13, 05:46 AM PDT | By thatjeffsmith

If you know how to edit your code in SQL*Plus, you already know how to do it in SQLcl. But I get asked this a lot, do you support EDIT? Do you support CHANGE? And what does SQLcl offer over those? So let’s tackle the old and then the...

New pattern matching tutorial on LiveSQL

DBAPlanet | matching | May 13, 05:08 AM PDT | By Klaker-Oracle

If you always wanted to try our new SQL pattern matching feature, MATCH_RECOGNIZE, but never had access to a Database 12c instance then you really need to checkout the our great new LiveSQL playground environment. LiveSQL is a great place to learn about all...

Emoji? Look at the Oracle New Gen Developers

DBAPlanet | php | May 13, 03:36 AM PDT | By cj

Forget emoji, look at the Oracle New Gen Developers! [ Read More ]

Recap - OTN Tour EMEA - Milano, Italy - 2016

DBAPlanet | 2016 | May 13, 02:45 AM PDT | By Mike Dietrich-Oracle

Thanks for this excellent day yesterday in Milano for the OTN EMEA Tour 2016. What a great audience, excellent speakers covering a broad spectrum - and also a perfect organization. In case you need the slides please find them here (or many more including the...

SQL Developer Data Modeler: Adding Journaling Tabl...

DBAPlanet | journal table | May 11, 06:30 AM PDT | By thatjeffsmith

You may want to audit or ‘journal’ changes to your data. As you update a record, add a record, or delete a record – log that change in a different table. When doing your designs in the Data Modeler, you can ask at the time of DDL generation...

MyNA (MySQL Nippon Association) Meeting Tokyo, Jap...

DBAPlanet | community | May 11, 04:36 AM PDT | By Lenka Kasparova-Oracle

We are happy to announce that there will be another MySQL user group meeting organized by MyNA (mySQL Nippon Association) in May 2016. Please find more details below: Date: May 30, 2016 Time: 19:30-21:30 JST Place: Oracle Aoyama Center...

OTN Tour EMEA 2016 - Milan and Baku

DBAPlanet | milan | May 11, 01:31 AM PDT | By Mike Dietrich-Oracle

Time to travel a bit. OTN Tour EMEA 2016 has started yesterday in Düsseldorf, and tomorrow, May 12, Milan will be on the route. . Then on to Baku, Azerbaijan for the event on Saturday, May 14. First time for me. And I'm so looking forward to...

« previous | home | next »