Question :   1. How can we know available PGA and temporary tablespace before we issue a huge operation? 2. Can we estimate PGA and temporary tablespace for a huge operation? 3. As we know, there is limitation for a user process. Can we set unlimited and how to do it?   We say:   PROPOSED SOLUTION(S) ==================== ANSWER ====== Note 223730.1 Title Automatic PGA Memory Management in 9i and 10g This Document briefly describes how Oracle 9i manage PGA work area and how to tune it and some of the common issues and some of the common misunderstood issues. Automatic PGA Memory Management Automatic PGA Memory Management ***Checked for relevance on 07-Jan-2011*** note:note: Automatic PGA Memory Management ------------------------------- Process Global Area,