Foglight for Oracle (Cartridge) 6.3.0

The following image displays the main elements of the Foglight for Oracle real-time summary page. The table that follows the image identifies each element, and provides a link to display more information, corresponding to the logical dataflow within Foglight for Oracle Instance Homepage.

The main groups (panes) of gathered icons and gauges, which represent the main activity areas in the Oracle connection process, are as follows:

•

Instance identification — used for identifying the instance, its type, and its properties. See Identifying the Instance .

•

Components representing instance data flow — the main activity area in the Foglight for Oracle Instance Homepage includes several panes and flows that represent the data flow in the Oracle operation. The dataflow is represented in a top-down design, that is, from the session to the physical disk storage.

Flow	Description
Executions	The rate per second of calls (both user and recursive) that executed SQL statements.
Received packets	The rate at which network packets are being received by Oracle from Client applications. When this icon’s color is yellow, clicking it displays text that describes the deviations that triggered this display, along with a representation of the rate at which Oracle is encountering network packet errors.
Sent packets	The rate at which network packets are being sent from Oracle to Client applications. When this icon’s color is yellow, clicking it displays text that describes the deviations that triggered this display, along with a representation of the rate at which Oracle is encountering network packet errors.

Parameter	Description
Recent Executions	The number of statements executed during the most recent sample.
Blocked Processes	The average number of blocked processes that were collected during the specified time range. Blocked processes are processes that are waiting for another process to release a resource that the process is currently locking. Such processes can sometimes result in bottlenecks. The Blocked Process indicator changes its color when one or more processes become blocked.
Parses	Total number of parse calls. This figure is the total of both hard parse calls (calls that require loading the SQL source code into RAM for parsing) and soft parse calls.
Concurrent Transactions	The number of currently running transactions.

Section	Metric	Description
SGA	Total (MB)	The actual size currently allocated to the System Global Area (SGA) memory.
	Buffer Cache (MB)	The amount of memory currently allocated to the buffer cache. The buffer cache, which is used for caching frequently accessed data blocks, is normally the largest memory cache used by Oracle.
	Shared Pool (MB)	The size of the shared pool. The shared pool caches SQL statements, PL/SQL programs, object definitions, and session memory for MTS sessions. Performance can improve when the shared pool is sized properly, thereby avoiding re-parsing and reloading.
	Buffer Cache Hit (%)	The percentage of block requests, which found the block in the buffer cache, out of the entire block requests (including requests that required disk reads).
Library Cache Hit (%)		The effectiveness of the library cache, computed by comparing the number of queries submitted to Oracle server for execution, which found the parsed execution plan in the library cache (soft parsing), with the entire number of queries submitted during the specified time range (including queries that required the parsing of a new statement, also known as “hard parsing”).
PGA	Total (MB)	The actual size currently allocated to the Program Global Area (PGA) memory.
PGA	PGA Hit (%)	The percentage PGA cache hit ratio. When the value of this metric is 100%, it indicates that all work areas executed by the system processed the entire input data using exclusively 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.

Name	Description
Lock Name	The name of the lock.
Gets	The total number of enqueue requests or enqueue conversions for this type of enqueue.
Gets Rate	The rate of lock gets.
Gets (percent)	The percentage of lock gets for this type of lock within the total number of locks.
Enqueue Waits	The total number of times an enqueue request or conversion resulted in a wait event.
Waits Rate	The number of wait events per second.
Wait (percent)	The percentage of wait events for this type of lock within the total number of locks.
Lock Wait	The total amount of time spent waiting for the enqueue or enqueue conversion.
Average Lock Duration	The average length of time for a lock, in milliseconds.
Lock Efficiency	The percentage of lock requests that did not escalate to a blocking lock.
Alarms	The number of warning, critical, and fatal alarms that were invoked for this Oracle database instance. Holding the cursor over each alarm type displays a dwell that shows the most recent alarms invoked for this database instance, sorted by severity. Click each alarm type to drill down and manage the alarms. See the Foglight Online Help, Monitoring System-Wide Alarms for details on the alarm information.

Name	Description
SID	The session identifier
Serial	The session’s serial number. The combination of SID and serial number provides a unique identification of the session.
Process	The process number
DB User	The database user name
OS	The operating system name
Program	The name of the program that is processing the SQL statements
Client	The Client computer identifier
Host	The host computer identifier
Current SQL	The SQL text of the SQL statement that is currently being processed in this session

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

Foglight for Oracle (Cartridge) 6.3.0 - User Guide

Viewing the Foglight for Oracle Real-time Summary Page

Reviewing Instance Usability

Reviewing Cluster Usability

Reviewing Locks Activity at the Cluster Level