Expert Blogs - Toad World

Expert Blogs

Blogs

Brendan Tierney
Follow /27 Jun 2017 at 3:11pm / Oracle Blog

How the EU GDPR will affect the use of Machine Learning - Part 1

On 5 December 2015, the European Parliament, the Council and the Commission reached agreement on the new data protection rules, establishing a modern and harmonised data protection framework across the EU. Then on 14th April 2016 the Regulations and Directives...
64 0 /
Pini.Dibask
Follow /27 Jun 2017 at 9:40am / Oracle Blog

Summary of Austrian Oracle User Group (AOUG) 2017 conference

Last week (on June 20th) I presented a session about the Oracle Database Locking Mechanism at the Austrian Oracle User Group (AOUG) conference. This event took place in beautiful Vienna and was my first attending this event. It's a small, one-day...
58 0 /
Dan Hotka
Follow /26 Jun 2017 at 8:46pm / Oracle Blog

Database Performance Problems: Finding the Root Cause

Hi! This article will cover some useful tips in finding the root cause of your application performance issues. Some of these suggestions might be useful to enhance your help-desk solutions; others might be useful in determining whether the performance...
91 0 /
Dan Hotka
Follow /26 Jun 2017 at 8:28pm / Oracle Blog

Oracle 12 New Partitioning Features

Hi, I’m still learn from other speakers! Last week, Quest sponsored a Toad Maven seminar event downtown Chicago. I did an Advanced Indexing presentation and showed tuning topics in Toad. Watch for my blog announcements for future events. Greg...
62 0 /
Dan Hotka
Follow /26 Jun 2017 at 7:37pm / Oracle Blog

Oracle Index Tips and Techniques

Hi, I just wrote an article ( click here to see article) that illustrates how B-Tree indexes work. Basically, they store key values that are to be looked up in their associated table. So, key values and rowids are stored at the index leaf level, and...
73 0 /
Dan Hotka
Follow /26 Jun 2017 at 7:07pm / Oracle Blog

Preventing SQL Injection in Your Applications

Hi, SQL Injection is the unwanted addition of “other” logic into the database via the SQL language. Malicious attacks pass additional syntax either in hopes of gaining additional information (lets them in, in another way, possibly with...
61 0 /
Dan Hotka
Follow /26 Jun 2017 at 6:42pm / Oracle Blog

Rising Above: Publishing Books - Share Your Expertise!

Hi, I have written fourteen published books. I have self-published three additional books. This article will discuss some practical steps on how to go about writing books through a publisher and publishing books on your own. There used to be many...
59 0 /
Anju Garg
Follow /26 Jun 2017 at 5:12pm / Oracle Blog

Oracle Multi-tenant Application Containers - Part I

Introduction Multi-tenant container database architecture in Oracle Database 12cr1 The Oracle Database 12 c Release1 introduced the Oracle Multi-tenant architecture, which allowed consolidation of multiple pluggable databases (PDBs) together in...
757 1 /
Gokhan Atil
Follow /22 Jun 2017 at 12:51pm / Oracle Blog

Introduction to Oracle Big Data Cloud Service – Compute Edition (Part V) – Pig

This is my last blog post of my introduction series for Oracle Big Data Cloud Service – Compute Edition. In this blog post, I’ll mention “Apache Pig”. It’s a tool/platform created by “Yahoo!” to analyze large...
110 0 /
Deepak Vohra
Follow /21 Jun 2017 at 10:21pm / Oracle Blog

Proactive Oracle Database management on AWS RDS with AWS CloudWatch

Proactive database management is based on monitoring a database and taking pre-emptive measures to keep the database running at the required level of performance. AWS (Amazon Web Services) RDS (relational database service) is a reliable and scalable managed...
91 0 /
Deepak Vohra
Follow /21 Jun 2017 at 6:54pm / Oracle Blog

Modularization by using Oracle Database Containers and PDBs on Docker Engine

Modularization has become essential as the scale of database usage has increased. Oracle Database 12c introduced Container Databases (CDBs) and Pluggable Databases (PDBs) around the middle of 2013. A Container Database (CDB) consists of zero, one, or...
299 0 /
Deepak Vohra
Follow /19 Jun 2017 at 10:19pm / Oracle Blog

Infrastructure as Declarative Code - Using AWS CloudFormation for an RDS DB Instance for Oracle Database

AWS CloudFormation is a template-based service to provision and manage infrastructure on AWS, consisting of a group of AWS resources such that the overhead tasks, such as describing the dependencies between AWS services or providing runtime parameters...
119 0 /
Clarisa Maman Orfali
Follow /17 Jun 2017 at 7:47pm / Oracle Blog

Conoce el Tema Material APEX una alternativa al Tema Universal 42

Hola a todos, hoy quiero compartir con ustedes que se han cumplido 2 años del proyecto que ha iniciado Vincent Morneau del Tema Material APEX. Vincent nos cuenta que hace 2 años empezó este proyecto con el objetivo de proporcionar...
158 0 /
Juan Carlos Olamendy
Follow /15 Jun 2017 at 12:28am / MySQL

Transportable tablespaces in InnoDB

By: Juan Carlos Olamendy Turruellas Introduction Transportable tablespace is a mechanism to copy and move large data very easily and efficiently between different MySQL instances. Transportable tablespace is faster than any other mechanism...
54 0 /
Gokhan Atil
Follow /14 Jun 2017 at 11:20am / Oracle Blog

Introduction to Oracle Big Data Cloud Service – Compute Edition (Part II)

In my previous post, I gave a list of installed services on a Oracle Big Data Cloud Service when you select “full” as deployment profile. In this post, I’ll explain these services and software. HDFS: HDFS is a distributed, scalable...
149 0 /
Gokhan Atil
Follow /14 Jun 2017 at 11:20am / Oracle Blog

Introduction to Oracle Big Data Cloud Service (Part II) – Services

In my previous post , I gave a list of installed services on a Oracle Big Data Cloud Service when you select “full” as deployment profile. In this post, I’ll explain these services and software. HDFS: HDFS is a distributed, scalable...
104 0 /
Gokhan Atil
Follow /14 Jun 2017 at 11:20am / Oracle Blog

Introduction to Oracle Big Data Cloud Service – Compute Edition (Part II) – Services

In my previous post , I gave a list of installed services on a “Oracle Big Data Cloud Service – Compute Edition” when you select “full” as deployment profile. In this post, I’ll explain these services and software....
79 0 /
Julie Hyman
Follow /13 Jun 2017 at 9:47pm / Toad Data Point Blog

If you could change one thing about Toad Data Point ...

Tell us how we can make Toad Data Point better for you and your team. You have the floor. We're listening. Can we set up a brief phone chat for you to tell me how to improve Toad for you? What you like about the product What you dislike...
46 0 /
Mohamed.Houri
Follow /13 Jun 2017 at 3:33pm / Oracle Blog

Why my execution plan has not been shared - Part V

In this fifth installment of this series of articles about the non-sharing reasons that prevent Oracle from using an existing execution plan, we are going to dig into two new supplementary reasons: language_mismatch and auto_check_mismatch . The same...
184 0 /
Julie Hyman
Follow /8 Jun 2017 at 5:56pm / Toad for Oracle Blog

Let an Oracle Expert Treat You to Lunch and Some Free Training Next Week

Claim your free seat at the Toad World Maven Roadshow , coming to Chicago on June 14. We're sending some of the world's leading Oracle experts out to offer a one-time completely free training session to developers and DBAs -- and seats are...
95 0 /
Julie Hyman
Follow /8 Jun 2017 at 5:54pm / Oracle Blog

Let an Oracle Expert Treat You to Lunch and Some Free Training Next Week

Claim your free seat at the Toad World Maven Roadshow , coming to Chicago on June 14. We're sending some of the world's leading Oracle experts out to offer a one-time completely free training session to developers and DBAs -- and seats are...
110 0 /
Bert Scalzo
Follow /7 Jun 2017 at 7:56pm / Oracle Blog

Oracle In-Memory's Performance Screams

Since the dawn of database technology the Achilles heel or key limiting factor has been disk IO. In order to address this issue traditional spinning disk drive vendors historically offered 10K and even 15K RPM models. But more speed was needed. Then came...
177 0 /
Denny Cherry
Follow /7 Jun 2017 at 5:00pm / SQL Server Blog

Azure Import Export Services – Notes from the field

One of my clients recently had the need to upload tens of terabytes of data into Azure Blob Storage. This gave us the perfect opportunity to use the Azure Import Export service to get these several terabytes of data into Azure by using the Azure Import...
160 0 /
Porus Homi Havewala
Follow /6 Jun 2017 at 8:13pm / Oracle Blog

Database as a Service using Enterprise Manager - Part I

by Porus Homi Havewala In our brand-new article series, we will explore the capabilities of Oracle's Enterprise Manager Cloud Control 13c for the private Database as a Service (DBaaS) Cloud – how to set up such a cloud, and how to use it...
362 0 /
Porus Homi Havewala
Follow /6 Jun 2017 at 7:46pm / Oracle Blog

Oracle Hybrid Database Cloud using Enterprise Manager - Part I

by Porus Homi Havewala Oracle Enterprise Manager 12.1.0.5 has been available since June 2015. From this release onwards, you could use an on-premises Enterprise Manager OMS (Oracle Management Service) to install hybrid cloud agents on Oracle Public...
400 0 /