Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Help !!! : Identical servers with V 7.3.4.0 on NT4, Application p

Help !!! : Identical servers with V 7.3.4.0 on NT4, Application p

From: Arif Khan (GWL) <Arif.Khan_at_Weston.ca>
Date: Wed, 23 Apr 2003 11:27:24 -0800
Message-ID: <F001.00587F79.20030423112724@fatcity.com>


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). Received on Wed Apr 23 2003 - 14:27:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US