| 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...
| user | May 23, 03:16 PM PDT | By Michael Schulman-Oracle
BDB User Authentication
(courtesy of Brayden Zhang)
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...
| 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...
| 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...
| 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 ...
| 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 22.214.171.124 to 126.96.36.199 on a large RAC...
| 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...
| 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...
| 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 | 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...
| 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...
| 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...
| 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...
| php | May 13, 03:36 AM PDT | By cj
Forget emoji, look at the Oracle New Gen Developers!
[ Read More ]
| 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...
| 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...
| 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...
| 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...
| home |