Expert Blogs - Toad World

Expert Blogs

Blogs

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...
34 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...
54 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.
52 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...
122 0 /
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...
267 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...
27 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...
188 0 /
Robert.Pound
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...
67 1 /
gregory.x.martin
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...
227 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 .
62 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...
353 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: ...
733 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...
341 0 /
Dan Hotka
Follow /8 May 2017 at 8:49pm / Oracle Blog

Solving Problem Partitioning SQL Using PL/SQL

Hi, This article is more of the rest of the story from March’s Lucky Breaks. ( Click here to see the first blog). I want to share my successes in using PL/SQL to solve a rather common performance issue associated with accessing data across partitioned...
471 1 /
Porus Homi Havewala
Follow /8 May 2017 at 7:53pm / Postgres - Blog

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

by Porus Homi Havewala In the previous parts of this article series, we had a first look at Amazon AWS and the Relational Database Service (Amazon RDS) that it offers to customers around the world. Besides multiple third-party databases in RDS ...
317 0 /
Porus Homi Havewala
Follow /8 May 2017 at 6:31pm / Oracle Blog

Consolidation Planning for the Cloud - Part X

by Porus Homi Havewala We detailed 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 X, the final part in the series. ...
400 0 /
John Weathington

Continuous Integration Starting at Zero

Getting Off to a Good Start When it comes to data, Continuous Integration is one of those things that looks good on paper but is very difficult to implement. As a result, most data professionals conveniently ignore this rule when it comes to Agile...
71 0 /
Dan Hotka
Follow /5 May 2017 at 9:55pm / Oracle Blog

Too Many Indexes Causes Long Running Batch Cycles

Hi, This article is more of the rest of the story from March’s Lucky Breaks. ( Click here to see this blog). I want to share a real consulting gig where I used index monitoring with great success. Index Monitoring Index monitoring was introduced...
454 0 /
Mohamed.Houri
Follow /5 May 2017 at 6:38pm / Oracle Blog

Why my execution plan has not been shared - Part IV

As mentioned in the previous three articles of the series there are sixty-four reasons for which the Oracle Optimizer might decide to hard parse a new execution plan instead of sharing the existing one. Out of these sixty-four reasons, we have already...
492 0 /
Julie Hyman
Follow /4 May 2017 at 9:28pm / Toad Data Point Blog

Toad Data Point v4.2 is now available!

Today we are releasing Toad Data Point 4.2 and Toad Intelligence Central 3.3 . I am really excited about these releases because they bring some great new features to our products that were originally requested by Toad Data Point users who were coming...
267 0 /
Nate.Gaffaney
Follow /3 May 2017 at 2:53pm / Oracle Blog

Registration is open for ODTUG Kscope17, June 25-29 in San Antonio, Texas

Join Quest at Kscope17 , June 25-29 in San Antonio, Texas. ODTUG Kscope17 is home to the world’s leading experts on Oracle technology. Our booth will be set up in the exhibit hall, so stop by and see us! Get $100 off registration using code QST...
385 0 /
Nate.Gaffaney
Follow /3 May 2017 at 2:51pm / Toad for Oracle Blog

Registration is open for ODTUG Kscope17, June 25-29 in San Antonio, Texas

Join Quest at Kscope17 , June 25-29 in San Antonio, Texas. ODTUG Kscope17 is home to the world’s leading experts on Oracle technology. Our booth will be set up in the exhibit hall, so stop by and see us! Get $100 off registration using code QST...
98 0 /
Deepak Vohra
Follow /2 May 2017 at 11:15pm / IBM DB2 Blog

What's New in IBM DB2 LUW 11.x: DB2 on Cloud for Bluemix

By Deepak Vohra The new IBM DB2 11.x collaboration features are provisioned by IBM’s cloud platform called Bluemix. IBM’s Bluemix provides several IaaS (Infrastructure as a Service) and PaaS (Platform as a Service) cloud services. IBM’s...
203 0 /
Kevin Dalton

Benchmark Factory REST API (Part 1)

As more and more companies try to move to an Agile process for their application development, ways to automate testing has become a popular question we get. How to automate Benchmark Factory testing? Either to fit into a build process, using Jenkins for...
42 0 /
Juan Carlos Olamendy
Follow /1 May 2017 at 2:20pm / MySQL

What's new in MySQL 8.0 DMR

By Juan Carlos Olamendy Turruellas Introduction MySQL 8.0 DMR is been released with a bunch of new, exciting features. Notable features are: Transactional data dictionary implemented as tables in InnoDB Roles as a named collection of...
567 0 /