Chatta subito con l'assistenza
Chat con il supporto

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

Cluster Latency

The Cluster Latency collection provides Cluster Latency and Activity data.

Oracle

Realtime Collection

20

Online

60

Offline

300

Average Global Cache Convert Time

Average amount of time required for the completion of global conversions on GCS resources.

Average Global Lock Convert Time

Average amount of time required for the completion of synchronous and asynchronous global lock converts.

Average Global Lock Get Time

Average amount of time required for the completion of synchronous and asynchronous global lock gets.

Balance

Interconnect Load balance between the various cluster nodes.

Block Received Latency

The average transfer time of a block from another instance.

Block Sent Latency

The average time needed to prepare a requested block.

Blocks Corrupt Percent

The percentage of global cache blocks that encountered a corruption or checksum failure within the entire number of global cache blocks sent over the Interconnect.

Blocks from Interconnect

The number of blocks received from Interconnect after the requests for blocks were not satisfied from the local instance, and therefore had to make a request for the block from the remote.

Blocks to Interconnect

The number of blocks sent via Interconnect after the requests for blocks were not satisfied on the requesting instance, and therefore had to make a request for the block from the local instance.

Blocks/sec from Interconnect

The rate per second of blocks received from Interconnect after the requests for blocks were not satisfied from the local instance, and therefore had to make a request for the block from the remote.

Blocks/sec to Interconnect

The rate per second of blocks sent via Interconnect after the requests for blocks were not satisfied on the requesting instance, and therefore had to make a request for the block from the local instance.

Cluster Latency Rate

The average time it took to transfer a block through the Interconnect, that is, the time that has elapsed since the request for the block was submitted until the block was received by the requesting instance.

Consistent Gets

The number of times a consistent read was requested for a block by this session

CR Blocks Send Time

Total amount of time spent sending constructed CR Blocks through the Interconnect.

Current Block Send Time

Total amount of time spent sending Current Blocks through the Interconnect.

DB Block Gets

The number of data block reads in CURRENT mode (namely, current reads).

GC Blocks Corrupt

The total number of global cache blocks that encountered a corruption or checksum failure during the specified time range As such failures occur during data transfer, high values of this metric can indicate network-related issues.

GC Blocks Lost

Total number of global cache blocks lost during the specified time range. As the loss of global cache blocks takes place during data transfer, high values of this metric can indicate network-related issues.

GC CR Block Build Time

The average time taken by an LMS process to create a consistent read block on a holding instance within the cluster.

GC CR Block Flush Time

The average time taken by the LGWR (log writer) process to flush any changes required to a buffer on the log flush queue.

GC CR Block Receive Time

Total amount of time foreground processes spent waiting for a CR block to be sent through the Interconnect.

GC CR Block Send Time

The average time taken by an LMS process to initiate the sending of a consistent read block. This is NOT the same as the time elapsed before the block arrives at the requesting instance.

GC CR Blocks Received

Total number of consistent read data blocks that Oracle processes did not find in their local cache and had to fetch from the global cache, using a consistent read request.

GC CR Blocks Served

Total number of blocks constructed by the Block Server Process (BSP).

GC Current Block Flush Time

The average time taken by the LGWR (log writer) process to flush the changes from a block to disk (a forced log flush) before the block is shipped to the requesting instance.

GC Current Block Pin Time

The average time taken by an LMS process to pin the current block before shipping it to the requesting instance.

GC Current Block Receive Time

Total amount of time foreground processes waited for a current block to be sent through the Interconnect.

GC Current Block Send Time

The average time taken by an LMS process to initiate the sending of a current block.

GC Current Blocks Received

Total amount of time foreground processes waited for a current block to be sent through the Interconnect.

GC Current Blocks Served

The number of current blocks shipped to the requesting instance over the hardware Interconnect.

Global Cache Convert Time

Total amount of time spent waiting for global cache converts on all sessions.

Global Cache Converts

Resource converts of buffer cache blocks. This statistic is incremented whenever GCS resources are converted from Null to Exclusive, Shared to Exclusive, or Null to Shared.

Global Lock Convert Time

Total time spent waiting for all synchronous and asynchronous global lock converts.

Global Lock Get Time

Total elapsed time of all synchronous and asynchronous global lock gets.

Global Lock Releases

Total number of synchronous global lock releases.

Global Lock Sync Converts

The total number of resources that Oracle converted from an incompatible mode during the selected time range.

Interconnect Block Latency

The average time it takes to prepare and transfer a block across the Interconnect network.

Lost Blocks Ratio

The ratio of global cache blocks losses during data transfer via the Interconnect.

Received from Interconnect Time

Total amount of time the foreground processes waited for blocks to be sent through the Interconnect

Sent to Interconnect Time

Total amount of time spent sending blocks through the Interconnect

Total CR Blocks

The total number of CR blocks that were served/received through the Interconnect

Total Current Blocks

The total number of current blocks that were served/received through the Interconnect.

Total I/C Load

Total number of blocks (both CR and current) that were served and received from the Interconnect.

Cluster Misses

The Cluster Misses collection collects data regarding global cache misses.

Oracle

Realtime Collection

20

Online

60

Offline

300

2-way Misses

The number of current and consistent blocks that were received by the selected instance from a specific instance, after a 2-way roundtrip.

3-way Misses

 

The number of current and consistent blocks that were received by the selected instance from a specific instance, after a 3-way roundtrip.

Consistent Blocks 2-way Misses

The number of consistent blocks that were received by the selected instance from a specific instance, after a 2-way roundtrip.

Consistent Blocks 3-way Misses

The number of consistent blocks that were received by the selected instance from a specific instance, after a 3-way roundtrip.

Consistent Blocks Misses

The number of consistent blocks that were received by the selected instance from a specific instance, after a 2-way or 3-way roundtrip.

Current Blocks 2-way Misses

The number of current blocks that were received by the selected instance from a specific instance, after a 2-way roundtrip.

Current Blocks 3-way Misses

.The number of current blocks that were received by the selected instance from a specific instance, after a 3-way roundtrip

Current Blocks Misses

The number of current blocks that were received by the selected instance from a specific instance, after a 2-way or 3-way roundtrip.

Datafile Fragmentation

The Datafile Fragmentation collection collects information regarding the layout of the free space left in the datafile due to fragmentation.

Oracle

None (on-demand collection).

Datafile name

The name of the datafile

Extent Size

Offset end of the extent from the beginning of the file.

Extent Start

Offset start of the extent from the beginning of the file.

Extent Type

Defines the type of the extent: Used, Fully Usable, Partly Usable or Unusable.

Sequence ID

The datafile’s sequence ID.

Datafile IO Activity

The Datafile IO Activity collection collects metrics and performance ratios related to datafile I/O activity.

Oracle

Realtime Collection

60

Online

300

Offline

900

Avg IO Time

Average time spent on a single IO request for a specific datafile

Avg Read Time

Average time spent on a single physical read request for a specific datafile

Avg Write Time

Average time spent on a single physical write request for a specific datafile

Contents

The type of the tablespace contents (temporary, permanent, undo)

File Full Name

The name of the datafile (including full path)

File ID

The datafile ID

File Name

The name of the datafile (without the path)

File Path

The datafile path

IO Time

The total time spent on carrying out IO operations (reading and writing data) on a specific datafile

Last IO Time

The time spent while performing last I/O operation on a specific datafile

Max Single Read Time

The maximum time spent while reading a single block from a specific datafile

Max Single Write Time

The maximum time spent while writing a single block to a specific datafile

Min Single IO Time

The minimum time spent while reading a single block from a specific datafile

PDB

In multitenant architectures, the name of the pluggable database.

Physical IO

Total size, in blocks, of all disk reads and writes for a specific datafile

Physical IO Percent

The IO activity (block reads + block writes) for a specific datafile as a percentage of the total IO activity for all datafiles

Physical Reads

The number of data blocks read by Oracle, which are not present in the buffer cache or in the PGA, thereby requiring I/O read operations, that is: the total number of data blocks read from disk.

Physical Reads Percent

The block reads carried out for a specific datafile as a percentage of the of total block reads carried out for all datafiles

Physical Writes

Total size in blocks of all disk writes for a specific datafile

Physical Writes Percent

The block writes carried out for a specific datafile as a percentage of the of total block writes carried out for all datafiles

Read Requests

The number of read requests for a specific datafile that read one or more database blocks per request.

Read Time

The total time spent on reading data from a specific datafile.

Single Block Read Time

The total time spent on read requests that read one database block per request from a specific datafile.

Single Block Reads

Number of read requests for a specific datafile, which read one database block per request.

Tablespace Name

The tablespace name.

Write Requests

The number of write requests for a specific datafile that wrote one or more database blocks per request.

Write Time

The total time spent on writing data to specific datafile.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione