With SQL Plus for Oracle Database, I'm able to call

SET autotrace on

after which see Execution Plan, statistics, etc.

However , I would like use of details about the Execution Plan and statistics during my Java program. I routinely have done something similar to this to carry out a sql statement,

Connection connection = //INITIALIZE HERE

Statement getColumn = connection.createStatement()

ResultSet results = getColumn.executeQuery("Place SQL QUERY HERE")


It is possible to way I'm able to obtain the Execution Plan and Statistics? Thanks.

You are able to query the V$SQL_PLAN table to obtain the explain plain. Alternatively you are able to query the program_TABLE, you can observe more particulars about this HERE.