| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Client performance
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_at_yahoo.com]
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
Regards
Mindaugas Navickas
OCP 10g DBA
> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 21 2005 - 12:14:25 CDT
 |
 |