Expert Blogs


Brendan Tierney
Follow /21 Aug 2017 at 3:06pm / Oracle Blog

Scheduling ODMr Workflows in SQL Developer 4.2+

A new feature for Oracle Data Mining (ODM) (part of SQL Developer 4.2) is the ability to schedule an ODM workflow to run a defined time or frequency. This blog post will bring you through the steps need to schedule an ODM workflow using this new feature...
16 0 /
Follow /18 Aug 2017 at 10:43am / Oracle Blog

Configure Data Redaction on Oracle

In previous article we provide the brief introduction about Data Redaction on Oracle . Now in this post, we are going to configure different type of Data Redaction in Oracle 12c. Full Data Redaction Partial Data Redaction Random Data Redaction...
105 2 /
Robert Catterall
Follow /18 Aug 2017 at 5:22am / IBM DB2 Blog

Db2 12 for z/OS SQL Enhancements: a Better MERGE

Greetings, and welcome to the third in a series of entries covering my favorite Db2 12 for z/OS SQL enhancements. The first two posts in the series described piece-wise DELETE and result set pagination . This entry focuses on the new and very much improved...
28 0 /
Follow /17 Aug 2017 at 1:31pm / Oracle Blog

Oracle Data Redaction

Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by applications. You can redact column data by using one of the following methods: Full redaction. You redact all of the contents of the column data...
115 0 /
Deepak Vohra
Follow /16 Aug 2017 at 7:25pm / Toad Data Point Blog

Using Toad Data Point with Oracle Database on AWS RDS

Introduction Toad Data Point is a relational data source access, query, and analytics tool that may be used to create a table, add table data, query a table, and prepare reports; all from a graphical user interface (GUI). Toad Data Point supports...
25 0 /
Clarisa Maman Orfali
Follow /15 Aug 2017 at 3:34pm / Oracle Blog

Do you want to be a Database Administrator? Four DBA experts tell us their story

What does it really mean to be a database administrator? In an increasingly technologically globalized world, this specialty has taken on a very important role. When I started working in Oracle technologies, my first exposure to them was with database...
199 2 /
Clarisa Maman Orfali
Follow /14 Aug 2017 at 9:58pm / Oracle Blog

¿Quieres ser un Administrador de Bases de Datos? Cuatro Expertos DBA nos cuentan su historia

¿Sabemos lo que realmente significa ser un Administrador de Bases de Datos? En un mundo globalizado cada vez más tecnológico, esta especialidad ha cobrado un rol muy importante. Recuerdo que cuando me inicie en las tecnologías...
242 0 /
Follow /11 Aug 2017 at 6:14pm / IBM DB2 Blog

How to install IBM Db2 Developer Edition on Centos 7 using Docker

In this post, I would like to show you how to install IBM Db2 Developer Community edition. IBM Db2 Developer Community Edition is a full-featured free version for non-production environments. Primarily it is dedicated to developers and has some limitations...
210 0 /
Julie Hyman
Follow /10 Aug 2017 at 8:26pm / Toad Edge - Blog

Need the Right Toolset for Your MySQL Database? There’s a Toad for That.

“We’re transitioning to an open source database platform, and we’d really like to be able to develop and run our databases using our Toad software.” Toad Edge Lets You Get the Full Value from MySQL The quote above...
405 1 /
Juan Carlos Olamendy
Follow /9 Aug 2017 at 6:55pm / MySQL

Logging and analyzing slow queries in MySQL

By: Juan Carlos Olamendy Turruellas Introduction Slow queries can negatively impact database performance. If you don't analyze, optimize, and tune the slow queries as early as possible, the overall performance of your system will eventually...
67 0 /
Dan Hotka
Follow /8 Aug 2017 at 6:07pm / Oracle Blog

Oracle Coding Best Practices - Part 2

Hi, This month I'll focus on a couple of PL/SQL performance tips that will include how to utilize collections to radically increase row processing and a simple but useful coding tip on the benefits and pitfalls of some easy PL/SQL cursor coding...
393 2 /
Follow /8 Aug 2017 at 1:18pm / Oracle Blog

using LVM for adding two LUNS/Disks as one mount point

There may be situation where required capacity cannot be allocated from single volume group from storage, in such situation storage teams will provide multiple luns with different capacities. In this post we will see how we can create single mountpoint...
179 0 /
Follow /8 Aug 2017 at 9:48am / Oracle Blog

Deinstall Oracle grid Infrastructure 12.2 – Failed Installation

Oracle grid infrastructure 12.2 installation and deinstallation process is similar to prior releases. Its very common that the installation of software may fail due to many reasons. It could be a hardware failure, human error or software bug. In such...
136 0 /
Brendan Tierney
Follow /7 Aug 2017 at 4:46pm / Oracle Blog

Auto enabling APPROX_* function in the Oracle Database

With the releases of 12.1 and 12.2 of Oracle Database we have seen some new functions that perform approximate calculations. These include: APPROX_COUNT_DISTINCT APPROX_COUNT_DISTINCT_DETAIL APPROX_COUNT_DISTINCT_AGG APPROX_MEDIAN APPROX_PERCENTILE APPROX_PERCENTILE_DETAIL...
136 0 /
Deepak Vohra
Follow /4 Aug 2017 at 9:35pm / Toad Data Point Blog

Using Toad Data Point with RDBMS Data Sources

Toad Data Point is a data preparation, analysis, and reporting tool with data access to several of the commonly used data sources. RDBMS databases is just one of the categories of data sources that may be accessed from Toad Data Point, the others being...
57 0 /
Follow /4 Aug 2017 at 12:40pm / Toad for IBM DB2 Blog

How to create an SSL connection to the Db2 Warehouse on Cloud (former dashDB) using Toad for DB2 v 6.3 and Data Server Driver.

In this post, I will show you how to configure an SSL connection to the IBM Db2 Warehouse on Cloud. The SSL connection is not always necessary as the majority of communication between databases and applications is done in restricted networks, but if there...
61 0 /
Porus Homi Havewala
Follow /2 Aug 2017 at 5:43pm / Postgres - Blog

A first look at Amazon Aurora with PostgreSQL compatibility – Benefits and Drawbacks – Part VII

In the previous parts of this article series, we started to look at Amazon AWS and its Relational Database Service (Amazon RDS); in particular, Amazon’s own Aurora database with PostgreSQL compatibility. We examined in detail the benchmark results...
190 0 /
Porus Homi Havewala
Follow /2 Aug 2017 at 5:36pm / Oracle Blog

Oracle Hybrid Database Cloud using Enterprise Manager – Part III

In this article series, we are looking at the steps for setting up the Oracle Hybrid Cloud via the latest version – Enterprise Manager Cloud Control 13c. The aim is to install a hybrid cloud agent via the hybrid gateway. A hybrid cloud, of course...
298 0 /
Porus Homi Havewala
Follow /2 Aug 2017 at 4:09pm / Oracle Blog

Database as a Service using Enterprise Manager – Part III

In our article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database as a Service (DBaaS) Cloud – including the setup of such a cloud. In the previous parts , we started the setup of the...
345 0 /
Deepak Vohra
Follow /1 Aug 2017 at 8:35pm / Toad for Oracle Blog

Using Oracle CDB and PDBs on Docker Engine with Toad for Oracle

Introduction Oracle Container Database (CDB) and Pluggable Databases (PDBs) provide modularization to Oracle Database 12c, as discussed in the article Modularization by using Oracle Database Containers and PDBs on Docker Engine . Docker Engine provides...
753 0 /
Anju Garg
Follow /1 Aug 2017 at 5:55pm / Oracle Blog

Oracle Multi-tenant Application Containers - Part III - Sharing of Data in Application Common Objects

Overview In my last article, Oracle Multi-tenant Application Containers Part-II , we learnt how to create an application container comprising application root, application seed PDB, and application PDBs. We installed a simple application having a common...
1187 0 /
Brendan Tierney
Follow /31 Jul 2017 at 4:03pm / Oracle Blog

Part 5 - The right to be forgotten (EU GDPR)s

This is the fifth part of series of blog posts on ' How the EU GDPR will affect the use of Machine Learning ' Article 17 is titled Right of Erasure (right to be forgotten) allows a person to obtain their data and for the data controller to ensure...
141 0 /
Gokhan Atil
Follow /31 Jul 2017 at 1:45pm / Oracle Blog

Oracle BDCSCE Upgraded: Zeppelin 0.7 and Spark 2.1

Last week, Oracle Big Data Cloud Service – Compute Edition was upgraded from 17.2.5 to 17.3.1-20. I do not know if the new version is still in testing phase and available to only trial users, but sooner or later the new version will be available...
132 0 /
Mathew Phan
Follow /26 Jul 2017 at 10:55pm / Toad for Oracle Blog

Quick and Easy SQL Optimization with Toad for Oracle

SQL Optimization is intimidating for a lot of people. Even when you have great tools like Quest SQL Optimizer, people can be reluctant to hop into a different UI with so many powerful options. Thankfully, the Auto-Optimizer feature in Toad for Oracle...
380 2 /
Deiby Gomez
Follow /25 Jul 2017 at 7:08pm / Oracle Blog

Oracle Database 12.2 - How to track index usage

By Deiby Gómez Introduction Several articles have been written about how to track the usage of indexes and there are several scripts to determine which indexes are being used after monitoring for a while. In previous versions to 12cR2 of...
920 2 /