pga_aggregate_target question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: pga_aggregate_target question

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    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.
    Ron

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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
    Location
    Helsinki. Finland
    Posts
    3,938

    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