Home » RDBMS Server » Performance Tuning » slow in all aspects
slow in all aspects [message #273802] Thu, 11 October 2007 13:49 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member



Dear tuning guys,

In our database everything seems very slow , this is very new database for eg:

If connect > conn username/password@database

it takes near 1 min to connect the session,

also for eg:If we execute

> select count(*) from v$session:

it takes 1min to execute the query.

All query takes long time to execute i dont know it is oracle issue or network issue or OS issue

I have checked the ram,cpu all are seems more enough,really this is very different case to me,plz help to overcome this problem


oracle databse :oracle 9i
Os :redhat linux(advanced version)



- Thanx in advance.


Re: slow in all aspects [message #273803 is a reply to message #273802] Thu, 11 October 2007 13:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/

what does "top" show?

[Updated on: Thu, 11 October 2007 13:52] by Moderator

Report message to a moderator

Re: slow in all aspects [message #273807 is a reply to message #273802] Thu, 11 October 2007 14:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate trace and check where the session is spending its time.

Regards
Michel
Re: slow in all aspects [message #273821 is a reply to message #273807] Thu, 11 October 2007 15:55 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member


Thanx anacedent and Michel


The problem was due to compatible now it has been solved.





Re: slow in all aspects [message #273852 is a reply to message #273821] Fri, 12 October 2007 00:05 Go to previous message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In which way? Can you explain?

Regards
Michel
Previous Topic: SGA and PGA
Next Topic: DB link problem
Goto Forum:
  


Current Time: Wed Jun 12 18:27:02 CDT 2024