DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002

    pga_aggregate_target question

    Dear All, Oracle9i on Sun 5.8

    I am planning to use pga_aggregate_target. But I have a question here. Suppose I set it to 50Mb, I have one server process which is using 40Mb for sorting. Then another server process starts and needs 20M for sort. Since the area is only 50M. What will happen to the database system? Any idea?

    Any help is appreciated.

  2. #2
    Join Date
    Feb 2000
    The sorts will be done in TEMP tablespace.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Jun 2001
    Helsinki. Finland

    Re: pga_aggregate_target question

    And remember also that pga_aggregate_target sets the maximum space that can be used from the RAM for sorting, etc. This (say 50M) is not allocated at instance startup. And 50M is a very small figure. I have noticed that about half a giga is usally quite optimal.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.