Performance with SCAN listener in 11g RAC
From: Lu Jiang <lu.jiang69_at_yahoo.com>
Date: Thu, 2 May 2013 07:10:41 -0700 (PDT)
Message-ID: <1367503841.16099.YahooMailNeo_at_web120006.mail.ne1.yahoo.com>
Hi DBA gurus,
I am do a performance test. Find that running same query using tns connection string with SCAN host name is 5 seconds slow than using tns connection string points to a specific host name (17seconds VS. 12 seconds). Is this normal? Is there are any special requirement to run gather schema stats tasks in a RAC environment? Could anyone shed light on these?
Thanks,
Lu
Date: Thu, 2 May 2013 07:10:41 -0700 (PDT)
Message-ID: <1367503841.16099.YahooMailNeo_at_web120006.mail.ne1.yahoo.com>
Hi DBA gurus,
I am do a performance test. Find that running same query using tns connection string with SCAN host name is 5 seconds slow than using tns connection string points to a specific host name (17seconds VS. 12 seconds). Is this normal? Is there are any special requirement to run gather schema stats tasks in a RAC environment? Could anyone shed light on these?
Thanks,
Lu
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 02 2013 - 16:10:41 CEST