This discussion is archived
0 Replies Latest reply: Jun 19, 2013 1:58 AM by user2550925 RSS

How to see the statistics in Oracle Cloud.

user2550925 Newbie
Currently Being Moderated


While executing the select command, how can i see the execution plan and statistics in oracle cloud SQL Command Window

select * from test_random where empno=1000;

 

I need to find the consistent read and physical reads of the particular query.

 

When I tried to execute the following command

 

SET AUTOTRACE ON EXPLAIN STATISTICS

 

I am getting error.

Legend

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