We have found that using dbms_stats.gather_schema_stats to be the most effective way to improve Oracles performance in Insight. This needs to be done for the whole schema. We have also seen better results by first deleting your statistics before gathering. Use the following procedures to build your statistics.
begin
dbms_stats.delete_schema_stats (ownname=> 'YourSchemaHere');
end;
/
begin
dbms_stats.gather_schema_stats (ownname=> 'YourSchemaHere', cascade=>
TRUE);
end;
/
(Of course, replace "YourSchemaHere" as necessary.)