OraFAQ Forum: Performance Tuning » Server gets slow after some days of fresh import

Home » RDBMS Server » Performance Tuning » Server gets slow after some days of fresh import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Server gets slow after some days of fresh import [message #65464]

Sat, 25 September 2004 22:10

gurinder
Messages: 16
Registered: September 2004

Junior Member

Sir we have tow servers one is active and one is inactive both has oracle databse when we drop user and import fresh data from other server which is active the performance of server becomes very fast but after some days like 10-15 days it starts becoming slow and slow the system speed becomes sluggish and agian we do the same process change the server and other make as active than it agian becomes fast can u please tell me where the problem can be or how can we locate the problem

Gurinder

Report message to a moderator

Re: Server gets slow after some days of fresh import [message #65465 is a reply to message #65464]

Mon, 27 September 2004 00:07

easywebtech
Messages: 20
Registered: August 2004

Junior Member

Hi,
there are lots of reasons for that.Mainly because of indexes. that is why when you import the schema it readjusted.
So go through oracle fine tune notes.

here is a good link.
http://www.easywebtech.com/oracle.html

webmaster
www.easywebtech.com

Report message to a moderator