I've been trying to find out if there are uncommitted INSERT, UPDATE or DELETE statements in my current session. I know one way would be is to check the v$lock with the current SID but that means I need read access to v$lock. That's a problem since my DBA doesn't want to grant me that. Is there another way?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!