Expert Blogs - Toad World

Expert Blogs


Follow /28 Apr 2017 at 1:18am / Toad Data Point Blog


What is EDC or “Every Day Carry”? Wikipedia describes EDC as items that are carried on a consistent basis to assist in dealing with normal everyday needs of modern society, including possible emergency situations. Some of the most common...
18 0 /
Michael McLaughlin
Follow /27 Apr 2017 at 4:32pm / Oracle Blog

How to UPDATE Nested Object and Table Columns, Part 1

This two-part series covers how you update User-Defined Types (UDTs) and Attribute Data Types (ADTs). There are two varieties of UDTs. One is a column of a UDT object type and the other a UDT collection of a UDT object type. You update nested UDT columns...
99 0 /
Porus Homi Havewala
Follow /27 Apr 2017 at 4:09pm / Postgres - Blog

A first look at Amazon Aurora with PostgreSQL compatibility - Benefits and Drawbacks - Part III

by Porus Homi Havewala In the previous parts of this article series , we started to look at Amazon AWS and the Relational Database Service (Amazon RDS) that it offers to customers around the world. We learned that Amazon’s own Aurora database...
78 0 /
Brendan Tierney
Follow /27 Apr 2017 at 2:23pm / Oracle Blog

OUG Ireland Meetup 11th May

The next OUG Ireland Meetup is happening on 11th May , in the Bank of Ireland Grand Canal Dock. This is a free event and is open to every one. You don't have to be a member to attend. Following on from a very successful 2 day OUG Ireland Conference...
74 0 /
Denny Cherry
Follow /26 Apr 2017 at 5:00pm / SQL Server Blog

Partitioned Tables and ColumnStore

ColumnStore indexes are all the rage with data warehouses. They’re fast, they’re new(ish) and they solve all sorts of problems when dealing with massive amounts of data.  However they can cause some issues as well if you aren’t very...
72 0 /
Porus Homi Havewala
Follow /25 Apr 2017 at 12:08am / Oracle Blog

Consolidation Planning for the Cloud - Part IX

by Porus Homi Havewala We started to detail the concept and workings of Consolidation Planning for the Cloud, using Oracle Enterprise Manager Cloud Control 13c, in the previous parts of this article series. This is Part IX. To recap, in the previous...
332 0 /
Kevin Dalton

What's New in Benchmark Factory 7.6

We are pleased to announce the availability of Benchmark Factory 7.6! There are many enhancements/fixes in this release, but below are a few of which I want to point out. REST API With this release BMF now has a REST API which will allow users...
48 0 /
Follow /20 Apr 2017 at 5:46pm / Postgres - Blog

The pg_rewind Improvements in PostgreSQL 9.6

By Vibhor Kumar The pg_rewind tool was first introduced in PostgreSQL 9.5. This is best used in a situation when a standby becomes a master, then the old master can be reattached to the new master as a standby without restoring it from the new base...
40 0 /
Gokhan Atil
Follow /19 Apr 2017 at 10:49am / Oracle Blog

Using EMCLI for Mass Update a Property Value

Here’s a quick and simple script which can help you to update a target property value of all targets running on a specific host. The script will expect you to enter 3 parameters: host name, property name and property value. Then it will search for...
297 0 /
Brendan Tierney
Follow /18 Apr 2017 at 3:55pm / Oracle Blog

ODM Model View Details Views in Oracle 12.2

A new feature for Oracle Data Mining in Oracle 12.2 is the new Model Details views. In Oracle and up to Oracle 12.1 you needed to use a range of PL/SQL functions (in DBMS_DATA_MINING package) to inspect the details of a data mining/machine learning...
281 0 /
Syed Jaffar Hussain
Follow /15 Apr 2017 at 11:45am / Oracle Blog

How to stabilize, improve and tune Oracle EBS Payroll and Retropay process

Visited few customers off late to review the performance issues pertaining to their Oracle EBS Payroll and Retro-pay processes. Not sure if many are aware of the tools Oracle has to analyze and improve any Oracle EBS modules, including Payroll and Retro...
299 0 /
Deepak Vohra
Follow /13 Apr 2017 at 6:33pm / Oracle Blog

Indexing Oracle Database Table Data in Apache Solr 5.x on Oracle Linux 6.x

By Deepak Vohra Most applications store their related data in a relational database such as the Oracle Database, and indexing Oracle Database data from multiple database users or tables is a commonly used collaborative data preparation task. While...
478 0 /
Deiby Gomez
Follow /13 Apr 2017 at 4:26pm / Oracle Blog

Introduction to Oracle SQL Plan Directives in Oracle Database 12.2

By Deiby Gómez Introduction: An Execution Plan is composed by the steps that the optimizer does in order to process a SQL statement. Oracle Optimizer always tries to find out the best execution plan for a SQL statement, taking into consideration...
902 0 /
Anju Garg
Follow /12 Apr 2017 at 10:38pm / Oracle Blog

Session Cursor Caching - Part One

Introduction When a SQL statement is issued, the server process, after checking its syntax and semantics, searches the library cache for an existing cursor for the SQL statement. If a cursor does not already exist, a new cursor is created (hard parse...
1079 0 /
Dan Hotka
Follow /12 Apr 2017 at 9:34pm / Oracle Blog

A couple of good index questions from a novice

Hi, This blog comes from the e-mail bag. [:)] One of my followers asks two useful questions that a novice to relational databases or an end user/power user is likely to have. The questions relate to ‘how does it work’, a fun series on discovery...
424 0 /
Dan Hotka
Follow /12 Apr 2017 at 9:30pm / Oracle Blog

Oracle Compressed Tables

Hi, Did you know that Oracle supports compression in various forms in the database? You can compress an entire tablespace (all of its contents), a table, or part of a table (at the partition level). Using sub-partitioning, the sub-partitions can be...
380 0 /
Dan Hotka
Follow /12 Apr 2017 at 9:04pm / Oracle Blog

Cross Database Partitioning (Sharding)

By Dan Hotka Hi, Sharding is a method of having a widely distributed database across various hardware platforms utilizing a mix of database technologies. Sharding extends partitioning to various distributed databases that don’t even have...
451 0 /
Deiby Gomez
Follow /7 Apr 2017 at 4:00pm / Oracle Blog

Oracle Database 12c Deferred Global Index

By Deiby Gómez Introduction: Before Oracle, whenever a table partition was dropped all the global indexes that were created on that table became UNUSABLE unless we specified the clause UPDATE INDEXES in the ALTER TABLE (…...
900 0 /
Deiby Gomez
Follow /6 Apr 2017 at 10:58pm / Oracle Blog

Oracle Database Resource Manager for pluggable databases

By Deiby Gómez Introduction: Oracle Database Resource Manager enables you to limit database resources. Oracle has been enhanced in this regard in its new versions; for example, in, Database Resource Manager supports multi-tenant...
1015 0 /
Juan Carlos Olamendy
Follow /6 Apr 2017 at 9:03pm / MySQL

Speed up your queries using the covering index in MySQL

By Juan Carlos Olamendy Turruellas Introduction A covering index is a special case of an index in InnoDB where all required fields for a query are included in the index; in other words, the index itself contains the required data to execute the...
183 0 /
Bruce Momjian
Follow /5 Apr 2017 at 10:26pm / Postgres - Blog

Wait Event Reporting

By: Bruce Momjian Postgres often lacks the sophisticated reporting of more established enterprise relational database systems. Sometimes that is because Postgres doesn't require as much monitoring and tuning, but there are legitimate monitoring...
86 0 /
Clarisa Maman Orfali
Follow /4 Apr 2017 at 6:24pm / MySQL

Cómo crear una Instancia de la Base de Datos MySQL en Amazon RDS

En un artículo anterior hemos aprendido cómo crear una cuenta en Amazon Web Services (AWS), además de conocer lo que es Amazon RDS y finalmente aprendimos cómo configurar una Instancia de la base de datos Oracle en Amazon RDS...
51 0 /
Clarisa Maman Orfali
Follow /4 Apr 2017 at 5:32pm / MySQL

Qué es PhpMyAdmin y cómo podemos gestionar la Base de Datos MySQL con esta herramienta

En este artículo vamos a dar una vista general de esta aplicación llamada PhpMyAdmin la cual es una de las aplicaciones más populares para la gestión de bases de datos MySQL . A lo largo de mi carrera profesional he utilizado...
62 0 /
Follow /4 Apr 2017 at 3:43pm / Postgres - Blog

PostgreSQL in Database Race

By Syed Zaheer Introduction: Information technology is one of the key areas which keep changing drastically and we should be ready to accept these changes as per the moving trend. These changes will help enterprise organizations align with their...
108 0 /
Brendan Tierney
Follow /3 Apr 2017 at 7:22pm / Oracle Blog

Managing memory allocation for Oracle R Enterprise Embedded Execution

When working with Oracle R Enterprise and particularly when you are using the ORE functions that can spawn multiple R processes, on the DB Server, you need to be very aware of the amount of memory that will be consumed for each call of the ORE function...
380 0 /