Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

up vote 3 down vote accepted

the only way I am aware of is to use Oracle logminer

the archivelogs are used if a database was restored from a backup and must be rolled forward to a point in time where the database crashed. (almost) all information that written to the database therefore is contained in the redologs so that this roll forward can be done. Logminer can be used to analyze the contents of archivelogs (redologs). but using the logminer is very cumbersome. you need a database with dba privileges (it must not be the same databaase where your transaction was applied but of the same version an os system) and you need the archivelogs that contain your transaction. I am not sure if the details are well documented so i think you need a some knowledge about oracle internals and i think this is a job for an adventurous database administrator.

share|improve this answer

Franz

The view V$TRANSACTION likely gives you the information you require. The transaction id is the XID column,

share|improve this answer
    
yeah thanks, but that are only the active ones. I'm trying to access old stuff. –  Franz Kafka Feb 8 '12 at 13:47
1  
you could try the "versions of" flashback query in that case. –  Niall Litchfield Feb 8 '12 at 17:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.