DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle 9i (pga_aggregate_target) paremeter

  1. 01-07-2003, 07:13 PM #1
    skdas
    skdas is offline Member
    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
    Reply With Quote Reply With Quote
  2. 01-08-2003, 12:14 AM #2
    agasimani
    agasimani is offline Senior Member
    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)
    Reply With Quote Reply With Quote
  3. 01-08-2003, 03:35 AM #3
    julian
    julian is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  4. 04-24-2003, 06:30 AM #4
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width