Hi all,One of the quickest ways to help with the SQL tuning is by getting the SQL Monitor Report.You have a lot of options to get this, like SQL Developer, OEM, command line, etc.To get this using the command line, you can use:set linesize 1000 pagesize 100 verify off trimout on trimspool on echo off head off feed off timing off termout off long 1000000 longchunksize 1000000
set serveroutput on size 1000000
spool sqlmon.html replace
clear scr
select dbms_sqltune.report_sql_monitor(
sql_id => 'YOUR_SQL_ID',
report_level=>'ALL',
...
