Home » RDBMS Server » Server Administration » Database Slows down after some time
Database Slows down after some time [message #153220] Fri, 30 December 2005 01:37 Go to next message
tayalarun
Messages: 20
Registered: December 2005
Junior Member
Hi,


I am working on Oracle 8i (8.1.7) on sun solaris with 512MB of RAM size.



After running the server for around 2 - 3 hours, the response time is increasing i.e. the database goes slow

what could be the problem and where to look for the solution.


Arun

Report message to a moderator

Re: Database Slows down after some time [message #153225 is a reply to message #153220] Fri, 30 December 2005 02:45 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Start by looking at the OS, look at commands like:

"prstat -a" to identify top resource consumers
"swap -l" to monitor swap space
"vmstat" monitor memory utilization, paging and swapping
Etc.

Best regards.

Frank

Report message to a moderator

Re: Database Slows down after some time [message #153276 is a reply to message #153225] Fri, 30 December 2005 14:11 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member
After doing what frank has suggested ..
check for the wait events in the db and see if there is any process in the db / automated job that is eating up the resouces ..

Also for this kinda problems you should allways mention the Server h/w model, no of cpu's, load observed when the problem happened etc., ..

-Sai Jeedigunta

Report message to a moderator

Previous Topic: find table and index are using or not
Next Topic: ERROR in executing triggers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 13:36:10 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.