Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.3.20 - User Guide

Installing and Configuring Agents Using Foglight for Oracle
Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor Foglight for Oracle Overview Dashboard Overview view Advisories view SQL Performance Investigator (SQL PI) Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert Log Reviewing Monitored Data Guard Environments Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Host Properties

Purpose

The Host Properties collection provides operating system version, CPU, memory and network host properties.

Operating System

Realtime Collection

300

Online

900

Offline

86400

Machine Model

The model of the host machine (for example: Sun Fire V240)

Number of CPU

The number of CPU units installed on the host

Number of IO Devices

The number of IO devices configured on the host

Number of Network Interfaces

Number of network interfaces installed on the host

Operating System

The name of the operating system installed on the host

Operating System Version

The version of the operating system installed on the host

Physical Hostname

The host name, defined per network interface

RAM

The amount of RAM available on the physical host

Initialization Parameters

The Initialization Parameters collection collects definitions and change tracking history of Oracle’s initialization parameters.

Oracle

Realtime Collection

900

Online

900

Offline

3600

Current Value

Parameter value for the session (if the value was modified within the session); otherwise, the instance-wide parameter value.

Description

The parameter description

Instance Level

Indicates whether the parameter can have a different value for each instance (TRUE) or must retain the same value for all RAC nodes (FALSE).

Is Default?

Indicates whether the parameter’s value is set to the default value (TRUE) or was modified (FALSE)

Is Deprecated?

Indicates whether the parameter has been deprecated (TRUE) or not (FALSE)

Is Dynamic?

Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)

Is Modified?

Indicates whether the parameter has been modified after instance startup:

Is System Modifiable?

Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect.

This metric can have one of the following values:

Parameter

Initialization parameter name

PDB

In multitenant architectures, the name of the pluggable database.

Show Hidden Parameters

Indicates whether the parameter is hidden (TRUE) or not (FALSE)

Type

Indicates the parameter type.

The possible values are as follows:

Instance General

The Instance General collection collects general instance data such as version and archive logging.

Oracle

Realtime Collection

300

Online

900

Offline

3600

DB Version

The database version.

Is Archived

Indicates whether the instance is configured in archive mode.

Is Connected to ASM

Indicates whether the instance is an Automatic Storage Management (ASM) instance.

Is Data Guard Configured

Indicates whether Data Guard is configured on this instance.

Is Exadata

Indicates if this instance is part of Exadata Architecture.

Is Flashback Configured

Indicates whether the flashback recovery is configured.

Is RMAN Configured

Indicates whether RMAN is configured on the database for backup and recovery.

Invalid Objects

The Invalid Objects collection collects data about invalid objects in each schema.

Oracle

Realtime Collection

20

Online

60

Offline

300

Invalid Functions

Number of invalid functions in the schema

Invalid Package Bodies

Number of invalid package bodies in the schema.

Invalid Packages

Number of invalid packages in the schema.

Invalid Procedures

Number of invalid procedures in the schema.

Invalid Types

Number of invalid types in the schema.

Invalid Views

Number of invalid views in the schema.

New Invalid Functions

The number of invalid functions that are found to be present in the schema, and were not detected during the last run.

New Invalid Package Bodies

Number of invalid package bodies that were added to the schema during the last sampling period.

New Invalid Packages

Number of invalid packages that were added to the schema during the last sampling period.

New Invalid Procedures

Number of invalid procedures that were added to the schema during the last sampling period.

New Invalid Types

Number of invalid types that were added to the schema during the last sampling period.

New Invalid Views

Number of invalid views that were added to the schema during the last sampling period.

Others

Number of invalid objects of other object types in the schema.

PDB

In multitenant architectures, the name of the pluggable database.

Schema Name

The name of the schema that contains the invalid objects

Total Invalid Objects

Total number of invalid objects in the schema

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating