SharePlex is a database replication tool for replication in real-time. SharePlex does not incur a downtime for the source database, which makes it suitable for a high availability environment. SharePl...
In this popular article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database-as-a-Service (DBaaS) cloud – including the setup of such a clo...
In this video, see how to take advantage of your monitor space with single or multiple document interfaces when using Toad for Oracle....
The following Toad for Oracle Apps are available for download as examples/samples. Click on the App name to download an App. App Description Verify Server is Up This Toad App pings a server and...
Recently I tuned the peformance of a oracle pl/sql package. The description of the issue: This package is taking about 17 hours to complete. This packages is having approximately 3000+ lines of code...
You know the score, you are running an impdp and it looks to have hung up. You’ve watched the log file (or on screen messages) and it’s sitting at something like: Processing object type TABLE_EXPORT/...
Well maybe not the best tip ever, but certainly one of the most popular in Toad Tips and Tricks sessions. The Toad Script Runner (TSR), not terminate and stay resident for you old time IT folks J is a...
This is my second (of five) post on using Python to process Twitter data. Check out my all the posts in the series. In this post I was going to look at two particular aspects. The first is the conver...
Recently I had to present at eProseed AnualTech conference in Luxembourg and I was requested to present a topic something about Oracle18c. Obviously I don't want to talk and repeat the same about Aut...
In one of the recent database migration & upgrade activities, I have migrated an Oracle EBS database 11.2.0.4 to a new DB host and upgraded to 12.1.0.2. After migration and post upgrade, an utlrp.sql ...
Oracle Database Vault was configured on RAC database v11.2.0.3 and appropriate permissions given to allow the regular duties, such as data pump export/import etc.However, when classical/traditional im...
En este artículo vamos a aprender a analizar código utilizando la herramienta de diagnóstico del Toad for Oracle llamada “Code Analysis”. Esta herramienta muestra una serie de métricas estándares de ...
