I was wondering if there is a way to capture "resource intensive" SQL statements in the database without turning
the trace on.

I want avoid turning tracing on in the production database
and also avoid generating lot fo trace files.

Are there any useful SQL statements to capture "resource intensive" SQL statements?


TIA