Re: INSERT /*+ append */ hint
From: z1hou1 <z1hou1_at_gmail.com>
Date: Mon, 10 May 2010 19:34:18 -0700 (PDT)
Message-ID: <ea0ac728-b577-4ac7-98e9-9703cc0c304f_at_e35g2000yqm.googlegroups.com>
Thank you vsevolod for explaining the correlation between parallel servers and number of sessions. The issue was simply a badly configured prod environment. We unearthed other issues, such as a ridiculously low pga_aggregate_target (64M) and workarea_size_policy set to 64M!. But thank you again.
Date: Mon, 10 May 2010 19:34:18 -0700 (PDT)
Message-ID: <ea0ac728-b577-4ac7-98e9-9703cc0c304f_at_e35g2000yqm.googlegroups.com>
Thank you vsevolod for explaining the correlation between parallel servers and number of sessions. The issue was simply a badly configured prod environment. We unearthed other issues, such as a ridiculously low pga_aggregate_target (64M) and workarea_size_policy set to 64M!. But thank you again.
z1hou1 Received on Mon May 10 2010 - 21:34:18 CDT