SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

active sessions and sessionID

ANNECDec 17 2019 — edited Dec 19 2019

I am using Oracle 12 C and SQL developer 19.1

We have application that runs query again the oracle database, users run the long queires at the same time since this is the peak date time for printing that report.

We have optimized query, but sometimes if too many concurrent users run this , it could wait for a long time and causes block.

I am using the report-active sessions screen to monitor active sessions, I can see column up_time.

I guess this is the time that since session start to end.

Is there a way that on the active sessions screen I can find the session Number, so that if I find a long run session, I would kill it.

Thanks

This post has been answered by Glen Conway on Dec 19 2019

Jump to Answer

Added on Dec 17 2019

#sql-developer

8 comments

824 views