• Conviértase en un profesional en el portal de soporte
• Descargar
• Imprimir
• Mis descargas ()

• Soporte
• Documentación técnica
• Foglight for Oracle (Cartridge) 6.3.0
• Foglight for Oracle (Cartridge) 6.3.0 - User Guide

Foglight for Oracle (Cartridge) 6.3.0 - User Guide

Navegación de contenido  

Installing and Configuring Agents

Installation

Installing and Configuring Agents Upgrading to the Current Version Overview Running the Upgrade Wizard Migrating Agents

About Monitoring Extensions

Configuring the On Demand Port on the Agent Manager Concentrator

Installing and Monitoring a Single Oracle Instance Discovering Multiple Instances to Monitor

Loading a TNS file

Adding CRS Agents for Monitoring Clusterware

Adding Agents for Monitoring Exadata Environments

Modifying the Exadata Monitoring Settings

Adding Data Guard Environment Adding ASM Instances Configuring Multiple Instances for Monitoring using Silent Installation

Contents of the input CSV file for Oracle instances Configuring Multiple Instances for ASM Contents of the input CSV file for ASM instances

Using Foglight for Oracle

Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor

Filtering the Display by Severity Creating User-defined Database Groups Components Shared by All Foglight for Oracle Screens Using the Currently Selected Database Group Table Viewing Data about the Exadata Cells

Foglight for Oracle Overview Dashboard

Breakdown and Baseline Chart Formats Home Page Toolbar

Overview view Advisories view SQL Performance Investigator (SQL PI)

Performance Tree Viewing Historical Metrics Blocking History Activity Highlights Viewing Change Tracking Viewing Execution Plans Comparing Performance

Oracle Activity Drilldown

Viewing the Foglight for Oracle Real-time Summary Page Reviewing Instance Usability Reviewing Cluster Usability Reviewing Locks Activity at the Cluster Level Reviewing Locks Activity at the Instance Level Locks Historical Tree Viewing Detailed Sessions Data Viewing Datafiles I/O Activity at the Cluster Level Viewing Datafiles I/O Activity at the Instance Level Viewing User-Defined Collections

Pluggable Databases Drilldown

Pluggable Databases List table Overview tab Activity within Instance/Cluster tab

Storage Drilldown

Tablespaces and Datafiles Panel Redo Logs Panel Members of Group [n] Table Fast Recovery Area Panel Archive Logs Panel Archive Log Destinations Table Invalid Objects Panel Database Backup Panel

Reviewing Configuration Settings

Reviewing SGA Settings at the RAC Level Reviewing SGA Settings at the Instance Level Reviewing the Initialization Parameters

Reviewing the Alert Log

Reviewing the Alert Log

Reviewing Monitored Data Guard Environments

Reviewing Summary Information Reviewing Performance Information Reviewing Log Shipping Status Information

Reviewing ASM Instances

Reviewing Summary Information Reviewing Parameter Information Reviewing Alert Log Information

Reviewing Exadata-related Information

Displaying Exadata-related Summarized Data Reviewing the Exadata Performance Reviewing the InfiniBand Topology

Administering Foglight for Oracle

Opening the Databases Administration Dashboard Reviewing the Administration Settings Defining Connection Details

Defining the Connection Settings for the Monitored Oracle Instances Validating Connectivity and Starting to Monitor the Instances Defining the Connection Settings for the Monitored ASM Instances

Defining Data Collection and Storage Options Customizing Alarms for Foglight for Oracle Rules

Introducing the Alarms View Viewing Alarm Sensitivity Levels for Unassigned Agents Modifying Alarm Templates Configuring Email Notifications Cloning Agent Settings Reviewing Rule Definitions

Defining Retention Policies Defining the Collection Settings

Locks Top SQL Statements Tablespace Filtering Invalid Objects Filtering

Configuring the Alert Log Filtering Panel Display Configuring the List of Listeners per Instance Configuring User-defined Collections Configuring the On-demand Data Port Changing the Monitoring Mode of the RAC One Node Agents Administering SQL Performance Investigator

Reporting

Generating Reports for a Foglight for Oracle RAC or Instance Studying the Various Reports

Reference

Overview of Collections

Alert Log Archive Destination Miscellaneous Archive Logs Storage ASM Diskgroups ASM Diskgroups Balance ASM Disks ASM Instance Total ASM Operations Backup Config Backup Jobs Backup Type Status Cluster Latency Cluster Misses Datafile Fragmentation Datafile IO Activity Datafiles Storage Dataguard Destination Status Dataguard Redo Apply Dataguard Status Dump File Event Wait Exadata Cell Flashcache Exadata Cell General Exadata Cell InfiniBand Exadata Cell InfiniBand Ports Exadata Cell InfiniBand Switches Exadata Cell Statistics Exadata Cell General Filesystem Disk Flashback Area History Locks Tree Instance History Locks Tree RAC Host Properties Initialization Parameters Instance General Invalid Objects Invalid Objects List IO Activity Jobs Queue Latches Activity Locks Activity Locks Breakdown Locks Instance Locks Tree Locks Tree RAC Long Running Session OS and Instance Statistics OS File System IO Summary OS General Network Summary Parallel PGA Statistics Pluggable Databases Information Pluggable Databases State Redo Archive Performance Redo Instances Miscellaneous Redo Logs Member Storage Redo Log Storage Sessions Summary Servers Tablespaces Free Space Fragmentation Tablespaces Storage Top Blocked Objects Top Sessions Top SQLs Top SQLs Full Text Top SQLs Text Total Archive Storage Total Database Storage Total Instance Waits Undo Activity Total Summary Usability

Glossary

Alarm Authentication Buffer Wait Calibration Cartridge Cluster Wait CPU Usage CPU Wait Cursors DataGuard DataFlow Deadlock Disk Transfer Time Disk Utilization DiskPerf Dispatcher Drilldown External Procedures Foglight Agent Manager Foglight Management Server Host Name Host Process I/O Wait Kernel Memory Kernel Mode Kill LRU LSN Latch Wait Licensing Lock Wait Logical Reads Metric Network Wait OLTP Other Wait Paging Panel Per-Seat Licensing Per Server Licensing Physical Reads PID Privileged Mode Process Random I/O Recompile Recursive Calls Referential Integrity Relational Data Engine SQL*Net Scattered Read Schema Locks Sequential Read Severity Spinner SQL *net Threshold Transaction Unused Space User Mode

• Visualización de Temas 61 - 64 de 250

×

Redo Logs Panel

Redo Logs Panel

The Redo Logs panel, which displays details regarding all redo logs, either for the Oracle instance or for all nodes of an Oracle RAC, comprises the following sections:

•	Redo Logs Storage Groups table — click on a group list row to see the list of members in that group.

•	Members of Group [n] table — for details, see Members of Group [n] Table .

Redo Logs Storage Groups Table

The redo log records all changes made in datafiles.

 

Table 24. Redo Logs Storage Groups Table

Name	Description
Group #	The redo log group number.
Group Status	The status of the redo logs indicates which logs are in use and whether there are any odd status codes, such as stale log indications or indications of corrupt redo logs. The log files can have one of the following status values: • USED — indicates either that a log had just been added (never used), or that a RESETLOGS command has been issued. • CURRENT — indicates a valid log that is in use. • ACTIVE — indicates a valid log file that is not currently in use. • CLEARING — indicates a log is being re-created as an empty log due to database administrator action. • CLEARING CURRENT — indicates that a current log is being cleared of a closed thread. If a log stays in this status, it could indicate there is some failure in the log switch. • INACTIVE — indicates that the log is no longer needed for instance recovery but may be needed for media recovery.
Archived	Indicates if the redo logs are being archived.
Sequence #	The number assigned by Oracle to each redo log file whenever a log switch occurs and LGWR begins writing to the log file. When redo log files are archived, the archived log retains its log sequence number.
Size	The size of the log in megabytes.
First Change #	A system-allocated number (SCN), which identifies the first time a change was recorded in this log.
First Time	The time when the first SCN in the log was recorded.
Alarms	The number of warning, critical, and fatal alarms for the selected Oracle database tablespace.

Members of Group [n] Table

 

Table 25. Members of Group [n] Table

Name	Description
Member Name	The redo log group member name.
Member Status	The redo log group member status. This status can have one of the following values • INVALID — indicates that Oracle cannot access the redo log file. • STALE — indicates a log file that is either corrupt or incomplete. If the log file’s group becomes the active group, the file becomes valid again. • DELETED — indicates an online redo log file that has been dropped from the database and deleted from the disk. • IN USE — identifies the currently active redo log file.

Fast Recovery Area Panel

The Fast Recovery Area panel, which displays details regarding the allocated space for fast recovery area and its usage in the Oracle database, comprises the following sections:

NOTE: If the fast recovery area is not configured in the database, the Fast Recover Area panel is blank, displaying only the message: “The Fast Recovery Area is not configured in the database.”

•	Current Usage details — shows details about the current usage of allocated space for fast recovery area.

•	Usage Breakdown pie chart — provides a representation of the current size of each component that occupies within the database's fast recovery area.

NOTE: The pie chart displays only components which size is greater than zero.

•	Usage Space Distribution chart — shows the distribution among reclaimable and non-reclaimable parts of fast recovery area's used space.

•	Usage Details table — shows more detailed information about the space usage of the fast recovery area's components.

NOTE: This table displays only components which size is greater than zero.

•	Flashback Database details — shows details about the oldest point in time to which is possible to flashback the database.

•	Flashback Data Size chart — shows the comparison among estimated size and current size of flashback data.

Archive Logs Panel

Archive Logs Panel

The Oracle database archive logs panel comprises the following sections:

•	Archive Log Destinations table

•	Archive Writes chart — displays the amount (in megabytes) of disk space being used per second for the archive log.

NOTE: If the instance is configured not to archive, the Archive Logs panel is blank, displaying only the message “The database is not archiving”.

•  Anterior
• Visualización de Temas 61 - 64 de 250
• Siguiente 

Buscar este documento Buscar todos los documentos

×

 Bienvenido al portal de soporte

Puede encontrar ayuda de soporte en línea para el *producto* Quest en un sitio de soporte afiliado. Haga clic en Continuar para ser dirigido al contenido de soporte y a la asistencia adecuados para el *producto*.

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación

© ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center