How-to configure Oracle Database monitoring

Posted: August 21st, 2008 | Author: TnT Admin | Filed under: How-Tos | Tags: , , | 8 Comments »

Most of the time, with every application, there comes with the Database setup and most of the time, it’s Oracle (being the biggest player in the DB industry). Fundamentally, (1) it requires a Oracle client to be installed on the machine as a native client. (2) A valid account and privileges to the Oracle V$ tables that holds statistics. (3) Ensure that you can properly query from the Controller using the SQL tools and extract data from the V$ table and you should be fine with the setup. In this article, we will be providing the a typical connection to the Oracle database for monitoring (i.e. we will not be focusing on counters directly related for analyzing database performance).

Let’s go through an overview for implementing the Oracle DB. Basically, we are doing in this sequence: Read the rest of this entry »

Analyzing Oracle SGA Shared Pool (Data Dictionary Cache)

Posted: February 24th, 2008 | Author: TnT Admin | Filed under: Analyze | Tags: | No Comments »

Like the Library Cache, the measure of the effectiveness of Data Dictionary Cache is expressed in terms of hit-ratio percentage. This Data Dictionary Cache hit ratio shows how frequently the application finds the data dictionary information it needs in memory, instead of having to read it from the disk.

The counters that we should be watching are as followed: Read the rest of this entry »

Newer Entries »