Oracle Daily Tidbits – April 2016

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in April 2016. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… TidBit #oratidbit ORACLE_OCM is a […]

Modern CX 2016

We are back in Las Vegas again for Oracle Modern Customer Experience Conference!  Instead of talking to customers and partners, we had the honor of chatting with UNLV Lee graduate students (@lbsunlv) and getting their feedback on how we envision the future of work, customers experience, marketing and data security.

We started off with Noel showing the portable Smart Office demo, including the Smart Badge, that we debuted at OpenWorld in October, (more...)

Why I am a Dostoevskyan Humanist

An explanation in 5 parts, by reference to the works of those who were not.*

'Lo! I show you the Last Man.

"What is love? What is creation? What is longing? What is a star?" -- so asks the Last Man, and blinks.

The earth has become small, and on it hops the Last Man, who makes everything small. His species is ineradicable as the flea; the Last Man lives longest.

"We have (more...)

RMAN no files found to be unknown to the database error

Here’s a weird error message for my collection…

I’ve been working with a customer to setup a RMAN backup on his standby database (backup is going to SBT). After a while, we decided that we couldn’t avoid using the RMAN catalog so we created one.
Now, when using the catalog, we can backup the database from either the primary or standby instances and that will register to a shared catalog so we could restore from (more...)

When SQLT is not enough

A SQLT report has all kinds of pertinent information including—to name just a few—optimizer settings, indexes, statistics, plan history, and view definitions. However, sometimes a SQLT report is not enough to solve a SQL performance problem.(read more)

Best #DataVault Event Ever!

Do your self, your DW architecture, and your brain a favor and take time to attend the 3rd Annual World Wide Data Vault Consortium

The APEX CONNECT and the APEX dashboard competition 2016

Before I tell you about the APEX dashboard competition winner I want to share my impressions from the APEX CONNECT 2016 in Berlin with you.

We had 3 days fully packed with APEX, SQL, PL/SQL, SQL Developer and different JavaScript technology topics.

In every way Niels de Brujin, Carsten Czarski, Christian Schwitalla and the whole DOAG team created an amazing event and has raised the quality compared to the last year.

We had more attendances, (more...)

(via https://www.youtube.com/watch?v=gPoiv0sZ4s4)



(via https://www.youtube.com/watch?v=gPoiv0sZ4s4)

Materialized View Fast Refresh und Data Clustering

Zur Abwechslung kann ich hier mal wieder eine selbst erlebte Geschichte erzählen: am letzten Wochenende habe ich ältere historischen Daten aus den Aggregationstabellen eines Data Warehouses (11.2) entfernt, was den Neuaufbau diverser Materialized Views erforderlich machte. Diese Materialized Views sind auf verschiedenen Ebenen der Zeitachse definiert: für Wochen, Monate und Jahre, wobei die beiden ersten Gruppen range partitioniert sind, während für die Jahres-Ebene keine Partitionierung eingerichtet wurde: vermutlich, weil in der Regel nur wenige (more...)

Speakers: Put your Twitter Handle on the Windows taskbar!

If you speak often at conferences, sharing your screen to demo things, this could be helpful:

Twitter Handle on the Windows taskbar

Throughout your presentation, the audience will be able to see your Twitter Handle, reminding them to include it with tweets about the event. I used to include it in the slides, but this is better, because it works also with live demonstrations where no slides are being showed. Which is incidentally my favorite way to do presentations:-)

Now how (more...)

Oracle Data Visualisation : Setting up a Connection to your DB

Using Oracle Data Visualisation is just the same or very similar as to using the Cloud version of the tool.

In this blog post I will walk you through the steps you need to perform the first time you use the Oracle Data Visualization client tool and to quickly create some visualizations.

Step 1 - Create a Connection to your Oracle DB and Schema

After opening Oracle Data Visualisation client tool client on the Data (more...)

Oracle Data Visualization Desktop – now available

After a bit of a long wait Oracle have finally release Oracle Data Visualization for the desktop. The desktop version of this tool is only available for Windows desktops at the moment. I'm sure Oracle will be bringing out versions of other OS soon (I hope).

To get you hands on the Oracle Data Visualization to to the following OTN webpage (click on this image)

NewImage

After downloading has finished, you can run the installer.

When (more...)

How is data modeled in NoSQL?

The important thing to understand is the data does not change just because it is managed differently. If the data does not change, then the entities and the relationships contained in the data cannot change either. The entities and the relationships between them have not changed since the dawn of time. They were the same in the days of network database management systems which came before relational database management systems, they stayed the same when (more...)

Why should Oracle Database professionals care about NoSQL and where to start?

Oracle Corporation openly admits that NoSQL database management systems have the performance advantage over relational database management systems “when data access is ‘simple’ in nature and application demands exceed the volume or latency capability of traditional data management solutions.” Database professionals should therefore look seriously at NoSQL technology.(read more)

Enterprise Manager Friday Tip- Management Packs and Annotations

Licensing can be a confusing topic for many, but additional stress can be felt for those that use tools that cover multiple products and features that can span more than one management pack.

lucy

I’ve demonstrated how you can see what management packs are used and how to control this via EM13c, (also available in EM12c) but that can take you away from the task at hand.  That’s where turning (more...)

Accessing the R datasets in ORE and SQL

When you install R you also get a set of pre-compiled datasets. These are great for trying out many of the features that are available with R and all the new packages that are being produced on an almost daily basis.

The exact list of data sets available will depend on the version of R that you are using.

To get the list of available data sets in R you can run the following.


> (more...)

Friday Philosophy – Visiting the Changi Murals by Sue’s Uncle Stan

No tech or management this week – this Friday Philosophy is about something in my home life.

First Mural,. Image from www.rafchangi.com

First Mural,. Image from http://www.rafchangi.com

This week we are in Singapore, our first ever visit. The main reason that we have come here is to look at some pictures painted by Sue’s Uncle Stan. They are also called the Changi Murals. Stanley Warren painted these murals when he was gravely ill in Changi during World War (more...)

Goodbye & Thanks to MN; Hello TFG

Uncategorized
| Apr 29, 2016
 
Time flies when you’re having fun, it feels like I only recently started working at MN, but truth be told, it is already 9 years ago. I started as a Junior Oracle Developer at MN after my bachelor degree and in these 9 years I became an all-round Fusion Middleware developer and solution architect within this company.

A great company, lovely colleagues and always a technical challenge ahead. I could certainly enjoy another (more...)

Server Problem : A Resolution?

AWSIt’s been a pretty annoying couple of days on the website server front.

The server locking up intermittently is one thing, and for all I know, maybe my fault? The incompetence of the hosting company is quite something else.

Just so you are aware why I was doing my nut yesterday, the hosting company had disabled my ability to force a power cycle of my dedicated server while they did a hardware test. They forgot to (more...)

VirtualBox 5.0.20

It’s been 10-ish days since VirtualBox 5.0.18 was released and the world is screaming out, “Where is 5.0.20 already? We want to update all out Guest Additions!” Well, it’s here… 🙂

The downloads and changelog are in the usual places.

Happy upgrading!

Cheers

Tim…


VirtualBox 5.0.20 was first posted on April 29, 2016 at 2:32 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for (more...)