Re: Performance problems oracle 8i

legedoos@xxxxxxxxx wrote:
> Hi there!
>
> We have a problem. We are converting data of a database to an oracle
> environment. Therefore we have a production server (win 2000 4
> processors, a bulk of memory) and a test server (win 2000, only one
> processor, less memory). The production server should be faster than
> the test server.
>
> We wrote lots of scripts on the test environment and this all was ok.
> But now we're trying the scripts on the production server and it all
> works very slow.
>
> For testing we copied the production db to the test db, so the table
> spaces, tables, indexes where exactly the same. We use Spotlight to
> monitor the servers. What I can see is that the production server uses
> lots more Physical Reads/s for the same query than the test server.
> The test server finishes the script in 5 minutes, and the production
> server took all night and wasn't finished this morning.
>
> Settings like SGA, buffer size and archive logging are the same on
> both servers.
>
> Anyone an idea about what can be the problem?

Not much: Could it be that you didn't copy statistics or deleted them
afterwards? Did you check execution plans? How did you copy the db? Did
you copy files or did you use some form of export / import? Are all
indexes ok or are there some that are corrupt or need otherwise
rebuilding?

HTH

robert

.

Relevant Pages

  • Re: Performance problems oracle 8i
    ... > processor, less memory). ... The production server should be faster than ... W2K does not support a bulk of memory, ... > But now we're trying the scripts on the production server and it all ...
    (comp.databases.oracle.misc)
  • Re: Oracle 10gR1 Memory Problem - Please help
    ... One of the Oracle 10gR1 Production Server faced few memory problems. ...
    (comp.databases.oracle.server)
  • Re: Wierd Primary Key issue
    ... > I am trying to transfer selected data from my production server to my test> server. ... I have registered my production server as a linked> server on my test server. ... > Violation of PRIMARY KEY constraint 'PK_OrderID'. ...
    (microsoft.public.sqlserver.tools)
  • Re: recovering root password, was Help!Help!Help!
    ... > I need to know how to change or eliminate a root password. ... > and eliminated our online site, and all our data we have spent two ... > compalints our from our ISP that our server was trying to agressively ... make another backup of your test server. ...
    (freebsd-questions)
  • Re: Grant Object Access
    ... Now that I had resolved the issues on my test server, ... and performing the various system changes on the new production server, ... I had a similiar problem with this on the test server. ... >> has no control over the scheduled tasks in themselves (all the user can ...
    (microsoft.public.windows.server.security)