OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Query is slow

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

Query is slow [message #180291]

Sun, 02 July 2006 22:18

Tai
Messages: 8
Registered: February 2002

Junior Member

Hello everyone,

When I perform a query on table, the query result is kind of slow. How do I check the database and how I do make query faster?

I'm using Oracle9i 9204 on Sun Solaris 9.

Thank you.

Report message to a moderator

Re: Query is slow [message #180295 is a reply to message #180291]

Sun, 02 July 2006 23:27

imtj
Messages: 12
Registered: July 2006
Location: Chinese

Junior Member

Try
sql>select * from v$session_wait
Your see v$session_wait find out wait user and lock session.

Report message to a moderator

Re: Query is slow [message #180323 is a reply to message #180291]

Mon, 03 July 2006 02:02

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"Query is slow" is your subjective feeling, or did you measure it? What does Explain Plan say about it? Do you have your tables and indexes analyzed? Do you have indexes at all? Are they used?

How to make a query faster? Tune it!

Report message to a moderator

Previous Topic:	Pls advice about this EXECUTION PLAN
Next Topic:	Index Creation Speed-up

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 06 12:53:31 CST 2025