Expert Blogs - Toad World

Expert Blogs


Deepak Vohra
Follow /30 May 2017 at 8:41pm / MySQL

Logging & Monitoring API Calls from AWS Relational Database Service Using AWS CloudTrail

AWS CloudTrail is a managed service to log, monitor, and retain events related to API calls across an AWS account. The AWS calls could be made as a result of some AWS Management Console action or some action initiated by another managed service console...
76 0 /
Michael McLaughlin
Follow /30 May 2017 at 5:59pm / Oracle Blog

How to UPDATE Nested Object and Table Columns, Part 2

The first part of this series showed how you can leverage Oracle’s SQL syntax with UDT columns and collection columns. It would be nice if Oracle gave you some SQL to work with the elements of ADT collections, but they don’t. After all, that’s...
189 0 /
Follow /29 May 2017 at 5:46pm / Oracle Blog

SYSBACKUP and SYSDG permissions in Oracle 12c

Introduction In many companies there is a clear separation of duties for various Oracle Database related tasks such as administering ASM and backing up/restoring Oracle databases. In the past, DBAs used SYSDBA permission for administering ASM and RMAN...
161 0 /
Julie Hyman
Follow /26 May 2017 at 2:56pm / Toad Data Point Blog

Videos covering new functionality in Toad Data Point 4.2 have been posted

Hi everyone, Robert Pound has created and posted 4 new short videos that cover some NEW functionality in Toad Data Point 4.2 which I think can be really helpful! 1. Publishing queries with run-time parameters to Toad Intelligence Central: https...
72 0 /
Robert Catterall
Follow /25 May 2017 at 5:48am / IBM DB2 Blog

DB2 for z/OS and Data-as-a-Service and Database-as-a-Service

______-as-a-service is all the rage in IT these days, and understandably so -- the "service-ization" of information technology capabilities and interfaces will be transformational; indeed, transformations have already occurred or are underway...
92 0 /
Denny Cherry
Follow /24 May 2017 at 8:00pm / SQL Server Blog

Should I build a 1×6 VM or a 6×1 VM?

This sort of question comes up a lot.  And there’s a lot of it-depends built into the answer, so I’ll try and break this down a little bit for you.  Be warned, we’re going to be talking about NUMA and other hardware-y things here for...
274 0 /
Deiby Gomez
Follow /24 May 2017 at 3:18pm / Oracle Blog

How to run SQL Statements across Pluggable Databases with

Introduction: Beginning with Oracle Database, DBAs started to work with Pluggable Databases. There were some large migrations of several databases from 10g/11g to 12c where they were consolidated into a new Oracle Database Container using...
482 0 /
Deiby Gomez
Follow /24 May 2017 at 3:03pm / Oracle Blog

Oracle Database 12cR2 new feature: Lockdown Profiles

By Deiby Gómez Introduction: In the past, roles, system privileges, and table privileges were used to control the functionalities allowed to database users. However, roles and privileges don’t have enough granularity to effectively...
489 0 /
Deiby Gomez
Follow /24 May 2017 at 2:19pm / Oracle Blog

Oracle Database 12cR2 new feature: Proxy PDB

By Deiby Gómez Introduction: The need to communicate with external systems and exchange data made Oracle develop a way to connect to different Oracle databases to execute operations. Traditionally, whenever we wanted to bring data in from...
588 0 /
Deiby Gomez
Follow /24 May 2017 at 2:01pm / Oracle Blog

Oracle Database 12cR2 new feature: Application Root Replica

By Deiby Gómez Introduction: In my previous articles we have seen concepts like “ Application Containers ” and “ Proxy PDB ”, which are new in Oracle Database 12cR2. With Application Containers, you can install...
463 0 /
Deiby Gomez
Follow /24 May 2017 at 1:31pm / Oracle Blog

Oracle Database 12cR2 new feature: Container Maps

By Deiby Gómez Introduction: Oracle introduced a new cool concept called “Application Containers” in 12cR2 ( I have already written about this topic in the article “ Introduction to Application Containers in...
669 0 /
Porus Homi Havewala
Follow /24 May 2017 at 11:19am / Oracle Blog

New Blog "Clouds and Databases"

Dear Friends, I have started to write on a brand new blog "Clouds and Databases" that I created recently. On the new blog, I will be writing about different cloud technologies and databases. The blog address is http://cloudsanddatabases.blogspot...
128 0 /
Clarisa Maman Orfali
Follow /23 May 2017 at 11:33pm / Oracle Blog

Usando los esquema de colores del Tema Universal 42 en nuestros componentes personalizados

El Tema Universal utiliza un conjunto de colores (esquemas) entre los diferentes componentes. Estos colores se pueden agrupar en dos paletas: colores generales y colores con estado. Colores generales Los colores generales se utilizan para agregar...
163 0 /
Syed Jaffar Hussain
Follow /23 May 2017 at 10:23am / Oracle Blog

SQL Tuning Advisor against sql_id's in AWR

We were in a situation very recently to run SQL Tuning Advisor against a bunch of SQL statements that appeared in the AWR's ADDM recommendations report. The initial effort to launch SQL Tuning Advisor against the SQL_ID couldn't go through as...
164 0 /
Brendan Tierney
Follow /23 May 2017 at 8:47am / Oracle Blog

Slides from the Ireland OUG Meetup May 2017

Here are some of the slides from our meetup on 11th May 2017. Ireland OUG Meetup May 2017 from Brendan Tierney The remaining slides will be added when they are available.
156 0 /
Anju Garg
Follow /19 May 2017 at 3:56pm / Oracle Blog

Issues with Oracle Multi-tenant Application Containers

Introduction The Oracle Database 12 c Release 1 introduced the Oracle Multi-tenant architecture, which allowed consolidation of multiple pluggable databases (PDBs) together in a multi-tenant container database (CDB). Various PDBs store data in objects...
526 1 /
Dan Hotka
Follow /15 May 2017 at 3:34pm / Oracle Blog

Top 10 Recursive Views to Look at for Database Performance Troubleshooting

Hi, Recursive views present various data dictionary information in a readable form. In Oracle, real-time information can generally be monitored using the V$ dictionary views. Oracle tracks literally everything going on both within the database and...
382 1 /
Kevin Dalton

Benchmark Factory REST API (Part 2)

In the first part of this blog series on the new BMF REST API I covered the basics on how to create a new connection, a new job which uses that new connection, and how to execute that job. In this the second part I will cover more on how to modify existing...
52 0 /
Dan Hotka
Follow /15 May 2017 at 2:42pm / Oracle Blog

Managing Containers and Pluggable Databases

Hi, Oracle12 introduced a new database architecture for the Oracle database: multi-tenant or pluggable databases. The basic concept is a container database (CDB) that can contain one or more pluggable databases (PDBs). The main feature of this new...
374 0 /
Follow /12 May 2017 at 10:36pm / Toad Edge - Blog

Intellisense in worksheets | Toad Edge knows how to assist

When creating the video Using worksheets in Toad Edge , I touched briefly on the intellisene feature and how it gives you feedback when writing your queries. I wanted to double back on this topic to give a more detailed example of how this feature can...
123 1 /
Follow /11 May 2017 at 9:38pm / Toad Data Point Blog

CASE Statement - the IF statement answer in Toad Data Point! (Oracle/SQL Server)

Data analysts commonly use IF THEN ELSE statements when attempting to create a calculated field in a BI query and then filtering results on that calculated field. However, this can be difficult to do in the SQL editors, because neither Oracle nor SQL...
388 1 /
Julie Hyman
Follow /11 May 2017 at 9:31pm / Toad Edge - Blog

Currently using Toad for MySQL?

If you are currently using Toad for MySQL and are interested in Toad Edge, check out this matrix that compares features .
138 0 /
Julie Hyman
Follow /11 May 2017 at 8:25pm / Toad Edge - Blog

Be first to try our newest Toad!

Want to apply Toad's robust development features to your MySQL environments? Well now you can! We have just released a free preview version of our new Toad Edge (TM) product . Initially focused on the MySQL platform, Toad Edge is a next generation...
1149 0 /
Anju Garg
Follow /11 May 2017 at 6:52pm / Oracle Blog

Session Cursor Caching - Part Two

In first part of this article, we Learnt What is ‘Session Cursor Caching’? How to Enable Session Cursor Caching? Explored ‘Session Cursor Caching’ in detail by means of following practical scenarios: ...
976 1 /
Dan Hotka
Follow /8 May 2017 at 9:18pm / Oracle Blog

How Oracle B-tree Indexes Work

Hi, I have a lot of knowledge about how Oracle’s indexes work. I’ll start with how Oracle B-tree indexes work, as well as syntax and practical uses for each. Oracle B-Tree Index Structure The above illustration shows a single...
535 0 /