Chat now with support
Chat with Support

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

OS File System IO Summary

The OS File System IO Summary collection provides IO information about the operating system.

Operating System

Realtime Collection

20 seconds

Online

60 seconds

Offline

300 seconds

Operating System

The name of the operating system where the selected instance is running.

System Physical Reads

The number of physical read operations carried out from this operating system.

System Physical Writes

The number of physical write operations carried out from this operating system.

System RW Operations

Total number of disk operations (both read and write) carried out by the operating system. This metric does not include operations that were satisfied using the file system.

OS General Network Summary

The OS General Network Summary collection provides network information about the operating system.

Operating System

Realtime Collection

20

Online

60

Offline

300

Net Collisions

The number of times two computers sent packets at the same time on the network, and the packets “collided”, resulting in the need to retransmit both packets.

Net Errors

Number of errors reported on the various network interfaces.

Network Name

The network interface name.

Operating System

The name of the operating system where the selected instance is running.

Packets

The total sum of packets received and sent on this network interface (the sum of the packets_in and packets_out values).

Packets In

Number of packets received by this network interface.

Packets Out

Number of packets sent from this network interface.

Parallel

The Parallel collection provides information about the instance’s parallel executions.

Oracle

Realtime Collection

20

Online

60

Offline

300

Active Parallel Sessions (11i)

Number of active parallel sessions

Active Serial Sessions (11i)

Number of active sessions that were serialized

DDL Statements Parallelized

Number of DDL statements that were executed in parallel

DML Statements Parallelized

Number of DML statements that were executed in parallel

Parallel operations Downgraded

Total number of times parallel execution was requested but execution was downgraded

Parallel Operations Downgraded 1 to 25 Pct

Number of times parallel execution was requested but execution was downgraded up to 25% due to insufficient parallel execution servers

Parallel Operations Downgraded 25 to 50 Pct

Number of times parallel execution was requested but execution was downgraded 25% or more as a result of insufficient parallel execution servers

Parallel Operations Downgraded 50 to 75 Pct

Number of times parallel execution was requested but execution was downgraded 50% or more as a result of insufficient parallel execution servers

Parallel Operations Downgraded 75 to 99 Pct

Number of times parallel execution was requested but execution was downgraded 75% or more as a result of insufficient parallel execution servers

Parallel Operations Downgraded to Serial

Number of times parallel execution was requested but execution was serial as a result of insufficient parallel execution servers

Parallel Operations not Downgraded

Number of times parallel execution was executed at the requested degree of parallelism

Parallel QC (11i)

The number of parallel query coordinators

Parallel Slaves (11i)

The number of parallel slaves

PQ Servers Busy

The number of servers that were simultaneously executing SQL queries and DML statements.

PQ Servers Busy Percent

The percent of busy parallel servers within the total number of parallel servers

PQ Servers Idle

The number of currently idle parallel servers

PQ Servers Limit

The maximum allowed number of parallel servers

Queries Parallelized

Number of SELECT statements executed in parallel

PGA Statistics

The PGA Statistics collection collects information about the use of the PGA memory.

Oracle

Realtime Collection

20

Online

60

Offline

300

PGA Aggregate Target

The value of the PGA Aggregate Target parameter in bytes.

The pga_aggregate_target parameter, which was introduced in Oracle 11g, defines the total amount of memory available in Oracle for allocation to the PGA memory structure.

If the value of this parameter is set correctly, all work areas executed by the system since start-up are processed exclusively in the PGA memory, requiring no extra passes. In such a case, the PGA hit percent’s value is 100%, and Oracle does not need to allocate extra memory to the PGA. However, when this value is set too small, the hit percent’s value decreases, and Oracle may need to perform one or more extra memory allocations.

PGA Hit Percent

The PGA cache hit ratio (as a percentage).

When the value of this metric is 100%, it indicates that all work areas executed by the system processed the entire input data exclusively via the PGA memory, thereby making optimal use of this memory. Any lower value indicates that at least one work area required one or more extra passes over the input data.

PGA Overallocation Count

The number of extra PGA memory allocations that were carried out during the specified time range.

Over-allocating PGA memory can happen if the value of the dynamic initialization parameter, PGA_AGGREGATE_TARGET, which is set to all server processes, is too small to allow executing all work area workload (operations) exclusively in the PGA memory. Such a scenario requires Oracle to allocate extra PGA memory.

Ideally, the PGA cache hit ratio should be close to 100%, resulting in an extremely small number (close to zero) of PGA overallocations. High values of the PGA Overallocation Count metric indicate the need to increase the value of PGA_AGGREGATE_TARGET.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating