RE: Performance with SCAN listener in 11g RAC
Date: Thu, 2 May 2013 09:21:28 -0500
Message-ID: <3DC440E2338A24439D527C2E64E1ECBCA85610_at_deeds.pti-nps.com>
Does the timing of your test include establishing the connection, or are your connections already established?
If establishing a connection through SCAN takes any significant amount of time more than a direct connection to the instance, then I'd take a hard look at CPU utilization first.
If your connections are already established and running your query varies from one run to the next, I'd set autotrace on and look at physical vs logical IO between the 2 sessions.
Thanks,
T. J.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lu Jiang
Sent: Thursday, May 02, 2013 9:11 AM
To: list
Subject: Performance with SCAN listener in 11g RAC
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-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 02 2013 - 16:21:28 CEST