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…
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 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:
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…
With the advent of Oracle Release 12.2.x, Oracle has delivered to its customers the ability to do online patching for their environments. According to Oracle, this new feature will help customers “greatly reduce the downtime that was needed in previous…