Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to get all SQL queries of a sid during a transaction

How to get all SQL queries of a sid during a transaction

From: <darthmind_at_gmail.com>
Date: 13 Jul 2005 13:26:31 -0700
Message-ID: <1121286391.792956.3310@g44g2000cwa.googlegroups.com>


Via v$session, hash values and v$sql I can get the SQL of the last query a sid
executed. Is there a way to get all of the queries (in fact stored in v$sql)
of a sid in a transaction involving multiple queries, and how?

tia

-t Received on Wed Jul 13 2005 - 15:26:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US