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...
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...
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....
Introduction The Oracle Database 12c Release 1 introduced the Oracle Multi-tenant architecture, which allowed consolidation of multiple pluggable databases (PDBs) together in a multi-tenant container...
This video describes how to make the most of your JSON data in Toad Edge...
This video describes the SQL Recall feature in Toad Edge. How to sort, and clear entries, how to use recalled statements and how to pin statements for reuse....
In this video, the user is shown how track schema changes over time with the snapshot feature in Toad Edge. Video demonstrates how to create snapshots, compare snapshots to active database and compare...
The ProjectConvertor.exe can be used to convert from the pre-7.2 binary Oracle capture project file format to a XML format. To use – Download either the 32-bit or 64-bit ProjectConverter zip file a...
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...
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 th...
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 pluggabl...
Are you getting execution performance bottlenecks in your PL/SQL code and not sure what to do? This video shows how to detect and report on a performance bottleneck using profiling techniques. Downlo...
