Oracle 9i (pga_aggregate_target) paremeter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle 9i (pga_aggregate_target) paremeter

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    Oracle 9i (pga_aggregate_target) paremeter

    If we set

    workarea_size_policy = AUTO
    and pga_aggregate_target = 500M

    Is it required to set sort_area_size..?

    or sort_are_size should be 0

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    No, you dont have to worry about *_area_size parameters once you set workarea_size_policy = AUTO and and pga_aggregate_target = somevalue.
    Agasimani
    OCP(10g/9i/8i/8)

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Oracle 9i (pga_aggregate_target) paremeter

    Originally posted by skdas
    If we set

    workarea_size_policy = AUTO
    and pga_aggregate_target = 500M

    Is it required to set sort_area_size..?

    or sort_are_size should be 0
    No, it not required. Oracle will automatically set it (to 64K).
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: Re: Oracle 9i (pga_aggregate_target) paremeter

    Originally posted by julian
    No, it not required. Oracle will automatically set it (to 64K).
    No its totally ignored if WORKAREA_SIZE_POLICY is auto.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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