Expert Blogs

Blogs

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...
90 0 /
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...
163 0 /
Ondrej.Zizka
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...
43 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...
208 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...
52 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...
334 2 /
zaheer.appsdba
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...
159 0 /
zaheer.appsdba
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...
116 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...
126 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...
47 0 /
Ondrej.Zizka
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...
54 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...
171 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...
278 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...
325 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...
683 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...
1097 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...
133 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...
127 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...
356 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...
875 2 /
Deiby Gomez
Follow /25 Jul 2017 at 5:38pm / Oracle Blog

How to analyze Undo statistics to proactively avoid undo space issues

By Deiby Gómez Introduction In my previous articles I explained two very important concepts about Undo Data; one is how Oracle manages the retention time and the other is how Oracle reuses the undo extents . You can also check my presentation...
568 1 /
Ondrej.Zizka
Follow /25 Jul 2017 at 5:26pm / Toad for IBM DB2 Blog

Install Toad for DB2 version 6.3 using IBM Data Server Driver

In this blog post, I would like to show you how to install Toad for DB2 version 6.3 and IBM Data Server Driver. Using IBM Data Server Driver is a new option in Toad for DB2 version 6.3. Previously it was necessary to use IBM Data Server Client, but now...
112 0 /
Brendan Tierney
Follow /24 Jul 2017 at 4:19pm / Oracle Blog

Part 4b - (Article 22: Profiling) Why me? and how Oracle 12c saves the day

This is the fourth part of series of blog posts on ' How the EU GDPR will affect the use of Machine Learning ' In this blog post (Part4b) I will examine some of the more technical aspects and how the in-database machine learning functions saves...
163 1 /
Dan Hotka
Follow /21 Jul 2017 at 9:20pm / Oracle Blog

Oracle 12.2 New Features: Scheduler, Data Pump, and More

Hi, I’ve written a lot of articles on Oracle12 new features. This article will conclude the series with a list of miscellaneous new features for the various other tools like data pump, the scheduler, and SQL*Loader. Other Dan Hotka Oracle12...
485 1 /
Robert Catterall
Follow /21 Jul 2017 at 9:08pm / IBM DB2 Blog

Db2 12 for z/OS SQL Enhancements: Result Set Pagination

In this second of a series of entries on my favorite SQL-related enhancements provided via Db2 12 for z/OS (and "Db2," versus "DB2," is officially the new form of the product name), I will describe useful functionality pertaining to...
81 0 /