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!

What exactly is V$TRANSACTION used for ?

greenyApr 13 2017 — edited Apr 13 2017

version: 11.2.0.4 (Oracle Linux 6.5)

Official documentations just mentions the following as the description for V$TRANSACTION view.

"V$TRANSACTION lists the active transactions in the system."

https://docs.oracle.com/cd/E18283_01/server.112/e17110/dynviews_3114.htm

I have a very busy 3-node RAC DB. When I query GV$TRANSACTION, it shows only 1 or 2 rows at any given time. Sometimes, none

But, at the same time there roughly 70 active sessions (gv$session.status = 'ACTIVE' ) in each instance. At least half of active sessions will be DMLs.

Then why is GV$TRANSACTION listing only 2 rows. What do they mean by 'Transaction' ?

So, what exactly is gV$TRANSACTION listing ?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2017

Added on Apr 13 2017

#general-database-discussions

9 comments

2,366 views