Home » SQL & PL/SQL » SQL & PL/SQL » SQL Tunning (Oracle 9i)
SQL Tunning [message #327913] Wed, 18 June 2008 06:32 Go to next message
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
Re: SQL Tunning [message #327916 is a reply to message #327913] Wed, 18 June 2008 06:34 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Check Physical gets and consistent gets value??

Regards,
Rajat Ratewal
Re: SQL Tunning [message #327919 is a reply to message #327916] Wed, 18 June 2008 06:37 Go to previous messageGo to next message
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.
Re: SQL Tunning [message #327923 is a reply to message #327919] Wed, 18 June 2008 06:45 Go to previous message
Michel Cadot
Messages: 64107
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Need a query
Next Topic: Regular expression
Goto Forum:
  


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

Total time taken to generate the page: 0.08390 seconds