Speed up Session Running Slow

Community ForumCategory: DatabaseSpeed up Session Running Slow
matheusdba Staff asked 1 month ago

“Can we do anything if session is running slow no blocking session, We cannot kill session, and we want to complete sesson ASAP?”

1 Answers
matheusdba Staff answered 1 month ago

There is no such magic. 🙂
You need to understand why is your session running slow. But in general, any solution you may arrive (different of a lock) needs to be addressed for the next run of the query (any new plan, new fix, new index, stats gathering, etc etc…). So if it’s slow and running you need to decide: Kill it and run it “hopefully” faster next time or just await?
Something that may help you on deciding this is checking status and estimations for the current session on the dba_longops. 😉