Free Oracle Performance Analysis
Send us your AWR report or SQL statement, and a description of the issue, we’ll try our best to respond with findings and recommendations.
If you're sending an underperforming SQL query, please send:
- Explain plan output (execution plan)
- DDL for all tables.
- Index information.
- Execution statistics (autotrace, raw sql trace file or comparable)
Need help collecting this information? Click here for some tips.
Here are some simple techniques you can use to get an execution plan, execution statistics and DDL.
You can use SQL*Plus AUTOTRACE to get the execution plan and execution statistics of the query, like this (you usually need to run
it a couple of times before the execution stats stabilize):
orcl> set autotrace traceonly
orcl>
orcl> select * from scott.emp natural join scott.dept;
To get the DDL for all tables involved in your query, execute this for each table:
select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;
To get index statistics, execute this for each index:
select index_owner,index_name,column_name,column_position
from dba_ind_columns where table_owner='SCOTT' and table_name='DEPT';
Zip all files, and upload one zip file.
Note: One incident per organization.
Free Online Registration required
to use this feature.