RE: Performance with SCAN listener in 11g RAC
- From: "TJ Kiernan" <tkiernan@xxxxxxxxxxx>
- To: <lu.jiang69@xxxxxxxxx>, "list" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 May 2013 09:21:28 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: