According to the Help file, Row Source Ratio (% from Scans) is calculated as follows:
Table Scan Rows Gotten
---------------------------------------------
Table Scan Rows Gotten + Table Fetch by RowID
This metric reports the percentage of total rows retrieved that came from full-table scans. Ideally, this percentage should be small which means it should not be doing too many full-table scans.
We are seeing high Row Source Ratio even when most I/O waits are single block reads which means that full table scan did not occur that often.
Product defect.
WORKAROUND
Replace Rules.xml file in the following paths:
1. C:\Program Files\Quest Software\Performance Analysis\Oracle\Services\Default\Rules.xml
2. On each service: c:\Documents and Settings\<User Name>\Local Settings\Application Data\Quest Software\Performance Analysis 6.0\Services\<Service Name>\
STATUS
Waiting for a fix in a future release of Performance Analysis for Oracle.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center