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

in the old days, many releases ago (up until 5.1) Oracle did not even support
COMMIT and ROLLBACK as SQL commands; 
for example, in SQL*Plus they were SQL*Plus commands. That is: no semicolon
needed to execute them, and they would not end up in the SQL buffer. SQL*Plus
would simply send the "appropriate" lower level commands to the database.

cheers,

Lex.
 
------------------------------------------------------------------
Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Alex Gorbachev
Sent: Sunday, October 09, 2005 11:53
To: Brandon.Allen@xxxxxxxxxxx
Cc: Christian.Antognini@xxxxxxxxxxxx; arun chakrapani rao;
oracle-l@xxxxxxxxxxxxx
Subject: 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>:
> Not true.
>
> SQL>select hash_value, sql_text from v$sql where upper(sql_text) in 
> SQL>('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
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD

Other related posts: