Home » RDBMS Server » Performance Tuning » Sql slow query plan
Sql slow query plan [message #267143] Wed, 12 September 2007 10:19 Go to next message
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Dear tuning specialist,

Here i have attached the sql plan for our slow query it seems too slow,there is anyway to tune the sql query by using parameters

Details : oracel server 9i,version,OS Linux
optimizer mode:choose
compatible : 9.2.0

  • Attachment: ns(trc).doc
    (Size: 45.00KB, Downloaded 384 times)
Re: Sql slow query plan [message #267150 is a reply to message #267143] Wed, 12 September 2007 10:35 Go to previous message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ We don't download doc file
2/ A plan is not sufficient many more data are necessary
3/ Why do you think it is "too slow"?

Previous Topic: Too much memory consumed in SGA
Next Topic: lots of waits sql*net
Goto Forum:

Current Time: Mon Oct 24 17:01:26 CDT 2016

Total time taken to generate the page: 0.08650 seconds