Skip to Main Content

Oracle Database Discussions

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!

Identify the long running transactions in the database.

hsemarSep 12 2015 — edited Sep 13 2015

Hi,

I'm trying to identify the long running transactions/Queries in the past 7 days.   Any sessions/Query running more than 60 minutes,  need the information.

how we can get that information from the oracle database.

Regards,

Ramesh G

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2015
Added on Sep 12 2015
7 comments
5,311 views