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
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: 64107
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
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: 3189
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.
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"
Previous Topic: How to recreate control file
Next Topic: Tablespace Allocation
Goto Forum:
  


Current Time: Mon Dec 05 04:42:20 CST 2016

Total time taken to generate the page: 0.24156 seconds