OraFAQ Forum: Performance Tuning » Query running more timeand then time out message

Home » RDBMS Server » Performance Tuning » Query running more timeand then time out message (Oracle, 9i ,window xp)

Tue, 21 October 2008 06:38

psamarpan
Messages: 6
Registered: October 2008
Location: Bangalore

Junior Member

Hi All,

My query taking more to run and then through time out message.

Could somebody help on this issue

Thank you so much

Tue, 21 October 2008 06:47

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

Senior Member
Account Moderator

Unacceptable post.

please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

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

Then provide the requested and usual information.

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

Regards
Michel

Previous Topic:	ORA-03113 after performance tuning
Next Topic:	Query Optimization (merged)

Goto Forum:

]

Current Time: Tue Nov 26 09:24:47 CST 2024