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

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_at_freelists.org <oracle-l-bounce_at_freelists.org>:
> 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