Chatta subito con l'assistenza
Chat con il supporto

Foglight for Oracle (Cartridge) 5.9.7.20 - User Guide

Installing and Configuring Agents Using Foglight for Oracle
Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor Foglight for Oracle Overview Dashboard Overview view Advisories view SQL Performance Investigator (SQL PI) Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert Log Reviewing Monitored Data Guard Environments Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Top SQLs

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.

Oracle

Realtime Collection

60

Online

300

Offline

900

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

This collection retrieves the SQL statement’s full text.

Oracle

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

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

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

Oracle

This collection retrieves SQL text only for new hash values.

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

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

Oracle

Realtime Collection

300

Online

900

Offline

3600

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.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione