Home » RDBMS Server » Server Administration » Slow performance
Slow performance [message #235127] Fri, 04 May 2007 02:36 Go to next message
california_6_1
Messages: 29
Registered: February 2007
Junior Member
I would appreciate, if someone please take a moment to answer this question:

I have Oracle 9i running on Solaris. At times the database responses becomes very slow. I dont know, where to start troubleshooting from? I would really appreciate, if someone please advice.

Many thanks in advance,
Cali

Report message to a moderator

Re: Slow performance [message #235147 is a reply to message #235127] Fri, 04 May 2007 03:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Start with StatsPack.
Read spdoc.txt in $ORACLE_HOME/rdbms/admin directory.

Regards
Michel

Report message to a moderator

Re: Slow performance [message #235205 is a reply to message #235147] Fri, 04 May 2007 05:58 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Also I would start to look a the machine (CPU/Memory/Disc IO) when it is slow.

One thing that can cause a normaly faster DB to grind almost to a halt is when the machine starts swapping memory to disk.

Report message to a moderator

Re: Slow performance [message #235209 is a reply to message #235205] Fri, 04 May 2007 06:06 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
You should look into these commands on Solaris if you're not familiar with them
ps
top
sar
mpstat
iostat
vmstat
A good "toolbox"

Report message to a moderator

Previous Topic: How to recreate control file
Next Topic: Tablespace Allocation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:41:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.