Home » RDBMS Server » Performance Tuning » Query running more timeand then time out message (Oracle, 9i ,window xp)
Query running more timeand then time out message [message #354810] Tue, 21 October 2008 06:38 Go to next message
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
  • Attachment: 30409.txt
    (Size: 2.91KB, Downloaded 121 times)
Re: Query running more timeand then time out message [message #354812 is a reply to message #354810] Tue, 21 October 2008 06:47 Go to previous message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
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: Thu Dec 08 06:26:50 CST 2016

Total time taken to generate the page: 0.21530 seconds