Dear all,

Last month, we have lost our server due to HDD failure and I have setup a new server:

Windows 2000 Server,
Oracle 8.0.5.

We have third party ERP system and I have restored the Schema as per vendor's manual,

the problem is The system is running very slow on client as well as on server.

what steps should I take to run it fast?

My DB file size is More than 2 GB.

Pls help.