OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » SQL Tunning (Oracle 9i)

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

SQL Tunning [message #327913]

Wed, 18 June 2008 06:32

subbu_tce
Messages: 98
Registered: July 2007
Location: pune

Member

Dear All,
The cost of the query is less but still its running very slow.What could be the reason?Can anybody please help about sql tunning.
Thanks,
Subramanian,sp

Report message to a moderator

Re: SQL Tunning [message #327916 is a reply to message #327913]

Wed, 18 June 2008 06:34

rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA

Senior Member

Check Physical gets and consistent gets value??

Regards,
Rajat Ratewal

Report message to a moderator

Re: SQL Tunning [message #327919 is a reply to message #327916]

Wed, 18 June 2008 06:37

subbu_tce
Messages: 98
Registered: July 2007
Location: pune

Member

Am new to sql tunning.so could you please send me any tutorials to know about sql tunning.

Report message to a moderator

Re: SQL Tunning [message #327923 is a reply to message #327919]

Wed, 18 June 2008 06:45

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

Senior Member
Account Moderator

You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

You can also have a look at Database Performance Tuning Guide.

Regards
Michel

Report message to a moderator

Previous Topic:	Need a query
Next Topic:	Regular expression

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 15:11:27 CST 2024