Don't rush to add additional tempfile or increase the size of existing ones if you are getting this.
If you are happy with your tempfile sizes (I usually allocate 10 to 20G to them), try increasing pga_aggregate_target. If this is not enouph, retrieve the sql from either v$sql or v$sqlarea (or better yet from the Grid Control) & see if execution plan is good. If not, tune it, otherwise recreate statistics on the tables involved. If you'd use cascade=true parameter in dbms_stats.gather_table_stats, indexes will be analyzed as well.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment