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.
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.
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).
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité