Toad World


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...
315 1 /
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...
208 0 /
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...
472 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...
494 1 /
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...
489 0 /
Dan Hotka
Follow /12 Apr 2017 at 9:34pm / Oracle Blog

A couple of good index questions from a novice

Hi, This blog comes from the e-mail bag. [:)] One of my followers asks two useful questions that a novice to relational databases or an end user/power user is likely to have. The questions relate to ‘how does it work’, a fun series on discovery...
614 0 /
Dan Hotka
Follow /12 Apr 2017 at 9:30pm / Oracle Blog

Oracle Compressed Tables

Hi, Did you know that Oracle supports compression in various forms in the database? You can compress an entire tablespace (all of its contents), a table, or part of a table (at the partition level). Using sub-partitioning, the sub-partitions can be...
686 1 /
Dan Hotka
Follow /12 Apr 2017 at 9:04pm / Oracle Blog

Cross Database Partitioning (Sharding)

By Dan Hotka Hi, Sharding is a method of having a widely distributed database across various hardware platforms utilizing a mix of database technologies. Sharding extends partitioning to various distributed databases that don’t even have...
596 0 /
Dan Hotka
Follow /29 Mar 2017 at 4:24pm / Toad Data Point Blog

Data Prep Using Toad Data Point

By Dan Hotka Hi, Toad Data Point has been around a while. Its primary use is preparing data and assisting with data analysis. The power of this tool is that it can pull and include data from just about any data store, and mix that data for specific...
291 1 /
Dan Hotka
Follow /20 Mar 2017 at 8:03pm / Oracle Blog

Index Clustering Factor and Oracle

Hi, There is quite the scenario that the Oracle Cost-Based Optimizer (CBO) uses when deciding when to use indexes to process your SQL. I go into this in great detail in my SQL Performance Tuning course ( click here for details ). Clustering factor...
641 0 /