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
vasudevan
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 9.2.0.7.0,OS Linux
optimizer mode:choose
compatible : 9.2.0



-Thanx.
  • Attachment: ns(trc).doc
    (Size: 45.00KB, Downloaded 1625 times)

Report message to a moderator

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: 68665
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"?

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 10:09:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.