This content has been marked as final. Show 4 replies
enable SQL_TRACE for long running sessions/queries
Process trace files with TKPROF which will document where time is being spent
user9365086 wrote:And what if the query is an 8 hour query? Or perhaps a 9 hour query running 8 hours which means it is actually tuned and fast?
In our production database, some queries are running more than 8 hours per day.
A query running slow is an observation. Not a problem.