For those Toad for Oracle users that often execute long running queries using F9, they always ask me how they can still work in Toad without having to wait on the query to finish. The problem seems to be the user sees the dialog box below in Figure 1…
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…
Today, is the official, general release date of Toad for Oracle 13.2. There many new features that go with this newest version, if you’re interested in reading more, read this blog, “13 new features in Toad® for Oracle 13.2.”
This…
As part of Quest’s Database Training Days webcast series, Oracle ACE Janis Griffin presented her top 5 Oracle performance tuning tips. Janis’ webcasts are always packed with valuable information, and this one didn’t disappoint as she imparted her…
It’s always an educational experience to listen to Oracle ACE Director, Janis Griffin talk about database performance tuning and the features that help make life easier. In a recent Database Training Days webcast session, Janis brought a whole new…
In our new reality of social distancing and remote work, it’s nice to hear a friendly voice that isn’t your spouse, kids or dog! It’s even better when that friendly voice is imparting words of wisdom that make your job easier. So, that’s what Quest has…
If you’re one of the busiest travel sites on the internet and want to perform an AWS cloud migration of your bookings database while simultaneously upgrading your Oracle version, you know that any interruption in service could be costly. It’s simply not…
What if you woke up one morning and found that you had a doppelganger who was enthusiastically running around pretending to be you, spending your hard-earned money and doing who knows what with your identity. It sounds like a nightmare, right? But this…
This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle. These monitoring options come included at no additional cost and illustrate how broad and complete Foglight is as an Oracle monitoring solution…
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…
This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle.
Part 1 of the blog covers Foglight’s monitoring for Oracle’s Data Guard.
Hold on, grammar and spelling enthusiasts. Already, you might be thinking, did he mean ‘Complementary’ or ‘Complimentary’? The answer? YES. This blog series focuses on additional Oracle monitoring capabilities beyond monitoring the Oracle instance…’complementary…
In 12c, Oracle introduced support for a new architecture - multi-tenant. As such, the Container database (or CDB) was introduced. Think of the CDB as the 'super database'. This multi-tenant container database allows for many 'sub-databases'. These are…
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…
“The Only Thing That Is Constant Is Change “- Heraclitus.
Development, new applications, upgrades, patches, maintenance, schema updates…the list goes on and on around ways that changes are introduced into your environment. Sometimes these…
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…
My favourite feature in Toad has always been the PL/SQL Profiler. I love the way it can profile your code executions is integrated with the editor. It is such an easy and visual feature to use.
So if you have Foglight for Oracle Performance Investiga…
For a Happy Halloween and a happy time anytime in Toad! Enjoy these five sugar free Toad Treats!!
For those of you that have been using Foglight for some time may have seen how the solution not only captures and retains metric data historically, but also applies baselines to estimate the system performance and help with system monitoring and planning…
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…
Recently, I spoke with a customer who's using Foglight for Oracle to monitor their RAC instance. They were able to successfully monitor the instance, but then asked "Why don't I see any data in the ASM tab?". I think this is a great question and I thought…
We are pleased to announce the general availability of Foglight for SQL Server and Foglight for Oracle versions 5.7.5.35. This release provides the following significant enhancements:
