Re: No data in the sql_address column of v$session
- From: Alex Gorbachev <gorbyx@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Sun, 9 Oct 2005 11:52:50 +0200
AFAIK, calling OCI function to commit/rollback should not generate any
statement. Using SQL statement to commit/rollback should produce a
statement v$sql. Correct me if I am wrong.
2005/10/4, oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>:
> Not true.
>
> SQL>select hash_value, sql_text from v$sql where upper(sql_text) in
> ('COMMIT','ROLLBACK');
>
> HASH_VALUE SQL_TEXT
> ---------- --------
> 1470906206 ROLLBACK
> 3615375148 COMMIT
> 3615375148 COMMIT
> 242587281 commit
--
Best regards,
Alex Gorbachev
--
//www.freelists.org/webpage/oracle-l
Other related posts:
