Foglight for Oracle (Cartridge) 5.9.2.1


Metric	Description
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

Purpose

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

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	900
Online	900
Offline	3600

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:

•

MODIFIED — the parameter has been modified with ALTER SESSION

•

SYSTEM_MOD — the parameter has been modified with ALTER SYSTEM, thereby modifying all of the currently logged-in session values

•

FALSE — the parameter has not 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:

•

IMMEDIATE — the parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used for starting the instance. The change takes effect immediately.

•

DEFERRED — the parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used for starting the instance. The change takes effect in subsequent sessions.

•

FALSE — the parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used for starting the instance. The change takes effect in subsequent instances.

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

Purpose

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

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	300
Online	900
Offline	3600

Metric Descriptions


Metric	Description
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

Purpose

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

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	20
Online	60
Offline	300

Metric Descriptions


Metric	Description
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

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for Oracle (Cartridge) 5.9.2.1 - User Guide

Host Properties

Initialization Parameters

Instance General

Invalid Objects