connect to your database

alter session set timed_statistics = true
alter session set sql_trace=true

run your query

then find the trace file (show parameter udump)

then run tkprof

tkprof report.txt (this will be the output this will show the execution plan for the statement)