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.