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
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: No data in the sql_address column of v$session
From: Lex de Haan

References:
- RE: No data in the sql_address column of v$session
  - From: Brandon . Allen

Re: No data in the sql_address column of v$session

Other related posts: