How do I know if there are uncommited transactions?
Posted on 2003-02-19
I'm quiet new to administering Oracle databases. I have some guys on my db running big updates on some tables. From time to time I need to shutdown the system for maintenance, but before I can do that I need to know if there are some uncommitted transactions on the db. Otherwise I would rollback all the possibly uncommited updates, which is not, what my colleagues want. And no, they don't want to use autocommit...
So how can I find out, if there are uncommited transactions?
Oracle version is 184.108.40.206.0 Enterprise Ed. on Solaris 8.
Thanks for your help.