Sort_area_size useful if using dedicated server connection?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Sort_area_size useful if using dedicated server connection?

  1. #1
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59

    Sort_area_size useful if using dedicated server connection?

    Hi,

    I have installed Oracle 9.2.0.1.0 as dedicated server. I notice the PGA usage is about 50MB 50 150MB. Now, I'm wondering whether sort_area_size is used or PGA is used instead? Is the sort_area_retained size useful in a dedicated server environment? The current size is 0. Sort_area_size is 512K. Tks.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: Sort_area_size useful if using dedicated server connection?

    Originally posted by richyip
    Now, I'm wondering whether sort_area_size is used or PGA is used instead?
    What do you mean by the above ?

  3. #3
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59
    I mean to ask:

    Does Oracle 9.2.0.1 use sort_area_size or PGA for sorting operations? If PGA is used, then is the sort_area_size useful in performance tuning?

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59
    But then does the sort_area_retained size is used in 9iR2? It is useful in Oracle 8i.

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