This discussion is archived
4 Replies Latest reply: Feb 7, 2013 4:24 PM by Ric Van Dyke RSS

AUTOTRACE stats different in SQL Developer vs SQL Plus

Ric Van Dyke Newbie
Currently Being Moderated
Using SQL Developer 3.2.20.09, database is 11.2 on Linux. I'd like to know why I get different stats when using AUTOTRACE in SQL Developer vs SQL Plus. If I do the following in SQL Developer and in SQL Plus I get a very different set of stats:

set autotrace on
select * from emp;
set autotrace off

I run this with "run worksheet" in SQL Developer and I see this set of stats:

Statistics
-----------------------------------------------------------
4 user calls
0 physical read total multi block requests
0 physical read total bytes
0 cell physical IO interconnect bytes
0 commit cleanout failures: block lost
0 IMU commits
0 IMU Flushes
0 IMU contention
0 IMU bind flushes
0 IMU mbu flush


I do the same in SQL Plus and I see these stats:

Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
7 consistent gets
0 physical reads
0 redo size
1722 bytes sent via SQL*Net to client
519 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
14 rows processed

A very different set of stats. The stats in shown in SQL Plus seem to be much more useful to performance optimization over the one shown in SQL Developer. Why the different set of stats for each? Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points