Foglight for Oracle (Cartridge) 5.9.3.10


Metric	Description
Action	The currently executing action name set by DBMS_APPLICATION_INFO.SET_MODULE
BG CPU Time	The amount of CPU time used by a session from the time a user call starts until it ends
BG Time	The amount of time used by a session from the time a user call starts until it ends
Blocking Session Status	The status of the blocking session; indicates whether the session is currently executing SQL statements (ACTIVE) or not (INACTIVE).
Client Info	The client information; contains the information set by DBMS_APPLICATION_INFO.SET_CLIENT_INFO
Client Machine Name	The name of the computer where the Client is running
Client PID	The operating system process ID for the Client program
Consistent Changes	The number of times a user process has applied rollback entries to carry out a consistent read on the block
Consistent Gets	The number of times a consistent read was requested for a block by this session
Current SQL	The last SQL statement executed by the user
DB Block Changes	The total number of changes that took part in an Update or Delete operation made to blocks by this session
DB Block Gets	The number of times a current block was requested by this session
DB CPU Time	Time spent waiting for the CPU to process SQL statements and other types of calls made to Oracle
DB Time	The amount of time used by the database for this session
Event	The name of the event that resulted in the wait event
Failed Over	In a RAC environment, a user can connect to any one of the multiple instances in a cluster. If the connected instance fails, the session can be reconnected automatically to other available instance. This metric indicates whether the session is running in failover mode and failover has occurred (YES) or not (NO).
Failover Method	The failover method used for determining how failover occurs from the primary node to the backup node
Failover Type	Failover type settings: SESSION, SELECT, NONE
Fixed Table Sequence	This metric's value is incremented each time the session completes a call to the database. Lack of changes in this metric's value indicates that the selected session was idle during the selected time range.
Hard Parse Count	The number of hard parse requests performed by this session
Logical Reads	The number of logical reads performed by session since login. This value is the total summary of all requests for database blocks, irrespective of whether they were found in the database cache.
Logical Writes	The number of logical writes performed by the session since login.
Logon Time	The date and time when the user logged on to the database. The format is year/month/day and hours:minutes:seconds (on a 24 hour clock).
Module Name	The currently executing module name, set by DBMS_APPLICATION_INFO.SET_MODULE.
Oracle User Name	The Oracle database account of the started session
OS User Name	The operating system user used by the client
Parallel Status	The Parallel Query status; can have one of the following values: ENABLED — the session is in a Parallel Query enabled mode DISABLED — the Parallel Query enabled mode is not supported for the session FORCED — the session has been altered to force Parallel Query)
PDB	In multitenant architectures, the name of the pluggable database
Physical Reads	The number of data blocks read by Oracle, which are not present in the buffer cache or in the PGA, thereby requiring I/O read operations, that is: the total number of data blocks read from disk.
Physical Writes	The number of physical writes carried out by the session since logon
Redo Entries	The amount of redo entries issues by the session since logon
Resource Consumer Group Name	The name of the session's current resource consumer group
Schema Name	The name of the database schema
Seconds in Wait	The wait event’s length of time, in seconds, since logon
Serial Number	The session’s serial number. The combination of SID and serial number provides a unique identification of the session.
Server	The server’s type: DEDICATED, SHARED, PSEUDO. or NONE
Server PID	The operating system process ID for the Oracle shadow process.
Server Program Name	The server program name
Service Name	The service name of the session
Session Action	The currently executing action name, set by DBMS_APPLICATION_INFO.SET_MODULE.
Session Cursor Cache Hits	The number of session cursor cache hits.
Session ID	The session identification number.
Session PGA Memory	The amount of PGA memory allocated for the current session
Session SQL ID	The session identification number for the SQL statement
Session Status	The session status; indicates whether the session is currently executing SQL statements (ACTIVE) or not (INACTIVE)
Session Type	The session type (USER or BACKGROUND)
Session UGA Memory	The amount of UGA memory allocated to the current session
Sort Disk	The number of sort operations that require creation of temporary segments on disk to store the intermediate sort results. This occurs if the data being sorted cannot be fit into memory block specified by the SORT_AREA_SIZE parameter in the init.ora file.
Wait Class	The classification of wait events.

Top SQLs

Purpose

The Top SQLs collection retrieves top n SQL statements (namely: statements that experienced the longest time of CPU consumption or total wait events during the specified time range) and their details.

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	60
Online	300
Offline	900

Metric Descriptions


Metric	Description
Array Wastage	The gap (by a percentage) between the average number of rows per fetch that the array can hold, as defined in the arraysize parameter of the various fetch operations of the specified SQL query, and the number of rows actually retrieved. For example: if the average setting of the arraysize parameter was 5, and the average number of rows actually retrieved per operation was 10, the value indicated will be 50. Ideally, the value of this parameter is 0; any other value indicates the need for additional sql.net roundtrips per each SQL query execution.
Buffer Gets	Number of buffer gets for this child cursor
Child Number	Hash value of the parent statement in the library cache
CPU Time	CPU time used by this cursor for parsing, executing, and fetching
Direct Writes	Number of direct writes for this child cursor
Disk Reads	Number of disk reads for this child cursor
Elapsed Time	Elapsed time used by this cursor for parsing, executing, and fetching
Executions	Number of executions that took place on this object since it was brought into the library cache
Fetches	Number of fetches associated with the SQL statement
Fetches per Execution	The average number of fetches per a single execution associated with the SQL statement
First Load Time	The first time the object was loaded to the shared pool
Hash Value	Hash value of the parent statement in the library cache
Java Time	Java execution time
Loads	Number of times the object was either loaded or reloaded
Loads per Execution	The average number of loads per a single execution associated with the SQL statement
Other Buffer Gets	Total time spent waiting for buffer gets on all SQL statements other than the selected statement.
Other CPU Time	Total CPU time consumed for executing all SQL statements other than the selected statement.
Other Disk Reads	The total number of disk reads carried out by all SQL statements except the selected statement.
Other Executions	Number of executions that took place on this object since it was brought into the library cache.
Other Total Waits	Total time spent on wait events due to executing all SQL statements except the selected statement.
Parallel Executions	Total number of executions performed by Parallel execution servers.
Parse Calls	Number of parse calls for this child cursor.
PLSQL Time	PL/SQL execution time.
Rows Processed	Total number of rows the parsed SQL statement returns
Sorts	Number of sorts that were done for the child cursor
Sorts per Execution	The average number of sorts per a single execution associated with the SQL statement
Total Waits	The total time spent on wait events.

Top SQLs Full Text

Purpose

This collection retrieves the SQL statement’s full text.

Collection Type

Oracle

Collection Sampling Settings

The Top SQLs Full Text collection is an on-demand collection, which retrieves data only upon clicking View full text.

Metric Descriptions


Metric	Description
Hash Value	The SQL statement’s hash value
SQL Full Text	Full text for the SQL statement exposed as a Character Large OBjects (CLOB) column

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for Oracle (Cartridge) 5.9.3.10 - User Guide

Top Blocked Objects

Top Sessions

Top SQLs

Top SQLs Full Text