7

How can I see open transactions in Oracle ? I'm doing a custom performance tool, and I'd like to see the number of currently open transactions. Is there a SQL request to do that, or another way to gather this information ?

Valentin Rocher
  • 11,667
  • 45
  • 59

1 Answers1

8

Use view v$transaction

Tony Andrews
  • 129,880
  • 21
  • 220
  • 259