Home » Other » Client Tools » SQL Developer v2.1.1.64 (Build MAIN-64.45), Oracle 9i and Autotrace (Oracle 9.2.0.8 // JServer Release 9.2.0.8.0)
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.

Select * from dual
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

Previous Topic: Oracle 8i
Next Topic: about oracle monitoring
Goto Forum:
  


Current Time: Fri Mar 29 05:19:11 CDT 2024