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 452 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: 65144
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: SMON TOP PROCESS
Next Topic: lots of waits sql*net
Goto Forum:

Current Time: Sat Aug 19 22:50:42 CDT 2017

Total time taken to generate the page: 0.43025 seconds