The Problem: When PGA Memory Goes Wild
Recently, a customer approached us with a common yet challenging issue: “We have many queries consuming a lot of PGA memory. Can Foglight help us find which queries consume the most?”
This question touches…
Recently, a customer approached us with a common yet challenging issue: “We have many queries consuming a lot of PGA memory. Can Foglight help us find which queries consume the most?”
This question touches…
On a customer call recently and the customer was asking if our Foglight for Oracle agent included an alert for blocking locks.
This is a rare question for me, since Oracle database customers don’t tend to see issues with blocking locks compared to SQL…
I was recently talking to a customer who wanted some help tracking Oracle process memory usage on Windows. They had a problem with a bug causing a memory leak and had a support case open for that. They were happy with the SQL PI feature in Foglight that…
We are very excited to announce the general availability of Quest® Foglight® version 6.3.
Foglight is the world’s broadest and deepest monitoring and optimization solution for the hybrid enterprise. Foglight brings unique top-to-bottom…
If you are reading this, chances are you’re considering a 30 day trial of ‘Foglight for Cross Platform Databases’. Before you do, here are a few tips that will help you get a fully functional Foglight installation up and running quickly…
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…
This is the second in a multi-part series on how to leverage Foglight to save money within your IT budgets. To review the first part, managing monitoring vendor sprawl, check out the post linked here.
This post is going to cover another way to save money…
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…
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…
“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…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
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…
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: