Direct Path Reads

We have a number of 11.1.0.7.0 instances where ADDM reports the Top Timed Foreground event as direct path reads at 80%.

V$system_event also indicates this.

I believe the main utilisation of this is a Full Table Scan of the sys.aud$ table (which has no index) and approx. 5 million rows.

We have AMM enabled and 3GB RAM allocated to the instance.

I am considering increasing the amount of memory available to the instance but when I monitor the amount of PGA used, there does not appear to be much of an issue.

V$PGA_TARGET_ADVICE indicates that there would be no discernible benefit from any changes.