• Become a portal pro
• Download
• Print
• My Downloads ()

• Support
• Technical Documentation
• Foglight for Oracle (Cartridge) 5.9.2.1
• Foglight for Oracle (Cartridge) 5.9.2.1 - User Guide

Foglight for Oracle (Cartridge) 5.9.2.1 - User Guide

Table of Contents  

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)

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

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

• Viewing Topics 57 - 60 of 248

×

Activity within Instance/Cluster tab

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

•	Workload-related Metrics — displays a list of metrics for the pluggable database

•	Workload — displays the pluggable database’s workload compared with the workload of the entire instance or RAC

•	Selected metric — displays the activity of the metric selected in the Metric table, compared with the workload of the entire instance or RAC

Storage Drilldown

Storage Drilldown

The Storage drilldown comprises the panels described in the following topics:

•	Tablespaces and Datafiles Panel — for details, see Tablespaces and Datafiles Panel .

•	Redo Logs — for details, see Redo Logs Panel .

•	Fast Recovery Area — for details, see Fast Recovery Area Panel .

•	Archive Logs — for details, see Archive Logs Panel .

IMPORTANT: The layout of the panels mentioned above is common for both a RAC and database instance.

•	Invalid Objects — for details, see Invalid Objects Panel .

•	Database Backup — for details, see Database Backup Panel .

Tablespaces and Datafiles Panel

The Tablespaces and Datafiles panel comprises the sections described in the following topics:

•	Tablespaces page — displayed by default. When switching to other sections of this panel, accessible by clicking the link View all tablespaces on the upper right side of the screen. For details, see Tablespaces page .

•	Datafiles grid — accessed by clicking the link View all datafiles on the upper right side of the screen. For details, see Datafiles Grid .

•	Tablespace-Specific page — accessed by clicking the name of the requested tablespace on the Tablespaces Summary table. For details, see Tablespace-specific page .

•	Datafile-Specific page — accessed in either of the following methods:

•	Clicking the name of the requested datafile from the Tablespace Details > Datafiles pane, under the tablespace-specific page (see Tablespace Details Section ).

•	Clicking the name of the requested datafile from the Datafiles grid.

For details, see Datafile-specific Page .

Tablespaces page

The Tablespaces page displays the database individual tablespace information, sorted by either percent of space usage or size.

IMPORTANT: By default, all types of tablespaces are monitored. To exclude specific types of tablespaces from monitoring, see Tablespaces Summary Table .

The Tablespaces page contains the following components:

•	Top 10 Tablespaces chart — a representation of the sizes of the tablespaces that have the highest used value, displayed according to the selected sort method. For details, see Top 10 Tablespaces Chart .

•	Tablespaces Summary table — a full list of the tablespaces, with general parameters and individual alarms. For details, see Tablespaces Summary Table .

 

 

Top 10 Tablespaces Chart

The Top 10 Tablespaces bar chart displays the tablespaces that have the highest used value, sorted by:

•

Size

•	Percentage of space usage

 

Table 12. Top 10 Tablespaces Chart

Name	Description
Show top	Use the Show top options to select which metric the vertical axis displays for the top 10 tablespaces: • Size — size in megabytes. • % Space Usage — percent.
Percent (chart vertical axis)	The percentage of the database tablespace pages currently being utilized.
Megabytes (chart vertical axis)	The database tablespace utilized size in megabytes.
Tablespaces (chart horizontal axis)	The names of the top 10 most utilized tablespaces.
Tablespace bar	The bar chart representation of the utilized tablespaces. Click a specific tablespace representation to drill down further to the Tablespace-specific page. For details, see Tablespace-specific page .

Tablespaces Summary Table

The Tablespaces Summary table shows the status for all of the database tablespaces.

To view details on a specific tablespace, click the tablespace.

 

Table 13. Tablespaces Summary Table

Name	Description
PDB	In multitenant architectures, identifies the pluggable database that uses the tablespace shown in the Tablespace column.
Tablespace	The name of the tablespace. Click the tablespace name to drill down further to the Tablespace-specific page. For details, see Tablespace-specific page .
Total Size	The total amount of allocated space (in megabytes) in this tablespace.
% Space Usage	The percentage of used allocated space in this tablespace.
Contents	The type of tablespaces content: • PERMANENT • TEMPORARY • UNDO
Number of Datafiles	The number of datafiles in the selected tablespace. To view a list of all datafiles of which the tablespace consists, and possibly drill-down to a datafile-specific page, click the tablespace name to access the Tablespace Details > Datafiles pane.
Estimated Until Full	Estimated number of days until tablespace is full. If the tablespace used space did not grow during the selected period, this field shows the indication no growth.
Autoextensible Datafiles	The sum of the Autoextensible OS Datafiles and Autoextensible ASM Datafiles metrics.
Alarms	The number of warning, critical, and fatal alarms for this Oracle database tablespace. For further details, see DB Alarms .

Datafiles Grid

The Datafiles grid displays a list, sorted by usage, of all datafiles used by the database.

 

 

Table 14. Datafiles Grid

Name	Description
PDB	In multitenant architectures, identifies the pluggable database that uses the datafile shown in the File Name column.
File Name	The file name of the datafile, including the full directory path. Click the file name to drill down further to the Datafile-specific panel. For details, see Datafile-specific Page .
Tablespace	The name of the tablespace that contains the selected datafile.
Size	The current size of the datafile in megabytes.
Used	The current used megabytes associated to the datafile, as a percentage of datafile’s allocated size.
Autoextend	Indicates whether the datafile is auto-extensible.

Tablespace-specific page

The Tablespace-specific page charts used and free space, as well as the fragmentation level of the tablespace (to determine how much space can yet be utilized). The datafiles that make up the individual tablespace appear on the bottom pane of the dashboard.

This page comprises the following sections:

•	Tablespace Properties section — for details, see Tablespace Properties Section .

•	Tablespace Properties alarms — for details, see Tablespace Properties Alarms .

•	Tablespace Properties table — for details, see Tablespace Properties Table .

•	Space Utilization chart — for details, see Space Utilization chart .

•	Tablespace Details section — for details, see Tablespace Details Section .

•	Datafiles table — for details, see Datafiles Table .

•	All Metrics table — for details, see All Metrics Table .

•	Extent map — for details, see .

Tablespace Properties Section

The tablespace properties are provided using the following panes:

•	Tablespace properties alarms

•	Tablespace properties table

Tablespace Properties Alarms

 

Table 15. Tablespace Properties Alarms

Name	Description
Alarms	The number of warning, critical, and fatal alarms for the selected tablespace. For further details, see DB Alarms .

Tablespace Properties Table

 

Table 16. Tablespace Properties Alarms

Name	Description
Status	Indicates the current status of the tablespace — Online or Offline.
PDB	In multitenant architectures, shows the pluggable database that was listed beside the selected tablespace in the Tablespaces Summary table.
Extent Management	Indicates the method used for managing extents in this tablespace: • DICTIONARY — within the Oracle data dictionary • LOCAL — within the tablespace itself
Allocation Type	The type of extent allocation to be used for this tablespace. • USER — allocates extents as per the storage clause provided with the object or defaulted at tablespace level. • UNIFORM — allocates the uniform sizes for the extents. • SYSTEM — automatically allocates system-generated extent sizes.
Force Logging	Indicates if the tablespace is in Force Logging mode, which logs all changes to all objects in the tablespace, except changes to temporary segments. The possible values are Yes and No.
Logging	Indicates if a redo log is to be generated for the tablespace. The possible values are Logging and No.
Segment Space Management	Indicates how free and used segments are managed. • MANUAL — using free lists • AUTOMATIC — using bitmaps
Default Table Compression	Indicates the status of default table compression; either Enabled or Disabled.
Retention	Indicates if unexpired undo blocks are retained in the tablespace. • NOT APPLY — used for tablespaces other than the undo tablespace. • GUARANTEE — applies only to undo tablespaces. • NOGUARANTEE — applies only to undo tablespaces.
Big File	Indicates if the tablespace is a BIGFILE tablespace (Yes) or a small file tablespace (No). BIGFILE tablespaces are supported only for locally managed tablespaces with automatic segment-space management.
Block Size	The size of the memory block used by this tablespace in megabytes.
Encrypted	Indicates whether the tablespace data is encrypted (Yes) or not (No).

Space Utilization chart

 

Table 17. Space Utilization chart

Name	Description
Total	Total amount of available memory for this tablespace, plotted over time.
Used	Amount of available memory that is used for this tablespace, plotted over time.

Tablespace Details Section

The tablespace details are provided using the following panes:

•	Datafiles table

•	All Metrics table — for details, see All Metrics Table .

Datafiles Table

 

Table 18. Datafiles Table

Name	Description
Datafile name	The datafile name, including the full directory path. Click the datafile name to drill down further to the Datafile-specific panel. For details, see Datafile-specific Page .
Size	The current size of the datafile in megabytes.
Filesystem Free	Available space on the file system as a percentage of file system size, rounded up to one decimal. If the filesystem resides on an Automatic Storage Management (ASM) disk, retrieving this information requires having the ASM instance installed and configured.
Alarms	The number of warning, critical, and fatal alarms for this Oracle database tablespace.

All Metrics Table

This table provides the following information for tablespace metrics.

•	Metric — the metric name; can have one of the values listed in the table below.

•	Value — current value

 

Table 19. All Metrics Table

Metric Name	Description
Total	The total amount of space in the selected tablespace.
Free Space	The total amount of free space in the selected tablespace.
Used	The amount of space used in the selected tablespace.
Allocated Space Used Percentage	The percentage of used space for non auto-extensible files in the selected tablespace.
Free Space Percentage	The percentage of free space.
Minimum Fragment Size	The size of the smallest fragment in the selected tablespace.
Maximum Fragment Size	The size of the largest fragment in the selected tablespace.
Average Fragment Size	The average size of fragments in the selected tablespace.
Recycle Free (MB)	The total amount of space used by the recycle bin within the allocated free space of the tablespace.
Recycle Free (%)	The percentage of recycle bin space which occupies the allocated free space of the tablespace.
Estimated Until Full	Estimated number of days until tablespace is full. If the tablespace used space did not grow during the selected period, this field shows the indication no growth.
Autoextensible OS Datafiles	Number of autoextensible OS datafiles (DF).
Autoextensible ASM Datafiles	If storage is managed using Automatic Storage Management (ASM), and the ASM instance is installed and configured, displays the number of autoextensible ASM datafiles (DF).
Manual OS Datafiles	Number of manual OS datafiles (DF).
Manual ASM Datafiles	If storage is managed using Automatic Storage Management (ASM), and the ASM instance is installed and configured, displays the number of manual ASM datafiles (DF).

Datafile-specific Page

The individual Datafile properties panel displays general properties of the selected datafile, as well as a representation of the used and free space that make up the specific datafile.

The Oracle database datafile-specific panel comprises the sections listed below.

•	Datafile Properties

•	Space Usage — for details, see Space Usage .

•	Fragmentation — for details, see Fragmentation .

Datafile Properties

 

Name	Description
Alarms	The number of warning, critical, and fatal alarms for the selected datafile.

 

Table 20. Datafile Properties

Property Label	Property Description
Datafile	The name of the datafile, including the full directory path.
Tablespace	The name of the tablespace to which the datafile belongs.
PDB	In multitenant architectures, the name of the pluggable database.
Size	The size of the datafile in megabytes.
Used	The used size of the datafile in megabytes.
% Used	The percentage of the datafile used.
Status	Indicates whether the datafile is available: • AVAILABLE • INVALID
Autoextend	Indicates whether the datafile is auto-extensible.

Space Usage

Details are provided for:

•	File Space Usage

•	Filesystem Space Usage

NOTE: For datafiles managed by ASM, the filesystem space usage cylinder is available only if the ASM instance is installed and configured. For autoextensible datafiles, the file space usage cylinder is not available.

 

Table 21. Space Usage

Name	Description
Used (percent)	The percentage of the datafile being used.
Used (megabytes)	The number of megabytes being used.
Total (megabytes)	The total number of megabytes available.

Fragmentation

Use the Fragmentation section to view the file fragmentation status of used and free extents, using a fragmentation analysis triggered by clicking Analyze Fragmentation.

CAUTION: Fragmentation analysis is a resource-consuming operation. Carrying out this operation is strongly discouraged in production environment with heavy resource contention.

 

Table 22. Fragmentation

Name	Description
Fully Usable	The amount of memory that is not being used by a datafile and is viable; represented by the blue portion of the horizontal memory bar. This bar displays the file fragmentation snapshot of used and free extents.
Partly Usable	The amount of datafile memory that is partly usable; represented by the violet portion of the horizontal memory bar.
Unusable	The amount of tablespace memory that is unusable; represented by the pink portion of the horizontal memory bar.
Used	The amount of tablespace memory that is used; represented by the orange portion of the horizontal memory bar.

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

•  Previous
• Viewing Topics 57 - 60 of 248
• Next 

Search this document Search all documents

×

 Welcome to Quest Support

You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center