Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 6.1.0.10 - 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

Archive Log Destinations Table

When monitoring a RAC, the contents of the Archive Log Destinations table vary between Whole Cluster and Instance/RAC node view, as in whole cluster view the table also includes the column Instance Name, as described below.

 
Table 26. Archive Log Destinations Table
Name
Description

Instance Name

Indicates which of the RAC nodes uses the specified destination archive file.

NOTE: The Instance Name column is displayed only in whole cluster view. From the Archive Destination column and forwards, the two tables are identical.

Archive Destination

The name of the destination archive file.

Destination Directory

The name of the destination directory.

Destination Status

The current status of the destination in v$archive_dest.

This destination can have one of the following values:

•
VALID — destination was initialized and is available
•
INACTIVE — no destination information exists
•
DEFERRED — destination was manually disabled by the user
•
ERROR — an error occurred during open or copy
•
DISABLED — disabled after error
•
BAD PARAM — parameter has errors
•
ALTERNATE — the destination is in an alternate state
•
FULL — the destination’s quota size has been exceeded

Destination Total

The total size of the archive destination target.

Destination Free Space

The total amount of free space available for the archive destination target.

Destination Usable

The total amount of usable space available for the archive destination target.

NOTE: The Destination Total, Destination Free Space, and Destination Usable columns display information only if the archive is managed using ASM and the ASM instance is installed and configured.

Time to Failure

The amount of time before the archive log destination becomes full.

Binding

The binding setting, which describes whether successful archival is required:

•
MANDATORY
•
OPTIONAL

Destination Type

The type of archived log destination — either PUBLIC or PRIVATE.

Transmit Mode

The mode in which data is transmitted across the network:

•
SYNCHRONOUS
•
ASYNCHRONOUS, or
•
PARALLELSYNC

Valid Type

The Redo log type or types that are valid for the destination:

•
ONLINE_LOGFILE
•
STANDBY_LOGFILE
•
ALL_LOGFILES

Invalid Objects Panel

The Invalid Objects panel displays all of the database’s schema and the invalid objects detected in each schema, as well as their distribution per schema.

This panel comprises the following sections:

•
Invalid Objects Table
•
Invalid Objects Distribution chart — see Invalid Objects Distribution for the selected schema .
Invalid Objects Table

The Invalid Objects table displays each schema in a separate row, together with invalid objects of the following types:

•
Functions
•
Packages
•
Package bodies
•
Procedures
•
Types
•
Views
•
Materialized Views
•
Other type objects

In addition, the table displays the total number of invalid objects and the alarms invoked as a result of the invalid objects detected in the schema.

* 
IMPORTANT: By default, all of the schemas are monitored by the Invalid Objects collection. A schema with no invalid objects is displayed with a zero value in all of its columns. To exclude specific schemas from being monitored, use the Exclude List pane under the Collection Settings view in the Databases Administration dashboard. For details, see Invalid Objects Filtering .

For each object type (for example, Procedures) whose metric value contains data, that is: a number greater than zero, clicking the metric value displays a popup with a detailed list of all invalid objects for the specific object type in the selected schema.

Invalid Objects Distribution for the selected schema

The invalid objects distribution chart displays the distribution of the invalid objects for the schema selected in the Invalid Objects table.

Database Backup Panel

The Database Backup panel displays various details regarding the backup of the Oracle database and datafile.

This panel contains the sections listed below.

•
Last Successful Backup — the exact time and date when the most recent full backup of the datafile and database took place . A warning icon appears to the left of this section’s title if the time that elapsed from the last successful backup date exceeds a predefined threshold (by default, seven days).
* 
IMPORTANT: The threshold for the number of days that elapsed since the last successful full backup of a specific database can be configured by modifying the settings of the Days Since Full Backup alarm, in the Threshold section of the Alarms view in the Databases Administration dashboard. For details, see “Modifying alarm threshold values” on page 179.
•
Configuration Parameters — user-defined parameters that configure the backup operation, such as the device type and the backup jobs parallelism.
•
Backup Jobs — a list of the backup operations that took place during the selected time range.
A backup operation can have one of the following statuses:
•
Completed
•
Failed
•
Completed with errors
•
Completed with warnings
Operations with a Completed status are indicated with a green check mark icon (), while a warning icon appears near each operation whose status is other than Completed. Each backup job is identified by both the Start Time column, which indicates whether the backup was carried on a database or a datafile, and the Job ID column.
Clicking the row displays a popup with the details of the backup job in the selected row.

Reviewing Configuration Settings

Use the Configuration drilldown to review the current configuration settings of the Oracle agent, as well as tracking the modifications made to these settings.

This drilldown comprises the following panels:

•
SGA — displays the settings and utilization of the SGA memory, using different display for the RAC and instance levels. For details, see Reviewing SGA Settings at the RAC Level and Reviewing SGA Settings at the Instance Level .
•
Initialization parameters — displayed at both the instance and the RAC levels. For details, see Reviewing the Initialization Parameters .
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating