Check commit or rollback
Suuny, June 10, 2020 - 10:59 am UTC
Can we check commit or rollback issue by "session 1" using system event ?
June 13, 2020 - 9:38 am UTC
If session 1 is blocking someone, then by definition it has not committed.
You can also check v$locked_object to see if a session has an open transaction
select statement
A reader, June 17, 2020 - 11:09 am UTC
Can normal select statement block another session?
Because I check many times my count(*) select query on just single table become blocker for another session.
June 17, 2020 - 2:33 pm UTC
I'd need to see some proof of that
A reader, June 18, 2020 - 11:24 am UTC
Can you give a what kind of information you required so i collect it for further investigate?
June 18, 2020 - 1:34 pm UTC
Look at v$locked_object, and look at the blocking_... columns in v$session