Forum Stats

  • 3,814,933 Users
  • 2,258,933 Discussions
  • 7,892,890 Comments

Discussions

How know what SQL statements belongs a one transaction?

user12192929
user12192929 Member Posts: 1
edited Feb 25, 2013 6:54PM in General Database Discussions
SQL statements of a transaction.
How know what SQL statements belongs a one transaction?

Hi, I want to know SQL statements has a transaction, Is there a view v$?


Eg.

One transaction can consist of multiple SQL statements.
If some user will do this transaction with three statements.

SQL> update emp set ename='JOHNSON' where empno=1273;

1 row updated.

SQL> insert into hr.REGIONS values (5,'A1-land');;

1 row inserted.

SQL> delete from emp where empno=1200;

1 row deleted.

SQL> rollback;

Rollback complete.

All three SQL statements in this example belong one transaction. The transaction ended with the ROLLBACK statement.


as DBA, how can i see those three statement???
Tagged:

Answers

  • Aman....
    Aman.... Member Posts: 22,919 Gold Crown
    user12192929 wrote:
    SQL statements of a transaction.
    How know what SQL statements belongs a one transaction?

    Hi, I want to know SQL statements has a transaction, Is there a view v$?


    Eg.

    One transaction can consist of multiple SQL statements.
    If some user will do this transaction with three statements.

    SQL> update emp set ename='JOHNSON' where empno=1273;

    1 row updated.

    SQL> insert into hr.REGIONS values (5,'A1-land');;

    1 row inserted.

    SQL> delete from emp where empno=1200;

    1 row deleted.

    SQL> rollback;

    Rollback complete.

    All three SQL statements in this example belong one transaction. The transaction ended with the ROLLBACK statement.


    as DBA, how can i see those three statement???
    Hmm logminer comes to the mind!

    Aman....
This discussion has been closed.