지금 지원 담당자와 채팅

라이브 도움말 보기
등록 완료

로그인

가격 산정 요청

영업 담당자에게 문의

Foglight for Oracle (Cartridge) 5.7.5.50 - User Guide

콘텐츠 탐색

Installing and Configuring Agents

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)

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 Setting and Modifying Alarm Sensitivity Levels Modifying Alarm Settings 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

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

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

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

Viewing User-Defined Collections

Use the User-defined Collections panel to see customized collections, which were created using the User-defined Collections view in the Databases Administration dashboard, either during the most recent sample (Last Sample) or plotted over the specified time range (Selected Period).


	IMPORTANT: The User-defined Collections panel is used only for displaying the user-defined collections; any creation or management operation of these collections is carried out using the User-defined Collections view in the Databases Administration dashboard, at the whole cluster or single instance levels only (not from within a RAC node). For details, see Configuring User-defined Collections .

This panel comprises the following sections:

•

The Collections column, on the left of the panel — displays all of the names of the existing user-defined collections.

•

SQL text grid — displays the text of the user-defined SQL query.

By default, this grid displays the query’s short text. To display the query’s full text, click View full text (a toggle).

•

The collection details table — displays all of the fields contained in the query.

Each of the table’s columns shows the field’s display name, while each row represents the records taken at each sample.

Pluggable Databases Drilldown

The Pluggable Databases drilldown contains the Pluggable Databases pane, which displays a table of all pluggable databases (PDB), as well as the container databases (CDB), which are monitored in the instance. For details, see Pluggable Databases List table .

Selecting a row in the table displays the details of the selected container in the following panes:

•

Overview — shows general details about the selected database, such as name, availability, and workload. For details, see Overview tab .

•

Activity within Instance/RAC — shows the activity of the instance as part of the overall instance or RAC activity. For details, see Activity within Instance/Cluster tab .

Pluggable Databases List table

The Pluggable Databases List table includes the following columns:

•

Sev — indicates the pluggable database maximum severity level

•

Name — the pluggable database name

•

ID — the ID number of the pluggable database

•

Up Since — displays the date and time when the pluggable database was last started

•

Workload (% of Instance) — the percentage the pluggable database’s workload constitutes within the entire instance/RAC

•

CPU (% of Instance) — the percentage the pluggable database’s CPU consumption constitutes within the entire instance/RAC

•

I/O (% of Instance) — the percentage the pluggable database’s I/O activity constitutes within the entire instance/RAC

•

Shares — the portion of the system's CPU resources that is allocated to the selected pluggable database

Overview tab

The Overview tab contains the following sections, which display general information about the pluggable database selected in the Pluggable Databases List table:

•

Name — the name of the pluggable database

•

Open mode — the pluggable database’s state; the possible values are: mount, read-write, read-only, and migrate

•

Created on — the day on which the pluggable database was created

•

Cloned from — if this pluggable database was cloned, the name of the originating pluggable database

•

Availability — displays the selected pluggable database’s availability within the selected time range

•

Storage — displays the pluggable database's storage compared with the storage of the entire instance or RAC

•

Workload — displays the pluggable database’s workload during the specified time range

•

Workload Across Cluster — if the selected pluggable database is part of a RAC, displays the balance between the various pluggable databases within the RAC

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택

© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center