Help needed to make oracle retrival faster....
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