Just stumbled upon a great article related to Oracle problem troubleshooting on Exadata:
Issue is related to "TABLE ACCESS STORAGE FULL" in exec plan (smart scans) and tables with the very large number of columns, which is typical for any serious production environment.
See below:
http://tech.e2sn.com/oracle/exadata/performance-troubleshooting/exadata-smart-scan-performance
No comments:
Post a Comment