Just like most people’s goal towards incorporating more raw food into their daily diet, accessing and manipulating raw data is very much a coveted functionality.
The Spotlight Statistics Repository database is a repository for historical data c...
April 15, 2019.....Let’s give a shout out to all those men and women running the Boston Marathon today.
Man, running for that long must be taxing. Taxing…..wait…what day is it again?
So, as my way of giving a nod to long runners,...
A UI Query can be used to add either static or dynamic components to a service definition via the Service Builder dashboard. This in turn offers a great range of additional things Foglight can do. This post will introduce creating a service definitio…
In the first part of this series, we will learn how to export SQL statements from Foglight SQL Performance Investigator, and import them into SQL Optimizer.
Start by opening SQL PI, and selecting a database from the Databases dimension. This simplifi…
A UI Query can be used as a shortcut to building a custom dashboard or report. This can save time and frustration by publishing either frequently accessed or hard to find data in an easy to use spot.
In my Introduction to UI Queries p...
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.
https://www.quest.com/community/quest/p…
Take Off the Blindfold. Discover key methods to manage cross-platform database performance. With our tips, you’ll spend less time on issues and more binging Netflix.
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 monitorin...
A UI Query can be used as an input to a report. This can simplify and offer a broader range of inputs when running or scheduling a report.
For a refresher on creating UI Queries, this post covers the basics.
WCF reports have inputs in ord...
In my Introduction to UI Queries post, the building of a simple query to return all SQL Server Agent Jobs was shown.
Let's back up a step, and take a look at where UI Queries can be used in Foglight. This post will be updated with links as the ...
Spotlight Enterprise 12.4 comes with some neat features you do not want to miss!
Query Execution Plans available when needed the most:
The Workload Analysis and the Query Execution Statistics drilldowns expose the most resource intensive transactions…
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-database...