Windows desktop sqlplus client faster than solaris sqlplus client
- From: P Suresh <suresh.gm@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 12 May 2011 14:56:23 -0700
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
Other related posts:
