Expert Blogs - Toad World

Expert Blogs

Blogs

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...
59 0 /
Deiby Gomez
Follow /24 May 2017 at 3:18pm / Oracle Blog

How to run SQL Statements across Pluggable Databases with catcon.pl

By Deiby Gómez Introduction: Beginning with Oracle Database 12.1.0.1.0, 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...
29 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...
31 0 /
Deiby Gomez
Follow /24 May 2017 at 2:19pm / Oracle Blog

Oracle Database 12xR2 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...
25 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...
28 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 (12.2.0.1.0). I have already written about this topic in the article “ Introduction to Application Containers in...
220 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...
34 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...
52 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...
66 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.
66 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...
272 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...
276 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...
193 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...
239 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...
385 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: ...
747 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...
347 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...
475 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 ...
319 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. ...
404 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...
72 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...
457 0 /