RE: Windows desktop sqlplus client faster than solaris sqlplus client
- From: "Lange, Kevin G" <kevin.lange@xxxxxxxxxx>
- To: <suresh.gm@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 May 2011 17:05:00 -0500
What comes to my mind is the setup of TNS on the server.
Are you forcing it to go out and route back in by the nature of how the
configuration is set up ?
In our case, each TNS entry on the server has an IPC connection setup so
that calls to the database from the database server never leave the
local network setup.
Maybe you might want to start by looking there.
Kevin
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of P Suresh
Sent: Thursday, May 12, 2011 4:56 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Windows desktop sqlplus client faster than solaris sqlplus
client
Hi Gurus,
One particular sql runs in less than a sec when run from sqlplus client
on desktop whereas it takes 85 seconds for it to complete when run
directly on the solaris 10 box where they have this 11g database
installed. Since it is the same sql, tuning the sql can be ruled out I
think. The execution plans are the same and the cost and cardinality are
identical.
In the 10046 traces, I see it has taken 80 seconds for parsing and fetch
for the solaris client but just 2 seconds for the deskptop sqlplus
client; I was unable to read which step consumed more time.
And it takes another 131 seconds until completion for the bad one
whereas the good one completes in another 25 seconds.
One difference I see is in the service name SERVICE NAME:(SYS$USERS) for
desktop client and SERVICE NAME:(olisdev.leg.state.or.us) for solaris
client.
The only difference in 10046 traces is here:
Solaris sqlplus client
WAIT #2: nam='SQL*Net message from client' ela= 140591934 driver
id=1413697536 #bytes=1 p3=0 obj#=-1 tim=6200280507074 CLOSE
#2:c=0,e=749,dep=0,type=0,tim=6200280508169
Windows desktop sqlplus client
WAIT #2: nam='SQL*Net message from client' ela= 221491 driver
id=1413697536 #bytes=1 p3=0 obj#=-1 tim=6199138319534 CLOSE
#2:c=0,e=95,dep=0,type=0,tim=6199138320012
Can someone please help how to deteremine why the same sql takes more
time in solaris sqlplus client? Please let me know if you need to see
the complete 10046 traces. Will network/listener/solaris dtraces help?
Thanks a lot,
Suresh
--
//www.freelists.org/webpage/oracle-l
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
