Foglight for Oracle (Cartridge) 5.9.7.10


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

Top SQLs Text

Purpose

The Top SQLs Text collection retrieves the first n characters of the skoal statement text (the exact number of the characters is defined in the Top SQL Statements pane of the Collection Settings screen).

Collection Type

Oracle

Collection Sampling Settings

This collection retrieves SQL text only for new hash values.

Metric Descriptions


Metric	Description
Hash Value	The SQL statement’s hash value.
Is Full Text	A boolean value that indicates whether the first n characters are a full or partial SQL text for the current cursor.
SQL Text	First n characters of the SQL text for the current cursor.

Total Archive Storage

Purpose

The Total Archive Storage collection collects disk space data for critical archive destinations.

Collection Type

Oracle

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Archive Destination Free Space	The free space size (in megabytes) in the file system where the most critical archive destination resides.
Archive Destination Size	The total size (in megabytes) of the file system where the most critical archive destination resides.
Critical Archive Time To Failure	The number of hours remaining until the archive destination with the shortest time to failure is filled.
Destination	The destination ID of the most critical archive destination.

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.7.10 - User Guide

Top SQLs

Top SQLs Full Text

Top SQLs Text

Total Archive Storage