0 Replies Latest reply: Jun 19, 2013 3:58 AM by user2550925 RSS

    How to see the statistics in Oracle Cloud.

    user2550925


      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.