RE: Client performance
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 Oct 2005 13:12:14 -0400
To All,
I asked this question some time ago & got a handful of replies
all of which were useful. The issue has now been resolved & I thought
I'd update the group on what fixed this since it was a real oddball.
After sending the trace files to Oracle they did their analysis & stated
that they could not find anything wrong. They then suggested that we
try the query again, but after starting it minimize the application
window & then restore it. If the result set was done we should
investigate the video drivers. Odd as that may seem, that was the
problem. The NT folks have replaced the video card & Microsoft supplied
driver & things run just dandy now.
-----Original Message-----
From: Mindaugas Navickas [mailto:mnavickas@xxxxxxxxx]
Sent: Thursday, October 06, 2005 2:43 PM
To: Goulet, Dick
Subject: Re: Client performance
Hi Dick,
Probably the best would be to enable net8 tracing on client site adding
following lines into sqlnet.ora
TRACE_LEVEL_CLIENT = 16
TRACE_FILE_CLIENT = CLI
TRACE_DIRECTORY_CLIENT = c:\temp
TRACE_UNIQUE_CLIENT = ON
TRACE_TIMESTAMP_CLIENT = ON
TNSPING.TRACE_LEVEL = 16
try first only tnsping to see what it produces.
Regards
Mindaugas Navickas
OCP 10g DBA
--- "Goulet, Dick" <DGoulet@xxxxxxxx> wrote:
> Folks,
>
> I've a question that I hope someone will be able to answer.
> First the configuration:
>
> Server Red Hat EE 4 with Oracle 9.2.0.6 installed and GB network
> card.
> Client Windows 2003 Enterprise vanilla with security patches and
> Oracle 9.2.0.1 client software, also a GB network card. It's
primarily
> a web server.
>
> Here's the problem. If I run a tnsping from this client to the
database
> server it returns the appropriate result in 60 to 110 msec. A
straight
> ping returns in < 1msec. Conversely if I run the same tests between
the
> database server and my laptop, which is very similar, except for
> physical size and network card (100 baseT), the tnsping returns in 0
> msec & likewise < 1 msec for the ping. Running sql*plus to the
database
> server from the client returns data just fine, but it's not a smooth
> flow. You can actually see the data being painted onto the screen.
The
> application running thereon is likewise having a problem. A specific
> query run thereon takes 2 minutes, but elsewhere it takes < 2 seconds.
> We've beat this thing severely about the head & shoulders and it
> definitely is an Oracle issue with this one client. I'm going to
> install the 9.2.0.6 patch set this afternoon, but am wondering if
anyone
> else has run into similar issues.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified DBA
> --
> //www.freelists.org/webpage/oracle-l
>
__________________________________________________________
Find your next car at http://autos.yahoo.ca
--
//www.freelists.org/webpage/oracle-l
Other related posts:
