Oracle-L: RE: Help !!! : Identical servers with V 7.3.4.0 on NT4, Applicati

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 24 Apr 2003 07:56:40 -0800
Message-ID: <F001.005886FE.20030424075640@fatcity.com>

Arif

To diagnose a complex problem it is critical to isolate the difference to specific components. To me, the logical starting point is to see whether the difference is inside Oracle or outside (with the computing platform). Have you done an EXPLAIN PLAN on the query on both systems? This should help you see if Oracle is even taking the same execution path on both systems. If you don't know the query being run, you can pull it from V$SQL. If the screen is running many queries, you might just create your own test query to run on both systems. If EXPLAIN PLAN doesn't answer the question, the next step is to turn on tracing and use tkprof.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, April 24, 2003 9:37 AM
To: Multiple recipients of list ORACLE-L Applicati

A little more information based on the response I received.

I tested the performance on both the servers when there was no one other than me connected to the servers through a power builder application. Both the servers are connected to the same network and hence any network load (I assume) would have the same effect on both.

I have performed the test on both the servers several times with no one on before coming to the conclusion that the stand by returns data on screen in 18 seconds while the production returns data on the screen in 90 seconds

Are there any other files other than the data, log and ctl that may affect the performance in any way??? By the way, I am running Oracle in NOARCHIVELOG mode and I have recently built statistics (using Analyze Table) which resulted in bringing down the data retrieval on stand by to 12 seconds while production to 85 seconds... The mystery still exists

Appreciate any help
Arif Khan

Project Manager / DBA
Weston/Loblaw - Corporate Systems Department *(416) 922 1383 x 5291
* Arif.Khan_at_Weston.ca

-----Original Message-----
Sent: Wednesday, April 23, 2003 2:29 PM
To: 'ORACLE-L_at_fatcity.com'
performance significantly different

Hello Every one

I have two identical dell servers with NT4 SP6. They are identical in every respect (i.e Hardware and software both). One is a production server another is a stand by. Every night we simply slap all .ora files (data, log & control) from production on to stand by (hence data spread wise, statistics, fragmentation etc..they are the same).

Now here's the problem:
When I run a power builder application that retreives data from Production server, it takes 1:30 (One minute and 30 seconds) to return entire data set. While the same on the stand by server gets returned in 18 seconds.

Can any of you shed light on where to look at???

Appreciate any help

Thanks
Arif
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Arif Khan (GWL)
INET: Arif.Khan_at_Weston.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------