We all know that over time the tablespaces in our Oracle database(s) get fragmented. Database and application performance can suffer from this fragmentation.
Fragmentation happens when your applications are inserting, updating and/or deleting data. You…
As part of most any database monitoring software evaluation, it includes comparing that software to similar solutions. Logically, it often means doing head-to-head comparisons to database tools that come bundled with that particular DBMS. Regularly, I…
Patching, Upgrading or Migrating your Oracle Database can leave you feeling that you're in the midst of the same tornado that swept Dorothy into the Land of Oz; and you might run into some of the same characters as well. Here's how SharePlex, Quest's…
We’re all in the same global boat. In response to COVID-19, and to curtail the spread and keep employees and the general population well, companies worldwide have suddenly sent their employees home to work.
Here at Quest, we love winning awards – really, who doesn’t? But some awards feel more meaningful than others. We’re referring to the ones that come from customers’ ratings of Quest solutions, like the Best Software awards from G2. Quest was recently…
We all remember Abbott and Costello’s skit “Who’s On First?”. If you haven’t seen it, I highly recommend you pop over to YouTube and give it a watch. It has become one of the legendary classic comedies of all times, with Costello not knowing baseball…
I’ve been interested in weather, meteorology and clouds in the sky for as long as I can remember; which may explain why one of my favorite songs is Joni Mitchell’s “Both Sides Now”. I’ve learned that some clouds are pretty, and…
For a Happy Halloween and a happy time anytime in Toad! Enjoy these five sugar free Toad Treats!!
It is a foregone conclusion that performance monitoring is part and parcel of managing a database instance once it is in production. But what about pre-production? Especially when the instance itself is reaching critical phases of testing and quality…
In Part 1 of this blog post, I review how you can get an evaluation copy and explain the various integration points from Quest’s monitoring solutions – Foglight and Spotlight Enterprise. You can find it here -> https://www.quest.com/community…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
Are you looking for a simpler, more effective way to carry out code quality reviews of all your Oracle PL/SQL code that takes subjectivity out of the equation and gives you the foundation for an automated way to review your code as part of a DevOps process…
Is your organization moving to agile development and DevOps and you now have to test your Oracle PL/SQL code and have no idea what to do? Your worries are over! With Toad for Oracle, creating some simple PL/SQL unit tests to get started is really easy…
Sometimes authorizing a product can be confusing with the terms that are used.
As with many Quest products, there is a two-step authorization process.
A license key or Authorization key will need to be inputted; along with its Site Message string.
These…
We all tend to spend most of our time on the “turnpike” of a product’s feature set: you know, the “power” set of its features that get us to many of our endpoint destinations within the product as productively as…
It doesn’t matter what type of organization you are; small, big, public or private – everyone has a database of some description. Databases come in many forms from Microsoft Exchange, Oracle, SQL to a litany of lesser known databases. The database, for…
Does the process of replicating data from one source to another fill your body with an inner joy like it does mine? The thrill of changing data in one location and watching those changes appear in another, in my eyes is better than well you know….. Ice…
You will see that our quest for a fully web-enabled client is full steam ahead! We just released Stat 5.8.1. This is a maintenance release that previews some cool new features and fine tuning of the infrastructure that will be a part of the upcoming Stat…
I’m sure Oracle DBAs everywhere are keeping their collective ears close to the ground waiting for the official announcement on 12cR2. We still, rightly or wrongly, have a habit of waiting for the 2nd release of Oracle versions, but that’s for another…
During October 2015, Oracle announced that the Extended Support Fee for Oracle Database 11g R2 will be waived until May 31, 2017. After this period, Extended Support for Oracle Database 11g R2 will be offered until December 2020.
A primary concern for…
