Tagged Questions
9
votes
1answer
267 views
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Background: I'm working on http://sqlfiddle.com (my site), and am trying to prevent one avenue of abuse possible there. I'm hoping that by asking about a problem I'm currently addressing, I don't ...
3
votes
2answers
493 views
Oracle 11g see transaction or session start time
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 ...
3
votes
1answer
260 views
Find out if two rows came from same transaction in Oracle
I am using Oracle 11.1 and would like to figure out if two rows in one table where inserted by the same transaction.
Is there an easy sql statement to map a row to an transactions id? The table is an ...
14
votes
7answers
4k views
Oracle - Any way to view uncommited changes to a particular table?
I'm debugging through a batch proess currently that does a lot of DML statements, but doesn't do a commit right away. It would be nice to be able to view the "pending" changes while the transaction ...
1
vote
1answer
252 views
Difference between Flashback Query and Serializable Transaction Mode?
Is there any conceptual difference between a SERIALIZABLE Transaction and a Flashback Query?
4
votes
1answer
2k views
Current isolation level in oracle
How to get the current (default) transaction isolation level in oracle?
