| SQL Developer v2.1.1.64 (Build MAIN-64.45), Oracle 9i and Autotrace [message #486556] |
Thu, 16 December 2010 10:11 |
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
|
Senior Member |
|
|
Hey all,
Does auto trace work correctly in the posted version of SQLDev and my version of oracle?
I suspect not, it seems to be giving really unusual outputs, for example joining 7m row table with a 4m row table is reporting 273 consistent gets and no physical. That seems an awfully low volume of gets for the query and indeed when I run the trace in sql*plus its...well...its still running actually, sql dev threw it back in 0.172 seconds.
I suspect its iffy but google came up dry, or I dont know how to phrase the question.
is showing as 4 cons. gets and a sort (run repeatedly).
The above makes me pretty sure is goosed....but you guys know more than I
Any help would be grand.
Cheers
[Updated on: Thu, 16 December 2010 10:12] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
