OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Slow performance

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

Slow performance [message #235127]

Fri, 04 May 2007 02:36

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 01 05:34:30 CST 2025