Oracle Certification is “Well Worth The Effort” According to Don Coppock

In this week's customer success story highlight, we hear from Don Coppock who wears many hats in his current position after 35 years in the IT industry. Don's current responsibilities include Oracle Forms & Reports developer, Web Developer using Adobe ColdFusion and Oracle databases, SharePoint Administrator for a SharePoint 2007 installation, Backup Oracle DBA, and Backup ColdFusion Administrator. But this is not where he started. He made some smart moves along the way to keep (more...)

Collation and Case-Insensitive Database in Oracle 12.2

A little while ago Jeff Smith asked me if I had done anything with the collation functionality in Oracle Database 12c Release 2 (12.2). At the time my response was I was letting it stew a little before I released anything about it.

For some functionality the manuals contain a lot of information, but it’s not always obvious how much you will really care about. The collation functionality is exactly like that. You can get (more...)

How to create dashboard for Hadoop Hive Database

HiveServer2 is a service that enables clients to execute queries against Hive. It supports multi-client concurrency and authentication.

Are you using Hadoop Hive for your data marts or data-warehouse? If so, build your Free Hadoop Hive web dashboard software.

A Hadoop Hive dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Hiveserver2 SQL reporting reporting, it's a live view (more...)

Better track the Usage of Database Options and Management Packs, or it will cost you

So here it is:
Oracle announces a license audit, some urgency kicks in and this familiar but also really serious question comes up from management: “Are we using any unlicensed database features“. The seriousness is quite understandable, because if so, the company can look forward to some negotiations with Oracle over license fees, possibly resulting in considerable and unforeseen extra costs.

Tracking… why:
To be able to provide a swift and correct answer (more...)

Moving your Oracle Data to the Cloud with Minimal Downtime


Moving from an on-premise Oracle database to the Cloud can mean a whole host of different challenges, and these are different for every business. One of the things we’ve tackled for larger companies is the problem of migrating a lot of data, with not much time to play with. Big businesses come with big sets of data, and often don’t have time to spare for a lengthy window of downtime. Systems down means money spent, (more...)

How to make dashboard for Mimer database

Mimer is a SQL based relational database management system (RDBMS.It provides small footprint, scalable and robust relational database solutions.

Are you using Mimer for your data marts or data-warehouse? If so, build your Free Mimer business intelligence dashboard software.

 A Mimer dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Mimer SQL reporting reporting, it's a live view (more...)

How to create dashboard with Netezza database

IBM Netezza is the part of IBM PureSystems – expert integrated systems with built in expertise, integration by design and a simplified user experience.

Are you using Netezza for your data marts or data-warehouse? If so, build your Free Netezza data dashboard software.

 Netezza dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Netezza SQL reporting reporting, it's a (more...)

Oracle Enterprise Linux – Pre-Built for Enterprise

We've shared the AMI we use for running Oracle Enterprise Products like e-Business Suite. You'll find it on the AWS Marketplace pre-loaded with all the pre-requisites you need for your Oracle implementation on AWS.

Link to the Marketplace...


How to make dashboard for Informix database

Informix is a secure database, optimized for or OLTP, IoT and is forging new frontiers with its unique ability to seamlessly integrate SQL, NoSQL/JSON, time series and spatial data. Reliability, flexibility, ease of use, and low total cost of ownership makes Informix the best in class enterprise database available in the market.

Instant Visibility. A Informix dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview (more...)

Tips for Upgrading a Database

In February ’17 I participated in Mike Dietrich’s upgrade workshop and it was great! I don’t want to repeat stuff that he said there, you can read everything on his blog. This workshop made me think about upgrades I did in the past (and I did quite a few) and important things to think about before … Continue reading Tips for Upgrading a Database

How to make dashboard using Pointbase database

Instant Visibility. A Pointbase dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Pointbase SQL reporting reporting, it's a live view of exactly how your marketing campaign is performing.

  • Better Decision Making
  • Gain Competitive Advantage
  • Enhance Collaboration
  • Spotting potential problems
  • Merge with data from Excel Dashboards
  • Live SQL against database
  • No need for Data-warehouse or ETL
  • Leverage the speed and (more...)

How to connect and make dashboard using SQLite database

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite's code is free as it is in the public domain so it can be used for any purpose, commercial or private. SQLite is the most widely deployed database in the world various applications, including several high-profile projects.

 SQLite dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where (more...)

Optimizer Bugs and Issues

I wrote before about optimizer changes after upgrades, so this is a quick post about some more information related to this topic. As I wrote in the post I mentioned above, most of the issues we run into after upgrading are performance related. I guess this is the case because it’s one of the most … Continue reading Optimizer Bugs and Issues

Metadata Modeling in the Database with Analytic Views

Metadata Modeling in the Database with Analytic Views

12.2, the latest Oracle database release provides a whole set of new features enhancing various aspects of the product including JSON support, Auto-List Partitioning and APEX news among others. One of the biggest news in the Data Warehousing / Analytics area was the introduction of the Analytic Views, that as per Oracle's definition are

Metadata objects that enable the user to quickly and easily create complex hierarchical and dimensional queries on data (more...)

Can I Use Oracle GoldenGate with EBS on Oracle Cloud?

This frequently asked question comes in several variants, including:

  • Can I use Oracle GoldenGate with EBS on-premises to set up an operational reporting environment in Oracle Cloud?
  • Can I use Oracle GoldenGate Cloud Service with EBS?
  • Can I use Oracle GoldenGate to replicate my EBS database to Oracle Cloud?
  • Can I use Oracle GoldenGate to perform a live migration of my EBS database from on-premises to Oracle Cloud?

We will answer each question in turn. (more...)

The latest in Oracle Partitioning – Part 2: Multi Column List Partitioning

This is the second blog about new partitioning functionality in Oracle Database 12c Release 2, available on-premise for Linux x86-64, Solaris Sparc64, and Solaris x86-64 and for everybody else in the Oracle Cloud . This one will talk about multi column list partitioning, a new partitioning methodology in... [Read More]

Business rules, common sense and query performance

Very often, significant performance benefits can be obtained by using some very basic knowledge of the application, its data and business rules. Sometimes even less than that: even if you are not familiar with the application logic at all, you can still use common sense to make some reasonable guesses that would get you a long way in improving query’s performance. Here is an example (based on an actual query that I had to tune (more...)

Non-CDB still exists in Oracle Database 12.2.

I received a question from 3 different colleagues in the past week: "Does Oracle Database 12.2 still allow us to create non-CDB databases?" And as I get this question at every customer-facing workshop these days as well before being able to talk about Single/Multitenant - I think it is important to... [Read More]

Change UUIDs in VirtualBox

If you are anything like me you will have multiple virtualboxes running on your system. Sometimes you might want to run a copy of a virtualbox for different purposes. Like running an Oracle 11 Devdays instance as test environment but also running the same vbox for customer testing. If you copy the vbox and try to run it in the manager you’ll be presented with an error that a harddisk with the same UUID already (more...)

Python cx_Oracle 5.3 for Oracle Database Released

| Mar 9, 2017
Today we are pleased to announce the release of cx_Oracle 5.3, the extremely popular Python interface for Oracle Database. Binary and source bundles can be installed from PyPi, as normal. cx_Oracle 5.3 works with Python version 2.7, and with versions 3.4 and higher. You can use cx_Oracle with Oracle 11.2, 12.1 and... [Read More]