patternMinor
Oracle 11g see transaction or session start time
Viewed 0 times
11gseetimetransactionsessionstartoracle
Problem
I want to know when a session or transaction started. The deadlock file doesn't give me this information. Is there some logfile that keeps these records?
I've got a transaction id "TX-1234-abcd", a session number and some "DID 000-000ABCD" number.
I've got a transaction id "TX-1234-abcd", a session number and some "DID 000-000ABCD" number.
Solution
Franz
The view V$TRANSACTION likely gives you the information you require. The transaction id is the XID column,
The view V$TRANSACTION likely gives you the information you require. The transaction id is the XID column,
Context
StackExchange Database Administrators Q#12444, answer score: 5
Revisions (0)
No revisions yet.