Hello all,

Iam involved in a project which is been developed using J2EE and Oracle 9i as our database...

I got 2 servers ,Test and Production server.

The test server is a normal pc with low configuration which has only 1gb memory with single processor and my prodution server is a IBM machine with multiprocessor and 2 gb or memory..

My problem is when I was trying to retrive data in GUI its taking loats of time and its not populating all the information ,but when i deleted some of the data in Oracle , the retrival is quiet fast...

Can someone in this group suggest me some tips to make the oracle retrival
faster???(Can i do database tunning in oracle??)

If anyone is expert in tunning pls give me some tips to solve this problem...

Regards
Jack